===========================================================
10.2.0.3 WORKLOAD REPOSITORY report 优化过程记录
===========================================================
作者: looric(http://looric.itpub.net)
发表于: 2007.05.24 01:01
分类: Oracle
出处: http://looric.itpub.net/post/5065/289498
---------------------------------------------------------------
发表于: 2007.05.24 01:01
分类: Oracle
出处: http://looric.itpub.net/post/5065/289498
---------------------------------------------------------------
10.2.0.3 WORKLOAD REPOSITORY report 优化问题【求助】
附件：awr_report_903_904.html
，请高手帮看看问题出在那里？
现在的表现是应用系统间歇性的缓慢。
init_20070523_1444.ora
audit_file_dest = /opt/app/admin/BaanDB/adump
background_dump_dest = /opt/app/admin/BaanDB/bdump
core_dump_dest = /opt/app/admin/BaanDB/cdump
db_file_multiblock_read_count = 64
db_flashback_retention_target = 720
dispatchers = '(PROTOCOL=TCP) (SERVICE=BaanDBXDB)'
hash_area_size = 1572864
job_queue_processes = 10
log_archive_format = '%t_%s_%r.dbf'
log_buffer = 30523392
log_checkpoint_timeout = 900
object_cache_optimal_size = 102400
session_cached_cursors = 20
sga_max_size = 2544M
sort_area_size = 786432
spfile = +DATABASEDG/baandb/spfilebaandb.ora
user_dump_dest = /opt/app/admin/BaanDB/udump
compatible = 10.2.0.3.0
control_files = ('+DATABASEDG/ctl02.f', '/opt/app/product/10.2.0/baandb/controlfile/BAANDB/controlfile/o1_mf_323wdknr_.ctl')
db_block_size = 8192
db_create_file_dest = +DATABASEDG
db_create_online_log_dest_1 = /opt/app/product/10.2.0/baandb/controlfile
db_domain = ''
db_name = BaanDB
db_recovery_file_dest = +DATABASEDG
db_recovery_file_dest_size = 16G
log_archive_dest_1 = 'LOCATION=+DATABASEDG/BaanDB/'
open_cursors = 5000
pga_aggregate_target = 1187M
processes = 600
remote_login_passwordfile = EXCLUSIVE
sessions = 665
sga_target = 2544M
undo_management = AUTO
undo_tablespace = UNDOTBS1
附件：awr_report_903_904.html
，请高手帮看看问题出在那里？
现在的表现是应用系统间歇性的缓慢。
init_20070523_1444.ora
audit_file_dest = /opt/app/admin/BaanDB/adump
background_dump_dest = /opt/app/admin/BaanDB/bdump
core_dump_dest = /opt/app/admin/BaanDB/cdump
db_file_multiblock_read_count = 64
db_flashback_retention_target = 720
dispatchers = '(PROTOCOL=TCP) (SERVICE=BaanDBXDB)'
hash_area_size = 1572864
job_queue_processes = 10
log_archive_format = '%t_%s_%r.dbf'
log_buffer = 30523392
log_checkpoint_timeout = 900
object_cache_optimal_size = 102400
session_cached_cursors = 20
sga_max_size = 2544M
sort_area_size = 786432
spfile = +DATABASEDG/baandb/spfilebaandb.ora
user_dump_dest = /opt/app/admin/BaanDB/udump
compatible = 10.2.0.3.0
control_files = ('+DATABASEDG/ctl02.f', '/opt/app/product/10.2.0/baandb/controlfile/BAANDB/controlfile/o1_mf_323wdknr_.ctl')
db_block_size = 8192
db_create_file_dest = +DATABASEDG
db_create_online_log_dest_1 = /opt/app/product/10.2.0/baandb/controlfile
db_domain = ''
db_name = BaanDB
db_recovery_file_dest = +DATABASEDG
db_recovery_file_dest_size = 16G
log_archive_dest_1 = 'LOCATION=+DATABASEDG/BaanDB/'
open_cursors = 5000
pga_aggregate_target = 1187M
processes = 600
remote_login_passwordfile = EXCLUSIVE
sessions = 665
sga_target = 2544M
undo_management = AUTO
undo_tablespace = UNDOTBS1
