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 |
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
does the query needs a hint to access a materialized view?
What is Database Buffers ?
Why is oracle used?
Name the various constraints used in oracle?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
How to filter out duplications in the returning rows using oracle?
what is shell?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to write an inner join with the where clause in oracle?
What to do if the startbd.bat failed to start the xe instance?
How to insert multiple rows with one insert statement in oracle?