How will you create multiple rollback segments in a database ?

How will you create multiple rollback segments in a
database ?

Question Posted / guest

How will you create multiple rollback segments in a database ?..

Answer / guest

CREATE ROLLBACK SEGMENT rbs_one
TABLESPACE rbs_ts
STORAGE
( INITIAL 10K
NEXT 10K
MAXEXTENTS UNLIMITED )

Is This Answer Correct ?

1 Yes

0 No

More Oracle Architecture Interview Questions

What are Oracle Schema Objects?

What is a Parallel Server option in ORACLE?

How will you swap objects into a different table space for an existing database?

What is the function of Dispatcher (Dnnn)?

How the space utilisation takes place within rollback segments?

What is the OPTIMAL parameter ?

When Does DBWR write to the database?

How to find the current session sid

What is meant by recursive hints ?

What is Database Buffers ?

What constitute an ORACLE Instance?

What is the function of Lock (LCKn) Process?

For more Oracle Architecture Interview Questions Click Here