Re: identify an update transaction

From: Mark D Powell <>
Date: Wed, 22 Apr 2009 05:24:39 -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

You can look at the dynamic performance view v$transaction and look for transactions in progress that have a large number of undo blocks in use.

You can also query v$session_longops for information related to long running session workloads.

You can find information on these views in the Oracle version# Reference manual.

The SQL to use depends on which views you deside to use but most of them can be joined on the session id, sid, of v$session or on the sql_address and sql_hash_value columns.

HTH -- Mark D Powell -- Received on Wed Apr 22 2009 - 07:24:39 CDT

Original text of this message