What is the approach taken by Oracle to pass ACID test of a database transaction?
what is a cluster and how it is used
Latest Answer: An Oracle Database Cluster is a set of database instances on different nodes accessing the database related files on a shared storage. ...
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 and control
Latest Answer: Ckpt (checkpoint) is a background process. It synchronize SCN of all the database files like datafiles, control files and redo log files. ...
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
Latest Answer: Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache. ...
SGA and ORACLE background processes constitute an ORACLE instance. (or) Combination of memory structure and background process.
Latest Answer: Oracle Instance is an combination of background process and memory structures. ...
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: System Global Area (SGA) is component of instance which consist shared memory & control information of the instance It consist of shared pool, database buffer cached, redo log buffer, large pool, Java pool. ...
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: Database buffers consists of the dirty blocks. When ever we are trying to update some table/etc. First it verifies whether the data exists in database buffer , If not it fetches the information from data files to database buffer. So the modified values ...
View page [1] 2 3 4 Next >>
Go Top
