In today’s article, we will be learning the storage structure of Oracle Database. Oracle Database storage structure consists of two structures: physical and logical. The …

In today’s article, I will explain the concept of the Database Writer Process, which retrieves data blocks modified by Insert, Update, or Delete operations from …

In today’s article, we will explain how we can learn the Processes Using Swap Space in Oracle. Processes using swap space: [crayon-676837bfe5d29456904376/] By the way, …

In today’s article, I will be explaining how we can learn about background processes running in the database. Background processes are kept in the v$process …

In today’s article, we will be examining the process structure in Oracle, which is a mechanism used by the operating system. Processes, a mechanism used …

In today’s article, we will examine the Shared Pool and its subcomponents, which are involved in almost every event that occurs in the database. Parsed …

In today’s article, we will be cover about the features of the Database Buffer Cache, the largest memory area in the SGA. • The most …

In today’s article, we will explain how we can find out the size of the PGA (Program Global Area) area in Oracle Database. The size …

In today’s article, I will be explaining how we can learn the size of the SGA (System Global Area) in Oracle. Size of SGA area; …

In today’s article, we will be examining the memory structure of the Oracle database. The memory structure of the Oracle database consists of two parts. …