Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle Architecture
  2. Suggest New Category

What is meant by free extent ?

Question Posted / manvendra

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

2703

What is an Oracle Data Block?

1079

What is an Integrity Constrains in Oracle?

1192

Can a Tablespace hold objects from different Schemes in Oracle?

1049

What is an Oracle SYSTEM tablespace and when is it Created?

1118

What is an Oracle Rollback Segment?

1126

Teradata: How can we know the indexed column in a table?

1898

What is an Oracle Data Segment?

1058

What is an oracle database schema?

1128

Can a View based on another View in Oracle?

1037

What are the consideration at tehe migration of Oracle 9i to 10G.

3068

What are the uses of Oracle Rollback Segment?

1132

What is the function of Redo Log in Oracle?

1222

What are Oracle Schema Objects?

1119

What is the use of Oracle Control File?

1077