[Fwd: Re: I may never see this again. SGA]

From: <jtesta_at_dmc-it.com>
Date: Mon, 14 Jun 2004 16:41:37 -0400 (EDT)
Message-ID: <38074.155.188.191.5.1087245697.squirrel@www.dmc-it.com>

Ok i'll bite, whats the solution for the PX Deq and Cache Buffer chains waits?

joe

original message below>
>

 Bah.

 On a 24-CPU sun box w/96 GB of memory, one 2 TB database. You should  see the PX Deq and cache buffers chains waits!! Completely obscene.  It's a train wreck. But, we have to do what the customers demand...

 Connected to:
 Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With  the Partitioning, OLAP and Oracle Data Mining options  JServer Release 9.2.0.4.0 - Production

 SQL> show sga

 Total System Global Area 7.2311E+10 bytes

 Fixed Size                   835056 bytes
 Variable Size            2499805184 bytes
 Database Buffers         6.9810E+10 bytes
 Redo Buffers                 319488 bytes





----------------------------------------------------------------

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 Mon Jun 14 2004 - 15:48:30 CDT