What is an Extent ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
An Extent is a specific number of contiguous data blocks,
obtained in a single allocation, used to store a specific
type of information
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mahima
it is basic unit of storage space for table and index. it
allocate s0pace for table and index row data.its having 8
64k datapages.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
An extent is a contiguous area of storage reserved for a file in a file system, represented as a range. A file can consist of zero or more extents; one file fragment requires one extent.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the data types in oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Calculate difference between 2 date / times in oracle sql?
without using count(*) and rownum how can we count total record in a table
What is an oracle database?
What is the diff between Oracle and SQL Server
Explain 1st, 2nd, 3rd normalization form of data base
What is tns name?
how to see the data (in unix) using dataset in datastage?
how to create a new database in oracle?
How to omit columns with default values in insert statement in oracle?
What is partitioned table in Oracle?