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. ...
Latest Answer : these r the extents which indicates data was not stored in the segment. ...
Latest Answer : Yes. Using raw files/devices for database can have a slight performance gain. Raw files are unformatted disk partitions that can be used as one large file. Raw devices have the benefit of no file system overhead, because they are unformatted partitions. ...
Latest Answer : 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 control file is read to determine if the database is ...
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. ...
Latest Answer : Disk shadowing or mirroring is done either using a software or a hardware utility called RAID. Disk shadowing enables another disk to take-over from a failed hard disk avoiding any downtimes. Generally Hardware fial-overs are enabled on all servers. ...
The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the
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