Re: Block dump - Uncommitted TXN - Help Urgent

On 9/18/06, Anjo Kolk <anjo.kolk_at_oraperf.com> 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_at_gmail.com> 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_at_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

--
http://www.freelists.org/webpage/oracle-l