Latest Answer: Due to syntax errors ...
Latest Answer: By Dba_segments and DBA_extents and dba_free_space views. ...
Latest Answer: by using dictionaray view's called v$rollstat,dba_rollback_segs. ...
List the sequence of events when a large transaction that exceeds beyond its optimal value when an entry wraps and causes the rollback segment to expand into another extend.
Latest Answer: by specifying the storage clause while creating table. ...
Latest Answer: Calculate the total header size.Calulate the available data space per data block.Calulcate the combined column length by the avarge row.Calultate total average row size.Calculate avarge number of rows that can fit in data block.Calulate the number of ...
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: 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. ...
Latest Answer: when ever changes happend to the database previous change will be there in the rollback segment. ...
View page << Previous 7 8 9 10 [11] 12 Next >>

Go Top