oracle 引數

arthurtangel發表於2012-03-08
Oracle
Oracle記憶體引數調優技術詳解 
http://www.educity.cn/it/oracle/200912241000131500.htm

---------引數相關
NAME TYPE VALUE DISPLAY_VALUE

--連線，會話，程式
processes 3 1500 1500
sessions 3 1655 1655

--SGA,PGA,SHARED POOL,LOG BUFFER,10g&11g有不些差別
sga_max_size 6 12582912000 12000M
shared_pool_size 6 0 0
large_pool_size 6 167772160 160M
java_pool_size 6 167772160 160M
streams_pool_size 6 0 0
shared_pool_reserved_size 6 32715571 32715571
sga_target 6 10485760000 10000M
log_buffer 3 14226432 14226432
pga_aggregate_target 6 3145728000 3000M
db_cache_size
db_block_size


--ARCHIVE LOG
log_archive_dest_1 2 LOCATION=/archlog LOCATION=/archlog
log_archive_format 2 arch_%t_%s_%r.dbf arch_%t_%s_%r.dbf
db_recovery_file_dest 2 /home/oracle/flash_recovery_area /home/oracle/flash_recovery_area
db_recovery_file_dest_size 6 8589934592 8G

--UNDO
undo_tablespace 2 UNDOTBS2 UNDOTBS2
undo_retention 3 10800 10800

--SESSION CURSOR
db_file_multiblock_read_count 3 64 64
session_cached_cursors 3 20 20
open_cursors 3 800 800
cursor_sharing 2 EXACT EXACT

--OTHERS
cpu_count 3 16 16
db_block_size 3 8192 8192
db_files 3 2000 2000
job_queue_processes 3 10 10

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11990065/viewspace-718075/，如需轉載，請註明出處，否則將追究法律責任。

相關文章