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 |
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is the role of PCTFREE parameter is Storage clause ?
How will you create multiple rollback segments in a database ?
How the log writer writes the data into database
What does LGWR do?
What is the functionality of SYSTEM table space ?
What constitute an ORACLE Instance?
What is the function of Lock (LCKn) Process?
What is the OPTIMAL parameter ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is an Oracle Rollback Segment?
What is a Multi-threaded Server Configuration?