Re: identify an update transaction
Date: Wed, 22 Apr 2009 05:24:39 -0700 (PDT)
On Apr 22, 2:36 am, eliot06 <p.hi..._at_gmail.com> wrote:
> 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 ?
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