Re: SQL causing 100% CPU utilization
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 05 May 2011 20:38:58 +0200
Message-ID: <4dc2eec2$0$14254$ba620e4c_at_news.skynet.be>
joel garry wrote:
> As David said, post the sql and plan. I smell full table scans
> thrashing through the sga, hogging the cpu.
Date: Thu, 05 May 2011 20:38:58 +0200
Message-ID: <4dc2eec2$0$14254$ba620e4c_at_news.skynet.be>
joel garry wrote:
> As David said, post the sql and plan. I smell full table scans
> thrashing through the sga, hogging the cpu.
Don't trust your nose, Gary, full table scans don't get into the SGA.
CPU is most often wasted by using PL/SQL functions in a where clause. That is a sure kill. Received on Thu May 05 2011 - 13:38:58 CDT