| Improving Oracle Database Startup Time [message #61212] |
Mon, 05 April 2004 16:34  |
RR
Messages: 19
Registered: October 2001
|
Junior Member |
|
|
I am looking for information on starting up Oracle Database faster. Currently on a 4 CPU ( 400 MHz each) , 4 GB RAM system, The database startup takes almost 2 mins. The SGA is set to 1 GB.
Sample init.ora file content are:
# Cache and I/O
DB_BLOCK_SIZE=8192
DB_CACHE_SIZE=600M
# Database writer processes
DB_WRITER_PROCESSES=5
# Cursors and Library Cache
CURSOR_SHARING=SIMILAR
OPEN_CURSORS=2500
# Diagnostics and Statistics
BACKGROUND_DUMP_DEST=/opt/oracle/u01/admin/testDB/bdump
CORE_DUMP_DEST=/opt/oracle/u01/admin/testDB/cdump
TIMED_STATISTICS=TRUE
USER_DUMP_DEST=/opt/oracle/u01/admin/testDB/udump
# Control File Configuration
CONTROL_FILES=("/opt/test/db/oracle/u02/oradata/testDB/control01.ctl",
"/opt/test/db/oracle/u03/oradata/testDB/control02.ctl",
"/opt/test/db/oracle/u04/oradata/testDB/control03.ctl")
# Archive
LOG_ARCHIVE_DEST_1='LOCATION=/opt/test/db/oracle/u06/oradata/testDB'
LOG_ARCHIVE_FORMAT=%t_%s.dbf
LOG_ARCHIVE_START=TRUE
# Miscellaneous
COMPATIBLE=9.2.0
DB_NAME=testDB
# Distributed, Replication and Snapshot
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
# Network Registration
INSTANCE_NAME=testDB
# Pools
JAVA_POOL_SIZE=31457280
LARGE_POOL_SIZE=1048576
SHARED_POOL_SIZE=300M
# Processes and Sessions
PROCESSES=1000
# Redo Log and Recovery
FAST_START_MTTR_TARGET=300
# Resource Manager
RESOURCE_MANAGER_PLAN=SYSTEM_PLAN
# Sort, Hash Joins, Bitmap Indexes
PGA_AGGREGATE_TARGET=205M
WORKAREA_SIZE_POLICY=AUTO
# Automatic Undo Management
UNDO_MANAGEMENT=AUTO
UNDO_TABLESPACE=undotbs
# Guarantee that SGA will not be swapped
LOCK_SGA=FALSE
# SGA Max Size
SGA_MAX_SIZE=1G
# Optimizer mode
OPTIMIZER_MODE=CHOOSE
# Job
JOB_QUEUE_PROCESSES=20
The Primary Database has a Standby in recover managed mode.
Thoughts?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
