 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 : by correctly fixing optimal size ... Latest Answer : By Dba_segments and DBA_extents and dba_free_space views. ... 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. ... The System Global Area in a Oracle database is the area in memory to facilitates the transfer of information between users. It holds the Dictionary cache is information about the databse objects stored in a data dictionary table.
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
