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 : Hi,Database buffers are used to store copy of data of data blocks that has been used recently.the set of database block buffers are called db buffer cache.redo log buffers are used to store temorary entries for redo that supose to written to redo logfiles.thanksAlok. ...
Latest Answer : Alter table < Table_Name> move tablespace ; Alter index rebuild tablespace ; ...
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 ...
Latest Answer : store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace application specific data in respective tablespaces.place ...
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 : 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.