Well, you (or your Oracle DBA) defines it.
SGA is where data is held in storage. Simular to DB2 cache and buffers. (Buffers are where you can do I/O to. Cache is...well cache. Avoid I/Os.) One of the negative points of Oracle SGA, IMHO, is all of SGA is subject to I/O. Hence, the SGA must reside below the 31 bit line when running under VM, until true 64 bit CP becomes available in September. (At that point, CP can do I/O above the 31 bit line. Native Linux on LPAR, already can do I/O above the 31 bit line.)
Tom Duerbusch THD Consulting (perhaps getting over my head in any discussions about Oracle, but I will be ramping up this year)
Marcy Cortes wrote:
OK, dumb question of the day...not knowing much of anything about Oracle (I didn't even install it), how would I determine SGA and CACHE values?
Marcy Cortes
"This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation."
-----Original Message----- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of Barton Robinson Sent: Thursday, February 03, 2005 10:45 AM To: [email protected] Subject: [LINUX-390] Oracle virtual memory sizes
Marcy, make sure the oracle SGA fits well within the value reported as "CACHE".
Date: Thu, 3 Feb 2005 12:47:16 -0600 Reply-To: Linux on 390 Port <[email protected]> Sender: Linux on 390 Port <[email protected]> From: Marcy Cortes <[EMAIL PROTECTED]>
What are you all using for Oracle virtual machine sizes? This is SLES 8, 31bit, Oracle 9i test/dev instance. I've currently set it up with 512M virtual and 750M swap in 2 v-disks, different priorities. User seems to think that's 2 little and it seems like oracle is occasionally
looping.=20
Marcy Cortes (415) 243-6343
"If you can't measure it, I'm Just NOT interested!"(tm)
/************************************************************/ Barton Robinson - CBW Internet: [EMAIL PROTECTED] Velocity Software, Inc Mailing Address: 196-D Castro Street P.O. Box 390640 Mountain View, CA 94041 Mountain View, CA 94039-0640
VM Performance Hotline: 650-964-8867 Fax: 650-964-9012 Web Page: WWW.VELOCITY-SOFTWARE.COM /************************************************************/
---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
