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
More News and Tutorials
-
Meet Pluggable Database, the star of Oracle Database 12c—it may redefine database virtualization.
-
Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.
-
In this second part, expert Mich Talebzadeh looks at how Sybase’s Adaptive Server Enterprise (ASE) in-memory database compares with Oracle TimesTen.
Join the conversationComment
Share
Comments
Results
Contribute to the conversation