When will be a segment released?
Answer / orawhiz
When Segment is dropped.
When Shrink (RBS only)
When truncated (TRUNCATE used with drop storage option)
Is This Answer Correct ? | 2 Yes | 0 No |
What are disadvanteges of having raw devices ?
List the factors that can affect the accuracy of the estimations ?
What is a Rollback segment entry ?
How will you estimate the space required by a non-clustered tables?
How can you find the size of a database?
How will you create multiple rollback segments in a database ?
How will you swap objects into a different table space for an existing database?
Name the ORACLE Background Process?
What is the role of PCTFREE parameter is Storage clause ?
What are the functions of SMON?
Teradata: How can we know the indexed column in a table?
What is Cursor?