Re: identify an update transaction

From: <>
Date: Mon, 27 Apr 2009 04:24:47 -0700 (PDT)
Message-ID: <>

On Apr 22, 2:36 am, eliot06 <> 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


Steve Received on Mon Apr 27 2009 - 06:24:47 CDT

Original text of this message