| 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: I may never see this again. SGA
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_at_compuware.com]
Sent: Monday, June 14, 2004 9:11 AM
To: 'oracle-l_at_freelists.org'
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_at_Compuware.com Web: www.compuware.com -----Original Message----- From: oracle-l-bounce_at_freelists.org
Sent: Saturday, June 12, 2004 3:22 PM To: oracle-l_at_freelists.org 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."
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |