On 9/18/06, Anjo Kolk <anjo.kolk@xxxxxxxxxxx> wrote:
I am sorry to be such a pain, but may be explaining what the problem is and what you want to do, will help me and others on this list.
Anjo.
On 9/18/06, BN <bnsarma@xxxxxxxxx> wrote: > > Greetings, > > > Oracle 8.1.7.4 > > I have taken a Block dump, > > Where do I look for missing commit? > > > > -- > Regards & Thanks > BN >
-- Anjo Kolk Owner and Founder OraPerf Projects tel: +31-577-712000 mob: +31-6-55340888
Greetings
Thank you Anjo.
I am seeing an intermittent locing issue. One session blocking others I have identified the Blocker, Table from v$session I got the info:
ROW_WAIT_OBJ# "OBJ#",ROW_WAIT_FILE# "FILE#",ROW_WAIT_BLOCK# "BLOCK#",ROW_WAIT_ROW# "ROW#"
I dont think its a missing commit. The Blocker takes a while to complete making others to wait.
Dont know from here what to do.
For Example: SID SERIAL# USERNAME LOCKWAIT STATUS OSUSER PROCESS MACHINE PROGRAM Logon Time ------ ---------- --------- ---------------- -------- ---------- --------- ------------ -------------------- ----------------- PID SPID OBJ# FILE# BLOCK# ROW# ------ --------- ---------- ---------- ---------- ---------- 726 32164 APP_USER1 C000000033D645E8 ACTIVE unixusr1 16533 vrfhvp08 ABCD@ 09-17-06 09:51:19 78 16718 76663 40 29125 6
756 34355 APP_USER1 ACTIVE unixusr1 27139 vrfhvp08 XYZ@v 09-18-06 18:19:29 248 27155 -1 40 29125 6
I know that sid 726 and other sids are waiting for the same obj3,file#,block#, row#
I want to continue my investigation from here... -- Regards & Thanks BN