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

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'

Lakshminarayan.

• Jun 13th, 2005

In above answer one correction is there,  For perticular transaction we can use fallowing syntax.  >set transaction use rollback segment 'name'

Lachi

• Jun 8th, 2005

For perticular transaction Alter system set rollback segment 'name'; For database, we can set in pfile. Rollback_segment='name'

Answer Question  Select Best Answer

Ravi Prakash Pichika

• Jun 11th, 2005

The Control File is a small binary file necessary for the database to start and operate successfully. Each Control file is associated with only one Oracle database. Before a database is opened, the co...

Answer Question  Select Best Answer

Ravi Prakash Pichika

• Jun 6th, 2005

PGA - Program Global Area  or the Process Global Area is a memory region that contains data and control information for a single server process or a single background process.   Th...

Answer Question  Select Best Answer