Latest Answer : 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 ...
Latest Answer : Redo log buffer is circular buffer,lgwr writes these buffers in cyclic faishon.redo log buffers contains redo entreies which are used to reconstruct or redo chandes. ...
Answered by: Lachi on 2005-06-08 07:28:04For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name'
Latest Answer : In above answer one correction is there, For perticular transaction we can use fallowing syntax. >set transaction use rollback segment 'name' ...
Latest Answer : these r the extents which indicates data was not stored in the segment. ...
Latest Answer : Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks) ...
Latest Answer : LGWR process wirtes all change vectors from theredo log buffer to online redo log file sequentially. ...
The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the
The data dictionary cache is stored in an area in SGA called the Shared SQL Pool. This will allow sharing of parsed SQL statements among concurrent users.
It is area in memory that is used by a Single Oracle User Process.
Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.
