From: hegyvari@ardents.hu Newsgroups: comp.databases.oracle.server Subject: runaway query Date: Thu, 26 Apr 2001 11:27:09 +0200 Organization: Ardents Kft. Lines: 18 Message-ID: NNTP-Posting-Host: 145.236.254.17 X-Trace: namru.matavnet.hu 988277276 12653 145.236.254.17 (26 Apr 2001 09:27:56 GMT) X-Complaints-To: newsmaster@matavnet.hu NNTP-Posting-Date: Thu, 26 Apr 2001 09:27:56 +0000 (UTC) X-Newsreader: MicroPlanet Gravity v2.30 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