hello,
My oracle is running on 11.1.0.7.0 on RHEL5 64 bit linux, its Fast start failover.
my standby host had some issues and it wasn't available for sometime and LGWR started grabbing these locks. Standby came up after 2-3 hours but
its not releasing the locks.
I removed broker configuration added again.
changed DB to Asyn mode and put back in sync mode but still no luck
HOW TO GET THIS CLEARED ?
Current HWM Init Limit
Resource Name Value Value Value Value
-------------------------- ----------- ----------- ------------------------------ ------------------------------
branches 1 8 1820 UNLIMITED
cmtcallbk 1 8 1820 UNLIMITED
dml_locks 5 5 7280 UNLIMITED
enqueue_locks 19739 20090 20090 20090
enqueue_resources 155 287 7500 UNLIMITED
gcs_resources 0 0 0 0
gcs_shadows 0 0 0 0
ges_big_msgs 0 0 0 UNLIMITED
ges_cache_ress 0 0 0 UNLIMITED
ges_locks 0 0 0 UNLIMITED
ges_procs 0 0 0 0
ges_reg_msgs 0 0 0 UNLIMITED
ges_ress 0 0 0 UNLIMITED
ges_rsv_msgs 0 0 0 0
k2q_locks 0 0 3310 UNLIMITED
max_rollback_segments 154 165 1820 65535
max_shared_servers 0 0 UNLIMITED UNLIMITED
parallel_max_servers 0 24 160 3600
processes 584 1251 1500 1500
sessions 601 1317 1655 1655
sort_segment_locks 1 10 UNLIMITED UNLIMITED
temporary_table_locks 0 5 UNLIMITED UNLIMITED
transactions 4294686873 4294967295 1820 UNLIMITED
DB> select count(*), sid, type from v$enqueue_lock group by sid, type having count(*)>100;
COUNT(*) SID TY
---------- ---------- --
21162 1646 RF
127 1647 MR
Enter value for sid: 1646
Avg Sid Logi Oracle LCl
Cpu% Cpu% Reads Sid,Serial<Blk User OS User Svr - Pgm Wait Event Sta:SIW P1 P2 P3 Object# Module Ela Cmnd SqlId:Child
------ ----- ------ --------------- -------- -------- ---------- ------------------ ------- ----- ------- --- -------- ---------------------- ----- ---- -----------------
17.5 .0 0 1646, 1 oracle 7095-LGWR LGWR-LNS wait on c Wtg: 0 0 0 0 -1 <db-db.23-45> 9999 0 :p
Edited by: user12028119 on May 24, 2011 11:40 AM
Edited by: user12028119 on May 24, 2011 11:40 AM