Re: identify an update transaction
Date: Wed, 22 Apr 2009 12:22:48 -0700 (PDT)
On Apr 21, 11:36 pm, 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 ?
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).
Welcome to the group, here are some clues: http://www.dbaoracle.net/readme-cdos.htm
-- _at_home.com is bogus. History of MS anti-competitive behavior: http://www.groklaw.net/article.php?story=20090421111327711Received on Wed Apr 22 2009 - 14:22:48 CDT