What happens when initial/next extents are taken?

Published: 06 Apr 2004

I do have a conceptual problem -- actually I have a doubt about how the process for Oracle works when initial and next extents are already taken. So does Oracle search for contiguous disk blocks or just for free space at the tablespace?
An extent must occupy contiguous space in your tablespace's datafile. When an extent is allocated (initially or subsequently), Oracle must find enough contiguous free space for that extent. Once if finds that space, the extent is allocated. If there is not enough contiguous free space, Oracle will give you an error.

Dig Deeper on Oracle database design and architecture

Oracle extents Oracle extents are a set of contiguous blocks allocated in an Oracle database.

Restoring to a backup instance on a backup server for a disaster recovery plan In this Oracle database and backup recovery tip, expert Brian Peasland helps a reader restore a backup instance on a backup server in order to develop a disaster recovery plan.

Allocating multiple datafiles in a tablespace Oracle expert Brian Peasland explains how Oracle allocates multiple datafiles in a tablespace.

Comparing locally managed and dictionary managed tablespaces What is the difference between a locally managed and a dictionary managed tablespace, and what are the benefits of using a locally managed tablespace?

initial extent The initial extent is a set of contiguous blocks in a database segment that is automatically allocated when the segment is created.

Allocating LOB segments

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

What happens when initial/next extents are taken?

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

Amazon cloud database and data analytics expand

Vendors move away from open source database software licensing

Oracle looks to grow multi-model database features

SearchBusinessAnalytics

Sisense analytics platform update features AI, data prep tool

Operation Fistula uses data to treat childbirth injuries

Automated tools broaden the future scope of data science

SearchSAP

Partners need to target SAP SMB market for cloud transition

S/4HANA Cloud integrates Qualtrics for continuous improvement

SAP Data Warehouse Cloud may democratize data analytics

SearchSQLServer

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

TheServerSide.com

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

A Jenkins tutorial for beginners with examples

SearchDataCenter

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Increase efficiency with data center temperature monitoring

SearchContentManagement

New capabilities added to Alfresco Governance Services

Top 5 Office 365 skills for SharePoint administrators

Box cloud content management helps simplify digital work

SearchHRSoftware

IT's technology experience problem gets HR tool

3 keys to employee engagement measurement

Cornell researchers call for AI transparency in automated hiring

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.