1) An extent is a set of contiguous blocks allocated in a database. In the Oracle database program, the first set of contiguous blocks, set up automatically when a segment is created, is called the initial extent. After the initial extent has been filled, the program allocates more extents automatically. These are known as next extents. The total number of extents that can be allocated in a database is limited by the amount of storage space available, or in some cases, by the program used.
2) The term extent is sometimes used in reference to any contiguous space (for example, a set of sectors) on a hard drive that is reserved for a particular file, folder, or application.
This was last updated in September 2005
Email Alerts
Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy
Dig Deeper
-
In this second part, expert Mich Talebzadeh looks at how Sybase’s Adaptive Server Enterprise (ASE) in-memory database compares with Oracle TimesTen.
-
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system.
-
In this third part of a series on Oracle database consolidation, contributor Jeff McCormick explains how the Oracle Virtual Private Database (VPD) can promote and encourage Oracle database consolidation.
-
People who read this also read...
Join the conversationComment
Share
Comments
Results
Contribute to the conversation