What is the OPTIMAL parameter ?

Question Posted / guest

What is the OPTIMAL parameter ?..

Answer / orawhiz

OPTIMAL parameter is used to set the optimal length of a
rollback segment

Is This Answer Correct ?

1 Yes

0 No

More Oracle Architecture Interview Questions

What is hit ratio ?

How will you monitor the space allocation ?

What are the functions of SMON?

What are disadvanteges of having raw devices ?

• What is oracle Architecture?

How will you estimate the space required by a non-clustered tables?

When will be a segment released?

Can a Tablespace hold objects from different Schemes in Oracle?

What is the function of ARCH?

What is an Oracle Rollback Segment?

What Does DBWR do?

What is an Oracle Data Segment?

For more Oracle Architecture Interview Questions Click Here