PGA - Program Global Area or the Process Global Area is a memory region that contains data and control information for a single server process or a single background process. Th...
Segments The level of logical database storage above an extent is called a segment. A segment is a set of extents which have been allocated for a specific type of data structure, and all are sto...
Database buffers are used to store copy of data of data blocks that has been used recently.the set of database block buffers are called db buffer cache.redo log buffers are used to store temorary entries for redo that supose to written to redo logfiles.
thanks
Alok.
Alok Kumar
Sep 22nd, 2005
Hi,Database buffers are used to store copy of data of data blocks that has been used recently.the set of database block buffers are called db buffer cache.redo log buffers are used to store temorary entries for redo that supose to written to redo logfiles.thanksAlok.
Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE parameter we can optimize the size of Data Dictionary Cache.
Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE parameter we can optimize the size of Data Dictionary Cache.
store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace...
The Control File is a small binary file necessary for the database to start and operate successfully. Each Control file is associated with only one Oracle database. Before a database is opened, the co...
Ans