runaway query

From: <hegyvari_at_ardents.hu>
Date: Thu, 26 Apr 2001 11:27:09 +0200
Message-ID: <MPG.1552085a526c4bc9989680@192.168.0.1>

Greetings,

I have a 8.0.5 server on Linux RedHat 6.1 and it seems as if a query would run away some time and slow down everyone else. It is not something that happens often. When I check top, I see an Oracle process running for a long time (13 minutes, f.e.). Then I start Instance manager, make a guess about which session corresponds to the long running process, kill it, after that the process goes away from top and everything goes on as usual.

Questions:
Anyone experiencing the similar thing in the same environment? How can I find out what SQL commands are running at a given time? I would be glad if I could see the actual SQL causing the grief.

Best Regards,

Hegyvari Krisztian Received on Thu Apr 26 2001 - 04:27:09 CDT