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 |
When does LGWR write to the database?
Which parameter in Storage clause will reduce no. of rows per block?
Can a Tablespace hold objects from different Schemes in Oracle?
What is the significance of having storage clause ?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is an Oracle Data Block?
What is use of Rollback Segments In Database ?
What is Shared Pool?
What is an oracle database schema?
What is Server Process?
How the log writer writes the data into database