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 |
How will you differentiate between varchar & varchar2?
how do get database name at sql prompt?
What is a parameter file in oracle?
Explain oracle insert into command?
Define oracle database
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
create one table to capture an employee details with a primary key.
What are the commands youd issue to show the explain plan for select
In what script is snap$ created? In what script is the scott/tiger schema created?
What is a private synonym?
How to set a transaction to be read only in oracle?
How remove data files before opening a database?