It  is  the  set  of  before  image  data blocks that contain rows that are modified by a transaction.Each   Rollback  Segment  entry  must  be  completed  within   one rollback segment. A single rollback segment can have multiple rollback segment entries.

samiksc

 Profile Answers by samiksc Questions by samiksc

• Dec 29th, 2005

A rollback segment entry consists of image of pre-update value, block address, data file number, transaction ID and transaction status (active or committed). A single rollback segment may contain several rollback entries and several active transactions.

Answer Question  Select Best Answer

Srikanth

• Dec 14th, 2005

Due to syntax errors

Answer Question  Select Best Answer

Ravi Prakash Pichika

• Jun 6th, 2005

SGA - Stands for System Global Area, its a part of Memory structure! SGA consists of   Shared Pool Database Buffer Cache Redo Log Buffer Lock & Latch Management  & M...

nishit patel

• Mar 12th, 2005

SGA * stands for System/Shared Global Area* can be used/shared by all users* it is a part of memory structure of Instance* consists of memory components like 1> shared pool 2> Database cache 3...

Answer Question  Select Best Answer

sandeep vig

• Oct 13th, 2005

there are main two causes for reparsing1)the objects which the query is refrencing has been modified 2) or the parsed version of sql text has been aged out of the library cache.

praim Sankar

• Sep 1st, 2005

The Library Cache was introduced because parsing (and validating and checking privileges) is expensive in terms of CPU cycles.   Oracle uses a LRU/MRU mechanism to keep sql statements in cac...

Answer Question  Select Best Answer

balu

• Oct 8th, 2005

When ever changes happend to the database previous change will be there in the rollback segment.

Answer Question  Select Best Answer

balu

• Oct 8th, 2005

LGWR process wirtes all change vectors from theredo log buffer to online redo log file sequentially.

Answer Question  Select Best Answer

balu

• Oct 8th, 2005

By specifying the storage clause while creating table.

Answer Question  Select Best Answer

balu

• Oct 8th, 2005

By using dictionaray view's called v$rollstat,dba_rollback_segs.

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

By correctly fixing optimal size

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

Create rollback segment roll1tablespace roll1;

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

To avoid the space wastage we use OPTIMAL parameter.

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

Depends upon the storage parameters.

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

These r the extents which indicates data was not stored in the segment.

Answer Question  Select Best Answer

todearmurali

 Profile Answers by todearmurali Questions by todearmurali

• Sep 27th, 2005

To avoid row migration from future updates to the block pctfree is set.

Answer Question  Select Best Answer

todearmurali

 Profile Answers by todearmurali Questions by todearmurali

• Sep 27th, 2005

store data in tablespaces to avoid disk contension.system tablespace-recursive callsuserdata-users objectsindex tablespace-for indexesrollback segmnets-undo tablespace or manual rollback segmentsplace...

Answer Question  Select Best Answer

Agathian

• Sep 7th, 2005

Multiplexing Redo log file called Mirroing. ( Keeping multiple copies in different disks)

Answer Question  Select Best Answer

Praim Sankar

• Sep 1st, 2005

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 sto...

Answer Question  Select Best Answer

Shrikant Pande

• Aug 24th, 2005

Better performance, proper use of space .

Answer Question  Select Best Answer

Shrikant Pande

• Aug 24th, 2005

PCTFREE : This clause is used for future updation, If you increase PCTFREE value, There will be less rows inserted in block

Answer Question  Select Best Answer

Satyanarayana AMV

• Jun 18th, 2005

It Sotres the Oracle Data Dictionery

Answer Question  Select Best Answer