Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Block dump - Uncommitted TXN - Help Urgent

Re: Block dump - Uncommitted TXN - Help Urgent

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 19 Sep 2006 09:03:18 +0100
Message-ID: <be592d550609190103k29631fb5j6c50f8da244c5ee0@mail.gmail.com>


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
Received on Tue Sep 19 2006 - 03:03:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US