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. …

In today’s article, we will cover the features and important parameters of Parameter Files in Oracle. When opening the database, the parameters in this file …

In today’s article, we will explain what a password file is, how to create it and how to use it. For non-SYS users, a password …

In today’s article, we will be learning how to Control File Location and size information in Oracle. The information kept in the control file is …

In today’s article, we will be explaining Add Member to Redo Log Group and Increasing the Size of a Redo Log Group. A new member …