RE: I may never see this again. SGA
- From: "Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Jun 2004 11:22:39 -0400
Ha!
Actually, this huge sga didn't help things any. I needed to prove it to
the person coordinating the test so I started up the database with a 20
GB buffer cache and a 7GB large pool. The smaller test I did, with a 8
GB buffer cache, nearly removed my buffer busy waits during the data
load phase. Basically I needed to prove that we can run on the 64-bit
architecture and that our load times would improve significantly. They
did - from 2 hours to 1 hour 15 minutes. I can shave even more off of
it if they let me modify the workflow.
They aren't going to buy this host anyway. It's a Unisys E7000 with a
price tag of $250K for 8 Itanium 2 cpu's, running Windows Datacenter.
AAAAK! See, I'm so easy to please. Give me spendy hardware and I'm
kind of happy...
Have a great day, everyone
Lisa
-----Original Message-----
From: Karniotis, Stephen [mailto:Stephen.Karniotis@xxxxxxxxxxxxx]
Sent: Monday, June 14, 2004 9:11 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: I may never see this again. SGA
Lisa:
What in the world were you thinking??????? I guess the Bigger is
Better
really works!
Thank You
Stephen P. Karniotis
Compuware Corporation
Direct: (313) 227-4350
Toll Free: (800) 462-7740 ext. 74350
Mobile: (248) 408-2918
Email: Stephen.Karniotis@xxxxxxxxxxxxx
Web: www.compuware.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Koivu, Lisa
Sent: Saturday, June 12, 2004 3:22 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: I may never see this again. SGA
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
-----------------------------------------------------------------
The contents of this e-mail are intended for the named addressee only.
It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or
disclose
it to anyone else. If you received it in error please notify us
immediately
and then destroy it.
----------------------------------------------------------------
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:
