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@xxxxxxxxx> wrote:



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? > > > > >

Other related posts: