When will be a segment released?
- 1 Answers
- 4133 Views
- I also Faced
- E-Mail Answers
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 |
More Oracle Architecture Interview Questions
What is advantage of having disk shadowing/ Mirroring ?
What is a Control file ?
When does LGWR write to the database?
Can a Tablespace hold objects from different Schemes in Oracle?
What is the maximum size of a oracle9i database?
Diference between Oracle 9i and 10G.
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is Cursor?
How to find the current session sid
What is Shared Pool?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is an Oracle Data Segment?
Oracle General 
