oracle11g默认死锁检查时间,11.2.0.3为什么无法检测到死锁 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusDat...

我的是RAC 环境，参数配置如下：

*._PX_use_large_pool=true

*._enable_NUMA_optimization=false

*._gby_hash_aggregation_enabled=false

*._gc_policy_time=0

*._optim_peek_user_binds=FALSE

*._use_adaptive_log_file_sync='FALSE'

*.audit_file_dest='/oracle/app/oracle/admin/shzw/adump'

*.audit_trail='NONE'

*.cluster_database=true

*.compatible='11.2.0.0.0'

*.control_files='/oradata04/ctl/control02.ctl','/oradata03/ctl/control01.ctl'

*.cursor_sharing='EXACT'

*.db_block_size=8192

*.db_cache_size=32G

*.db_file_multiblock_read_count=128

*.db_files=8192

*.db_name='shzw'

*.db_securefile='PERMITTED'

*.diagnostic_dest='/oracle/app/oracle'

*.fast_start_mttr_target=300

shzw1.instance_number=1

shzw2.instance_number=2

*.job_queue_processes=64

*.large_pool_size=512M

*.lock_sga=FALSE

shzw1.log_archive_dest_1='LOCATION=/shzwarch1/archivelog'

shzw2.log_archive_dest_1='LOCATION=/shzwarch2/archivelog'

*.log_archive_format='arch_%t_%s_%r.arc'

*.max_dump_file_size='UNLIMITED'

*.open_cursors=1000

*.open_links=8

*.parallel_adaptive_multi_user=TRUE

*.parallel_execution_message_size=16384

*.parallel_force_local=true

*.parallel_max_servers=512

*.pga_aggregate_target=16G

*.processes=15000

*.recyclebin='off'

*.remote_login_passwordfile='none'

*.resource_limit=true

*.session_cached_cursors=20

*.sessions=16505

*.sga_max_size=96G

*.sga_target=0

*.shared_pool_reserved_size=208M

*.shared_pool_size=8G

shzw1.thread=1

shzw2.thread=2

*.undo_retention=10800

shzw1.undo_tablespace='undotbs1'

shzw2.undo_tablespace='undotbs2'