It will try to fit the transaction in a cyclic fashion to all existing extents. Once it found an extent is in use then it forced to acquire a new extent (No. of
Rollback segment dynamically extent to handle larger transactions entry loads. A single transaction may wipeout all available free space in the Rollback Segment
By querying DBA_SEGMENT table/view.
Latest Answer: +This is the view we should use to see the allocation space +Both the views return the same result.=============================================select name,sum(bytes)"allocated space in MB" from dba_data_files/v$datafile==============================================Thanks ...
Querying the DBA_ROLLBACK_SEGS viewIN USE - Rollback Segment is on-line.AVAILABLE - Rollback Segment available but not on-line.OFF-LINE - Rollback
Latest Answer: The following views help in monitoring rollback segment usage: DBA_SEGMENTSDBA_ROLLBACK_SEGSV$ROLLNAMEV$ROLLSTATV$TRANSACTION ...
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. Transaction Begins. An entry is made in the RES header for new transactions entry Transaction acquires blocks in an extent of RBS The entry attempts to wrap into second extent. None is available, so that the RBS must extent. The
Limit the number of extents in the tableSeparate Table from its indexes.Allocate Sufficient temporary storage.
Calculate the total header sizeCalculate the available dataspace per data blockCalculate the combined column lengths of the average rowCalculate the total average row size.Calculate the average number
It is possible to use raw devices as data files and what is the advantages over file. system files ?
Yes. The advantages over file system files. I/O will be improved because Oracle is bye-passing the kernnel which writing into disk.Disk Corruption
Database overall physical architecture is maintained in a file called control file. It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control
Shutdown the databaseCopy one of the existing control file to new locationEdit Config ora file by adding new control file. nameRestart the database.
Latest Answer: +Before to insert new control files,we should verify the existing control files location+these are the ways to find it=======================================================1.show parameter control_files2.select value from v$parameter where name='control_files'=======================================================+Both ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 Next >>
Go Top
