Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Migration and Modernization
E-Business Suite
PeopleSoft Enterprise
JD Edwards World
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums



General Questions

extent increase

Hi,  I have a problem: when Oracle increase the extent automatically it take more than 20 min. How can we optimize the extent increase without percentage option or non manually?  Thanks

Are you using locally managed tablespaces?

is creating the extent causing the datafile to extend automatically? If it is increase the datafile by a large chunk manually and always ensure there's 20% space free say, so the extent does not need to ask the O/S for more filespace.

Related Links

CLOB generation fails
Unable to extend table in tablespace
incrementally refresh table
Problem related to Oracle D2k and Oracle 10g Connectivity
Index not being used
how to optimize an aggregate query
Change Windows Domain
DB Installation
Convrstion Error
SQL Developer bacth file not found
Upgrade kernel version for Oracle database with ASM server
import error
Precautions to be taken From Oracle end While Flaring Solaris Servers
SQL*Net not properly installed
MOS Index Rebuild [ID 989093.1] - why more redo after rebuild?
indexes in oracle