Re: I may never see this again. SGA
- From: DEEDSD@xxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 14 Jun 2004 15:20:37 -0400
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
"Koivu, Lisa"
<Lisa.Koivu@Cendant-TRG T
.com> To:
<oracle-l@xxxxxxxxxxxxx>
cc:
Sent by:
oracle-l-bounce@freelis bcc:
ts.org Subject:
I may never
see this again. SGA
06/12/2004 03:22 PM
Please respond to
oracle-l
Check it out! I may be a geek for thinking this is sooooo cool...
Total System Global Area 3.0067E+10 bytes
Fixed Size 779488 bytes
Variable Size 8589934592 bytes
Database Buffers 2.1475E+10 bytes
Redo Buffers 1204224 bytes
trprd2-STAGE>
Lisa Koivu
Sr. Database Monkey
Orlando, FL, USA
"The sender believes that this E-Mail and any attachments were free of any
virus, worm, Trojan horse, and/or malicious code when sent. This message
and its attachments could have been infected during transmission. By
reading the message and opening any attachments, the recipient accepts full
responsibility for taking proactive and remedial action about viruses and
other defects. The sender's business entity is not liable for any loss or
damage arising in any way from this message or its attachments."
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
