Re: identify an update transaction
From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Thu, 23 Apr 2009 10:04:46 -0700 (PDT)
Message-ID: <24199a71-c4c4-42f5-a3dd-f5ef6260d524_at_z5g2000yqn.googlegroups.com>
On 22 apr, 21:22, joel garry <joel-ga..._at_home.com> wrote:
> On Apr 21, 11:36 pm, 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
>
> Mark's answer is the better one - you have to actually learn what you
> need to know, as well as how to figure it out - but another way is if
> you have tools like Enterprise Manager, often you can drill into the
> help or sometimes session sql displays to see what it is doing when
> you ask it to show you this kind of thing. Sometimes it's even good
> enough to just use the tool - though understanding what the tool is
> doing is always better, all tools and docs have at least some
> misleading advice.
>
> Also see
> http://www.jlcomp.demon.co.uk/trouble_shooting.rtf
> http://www.tanelpoder.com/files/Advanced_Oracle_Troubleshooting.pdf
> http://forums.oracle.com/forums/thread.jspa?threadID=501834
> (note the statspack suggestion).
>
Date: Thu, 23 Apr 2009 10:04:46 -0700 (PDT)
Message-ID: <24199a71-c4c4-42f5-a3dd-f5ef6260d524_at_z5g2000yqn.googlegroups.com>
On 22 apr, 21:22, joel garry <joel-ga..._at_home.com> wrote:
> On Apr 21, 11:36 pm, 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
>
> Mark's answer is the better one - you have to actually learn what you
> need to know, as well as how to figure it out - but another way is if
> you have tools like Enterprise Manager, often you can drill into the
> help or sometimes session sql displays to see what it is doing when
> you ask it to show you this kind of thing. Sometimes it's even good
> enough to just use the tool - though understanding what the tool is
> doing is always better, all tools and docs have at least some
> misleading advice.
>
> Also see
> http://www.jlcomp.demon.co.uk/trouble_shooting.rtf
> http://www.tanelpoder.com/files/Advanced_Oracle_Troubleshooting.pdf
> http://forums.oracle.com/forums/thread.jspa?threadID=501834
> (note the statspack suggestion).
>
Very nice links, thanks.
Let me just add a similar one:
http://oracle-randolf.blogspot.com/2009/02/basic-sql-statement-performance.html
(also note the link to a related post on the OTN-forums).
-- JeroenReceived on Thu Apr 23 2009 - 12:04:46 CDT