what is a cluster and how it is used
Why oracle is called kernel packagecomponents of oracle tablesql system variables local and global variables
Latest Answer: sga stands fro system global area.. which is the part of the oracle instance(includes memory struture and background processes). for faster executon and better performance everthing comes in the sga.so sga is located in oracle instance,,, which itself ...
Latest Answer: The Oracle call interface (OCI) The Oracle call interface is the lowest level at which client programs are intended to interact with Oracle. This interface is well documented and provides access to most of the functionality of Oracle, including ...
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files
Latest Answer: HiThe checkpoint (CKPT) process frees up limited memory space and ensures instance recovery. It is a background process that monitors the number of dirty buffers that have not been written to disk. Depending on the LOG_CHECKPOINT_INTERVAL parameter, it ...
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
Latest Answer: Its a part of shared pool and both comes under sga by default ...
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
Latest Answer: A system Global Area and Oracle Background Processes together consitute an Instance. ...
The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
Latest Answer: It is a shared memory region allocated by oracle that contains data and control information for an Oracle Instance. An SGA compromises of Buffer Cache, Redo Log Buffers and Shared Pool Area. ...
Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
Latest Answer: Buffer Cache Stores the most recently used blocks of data. It can also have modified data that has not permenently written to disk. When a row in a table is updated the foreground server processes reads the datafile information on the disk in to the ...
Redo Log Buffer stores redo entries a log of changes made to the database.
Latest Answer: It stores redo log entries a log of changes made to a Database. ...
View page [1] 2 3 4 Next >>
Go Top
