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 is the use of Oracle Control File?
How to find the SGA Size
What is an Oracle Rollback Segment?
What is an Oracle SYSTEM tablespace and when is it Created?
What is the function of Lock (LCKn) Process?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is meant by free extent ?
What is the functionality of SYSTEM table space ?
What constitute an ORACLE Instance?
How will you monitor the space allocation ?
What is the maximum number of Lock Processes used?
When does LGWR write to the database?