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

balakrishna

• Oct 8th, 2005

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

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

Shrikant Pande

• Aug 24th, 2005

Better performance, proper use of space .

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

Depends upon the storage parameters.

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

balakrishna

• Oct 8th, 2005

To avoid the space wastage we use OPTIMAL parameter.

Answer Question  Select Best Answer

Satyanarayana AMV

• Jun 18th, 2005

It Sotres the Oracle Data Dictionery

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

Create rollback segment roll1tablespace roll1;

Answer Question  Select Best Answer

balakrishna

• Oct 8th, 2005

By correctly fixing optimal size

Answer Question  Select Best Answer

Srikanth

• Dec 14th, 2005

Due to syntax errors

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

balu

• Oct 8th, 2005

By specifying the storage clause while creating table.

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

Agathian

• Sep 7th, 2005

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

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

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

Answer Question  Select Best Answer

Kishore Kumar Vuthpala

• Apr 11th, 2006

Hit Ratio is the ratio of shared SQL and PL/SQL items found in the Library Cache versus physical storage.It can also be defined in a mathematical expression as  1 - ((physical reads) / (db block gets + consistent reads))

Answer Question  Select Best Answer

 Each block contains entries as followsFixed block headerVariable block headerRow Header,row date (multiple rows may exists)PCTEREE (% of  free space for row updation in future)

Anu

• Oct 3rd, 2006

A block is divided into1. Header2.free space3.data spaceThe free space is in the middle shrinks as header and data space grow.Space usage in the data space :The data space is managed with 2 parameters...

Answer Question  Select Best Answer

 To manage the database level transactions such as modifications of the data dictionary table that record information about the free space usage.

Anu

• Oct 3rd, 2006

1.System tablespace is required in all databases.2.It is created with the database.3.Contains the data dictionary and stored program units.4.Contains SYSTEM undo segment.

Answer Question  Select Best Answer