![]() Related Questions Latest Answer : Alter table < Table_Name> move tablespace ; Alter index rebuild tablespace ; ... 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 : depends upon the storage parameters. ... Latest Answer : It Sotres the Oracle Data Dictionery ... Latest Answer : create rollback segment roll1tablespace roll1; ... Latest Answer : by correctly fixing optimal size ... 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 : 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||