Re: SQL causing 100% CPU utilization

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 04 May 2011 19:26:26 +0200
Message-ID: <4dc18c42$0$14257$ba620e4c_at_news.skynet.be>



Steven Holland wrote:
> I have a problem SQL statement that our DBA's, Orace support nor
> myselfI cannot fix. Believe me, I've tried everything. It takes 3
> hours to run and it's all CPU time. The offending sqlid is
> '8m5dd8aqw4ka8'. Here's part of the AWR report. It's too big for
> this but I can email it to anyone who needs it.
>
>

Congratulations!

If it's too big for "this", maybe it's too big for your system too. Where did I leave my crystal balls? Received on Wed May 04 2011 - 12:26:26 CDT

Original text of this message