Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
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
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

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

Long Query??
Important
number of db files
Script for daily Incremental Backup with Weekly full back?
Oracle Read Consistency (System Change Number)
character set
Is there any way to see the source of view sys.v$parameter ?
Roles& profile
tables purge
High Water Mark for Undo tablespace..!!
Delete with multiple join
error - while creating index
Tuning
Equivalent of Informix's onstat command
PROBLEM WITH INDEX REBUILDING
RMAN duplicate. How to preserve users accounts on AUX database