Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by free extent ?
- 2 Answers
- 5164 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manvendra
FREE EXTENT MEANS UNALLOCATED AREA OF A SEGMENT.
WHEN WE DELETE DATA FROM TABLE, EXTENT OF CORROSPONDING
SEGMENT BECOMES FREE.
BUT IF WE ARE TRUNCATING A TABLE IT REMOVES EXTENTS ALSO.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / orawhiz
A free extent is a collection of continuous free blocks in
tablespace. When a segment is dropped its extents are
reallocated and are marked as free.
| Is This Answer Correct ? | 0 Yes | 3 No |
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?
What is dictionary cache ?
What is the function of Redo Log in Oracle?
Diference between Oracle 9i and 10G.
Can a View based on another View in Oracle?
What is an Oracle Data Segment?
What is the maximum number of Lock Processes used?
What is Shared SQL Area?
What are the two types of Server Configurations?
What is meant by recursive hints ?
What is advantage of having disk shadowing/ Mirroring ?
What is meant by Redo Log file mirrorring ? How it can be achieved?
Oracle General 
