Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by free extent ?
- 2 Answers
- 5340 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 |
What is meant by redo log buffer ?
What is the maximum size of a oracle9i database?
What is an Oracle Data Dictionary?
When will be a segment released?
What are the two types of Server Configurations?
How to define Data Block size in Oracle?
1.Explain the three levels with the help og a diagram.
What is Database Buffers ?
What is use of Rollback Segments In Database ?
What is an Integrity Constrains in Oracle?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
How to implement the multiple control files for an existing database ?
Oracle General 
