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 is an Oracle Data Segment?

How will you create multiple rollback segments in a database ?

What is the maximum size of a oracle9i database?

What is hit ratio ?

What is User Process?

What is meant by Redo Log file mirrorring ? How it can be achieved?

How to define Data Block size in Oracle?

How the log writer writes the data into database

How will you monitor rollback segment status ?

Can a View based on another View in Oracle?

how oracle will recognise its space is 100gb if 100gb is allocated for it...

What is Shared SQL Area?

For more Oracle Architecture Interview Questions Click Here