Re: identify an update transaction
From: <stevedhoward_at_gmail.com>
Date: Mon, 27 Apr 2009 04:24:47 -0700 (PDT)
Message-ID: <2e9d55ab-065f-4c3d-a543-24a5fd1503bc_at_y33g2000prg.googlegroups.com>
On Apr 22, 2:36 am, eliot06 <p.hi..._at_gmail.com> wrote:
> Hi,
>
> what are the tables or views to usage to identify a session that is
> doing massive updates to the database and what is the query to use ?
>
> Thank's
Date: Mon, 27 Apr 2009 04:24:47 -0700 (PDT)
Message-ID: <2e9d55ab-065f-4c3d-a543-24a5fd1503bc_at_y33g2000prg.googlegroups.com>
On Apr 22, 2:36 am, eliot06 <p.hi..._at_gmail.com> wrote:
> Hi,
>
> what are the tables or views to usage to identify a session that is
> doing massive updates to the database and what is the query to use ?
>
> Thank's
For an "after the fact" analysis, you can use dbms_logmnr. If you no longer have the archived redo logs, depending on version, look at http://appcrawler.com/wordpress/?p=13
Regards,
Steve Received on Mon Apr 27 2009 - 06:24:47 CDT