 - 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.
 |
Learn more about Oracle database design and architecture |
| Spotlight on Oracle performance tuning: Performance tuning is a key task for any Oracle DBA. This spotlight includes tips and advice to help you meet your tuning challenges and keep users happy. |
| Oracle database performance tuning guide: Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide. |
| RDBMS fundamentals: This learning guide can help you to understand the theory that serves as the foundation for Oracle's software and offer practical tips for designing and working with it. |
| Relational Database Management System (RDBMS) fundamentals tutorial: New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database ... |
| Database design: Good performance and effective applications begin with efficient database design. Here are a few resources to help you figure out how to arrange and access your data. |
| Designing database systems: This excerpt from "Designing effective database systems" describes the processes involved in the analysis and design of database systems, starting with project life cycles. |
| LAST UPDATED: |
17 Feb 2009
|
 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
|
Show me everything on 
