![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions 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 ... 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. 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 ... Latest Answer : when ever changes happend to the database previous change will be there in the rollback segment. ... Latest Answer : Segment is droppedOn shrinkOn truncation (TRUNCATE used with drop option) ... Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||