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 |
Can a View based on another View in Oracle?
How will you swap objects into a different table space for an existing database?
How does Space allocation table place within a block ?
How the log writer writes the data into database
What is meant by free extent ?
List the factors that can affect the accuracy of the estimations ?
What is an oracle database schema?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is an Oracle Data Dictionary?
How will you force database to use particular rollback segment?
What is the maximum size of a oracle9i database?
What is advantage of having disk shadowing/ Mirroring ?