Re: identify an update transaction

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 22 Apr 2009 05:24:39 -0700 (PDT)
Message-ID: <538d8c09-4d2c-4539-a1f7-738add32e6e1_at_p4g2000vba.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

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