| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: INSERT...SELECT pegs CPU, but is waiting on scattered read?
Your shared memory configuration is probably irrelevant to your problem
at hand. Your problem is the number of memory accesses your application
SQL is demanding, not the duration of each access...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22
Pittsburgh
- SQL Optimization 101: 5/3 Boston, 5/24 San Diego, 6/14 Chicago - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jesse, Rich
Sent: Thursday, April 29, 2004 3:13 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: INSERT...SELECT pegs CPU, but is waiting on scattered read?
Or, I could just look at the swaping and paging from gpm... :) Nothing
out
of the ordinary shows there (mostly process activation from 4GLs), but I
notice in "ipcs -ma" that the SGA is broken into 9 chunks. I'm guessing
SHMMAX is too low. But that wouldn't cause a proc to spin in CPU would
it?
Rich Jesse System/Database Administrator rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
> -----Original Message-----
> From: Mladen Gogala [mailto:mladen_at_wangtrading.com]
> Sent: Thursday, April 29, 2004 2:41 PM
> To: oracle-l_at_freelists.org
> Subject: Re: INSERT...SELECT pegs CPU, but is waiting on
> scattered read?
>
>
>
> On 04/29/2004 03:08:59 PM, Cary Millsap wrote:
> > If you can still connect to Oracle, you'll probably see a tremendous
> > amount of activity reflected in V$SESS_IO.BLOCK_GETS and
> > ~.CONSISTENT_GETS. Cut the SELECT statement into a SQL*Plus
> session and
> > go to work on "tuning the SQL." This (a SQL tuning issue) is almost
> > undoubtedly the cause of your problem.
>
> But he has the perfect BCHR now! This is the illustration for
> your "method R".
> He has the perfect BCHR and he's an unhappy camper, to say
> the least. I have one
> more question: is CPU being spent in system or user mode? If
> the CPU is
> spent in the system mode and you don't have logical I/O,
> then may be you
> are paging (a.k.a "thrashing").
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 29 2004 - 21:07:33 CDT
 |
 |