Re: Block dump - Uncommitted TXN - Help Urgent

why not just look at dba_blockers and dba_waiters - why are you doing block dumps?

Find the blocking session and either kill it or call him and and ask him to commit the changes

On 18/09/06, BN <bnsarma_at_gmail.com> wrote:
>
>
>
> 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?
> > >
> > >
> >

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