Latest Answer : 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 stored in the same tablespace. For example, each table's ...
Latest Answer : Optimal Flexible Architecture is a set of configuration standard created to ensure reliable Ora installation that require little maintenance. It has a default file naming and Directory layout for naming convention and Directory distribution. It organizes ...
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 : to avoid the space wastage we use OPTIMAL parameter. ...
Latest Answer : create rollback segment roll1tablespace roll1; ...
Latest Answer : by correctly fixing optimal size ...
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 : when a user updated a particular table (for example 100 rows)...the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback ...