Oracle-L: RE: Recommended, SGA size

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 07 Oct 2002 09:59:00 -0800
Message-ID: <F001.004E2845.20021007095900@fatcity.com>

Bob - The SGA size will vary significantly, depending on the applications you are running and the available system memory size. More users may cause your SGA requirements to increase. If the applications execute large PL/SQL packages, then more SGA will be required. Within the SGA, the buffer pool caches Oracle data blocks so you don't need to retrieve frequently used blocks from disk each time you need them. Tuning the SGA is a large subject within Oracle tuning. To start, I would recommend that you execute the STATSPACK report during peak time and read first page of the report it generates. This will help you understand if your SGA is too small. I would also recommend that you get a copy of "Oracle Performance Tuning 101" by Gaja Krishna Vaidyanatha.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, October 07, 2002 11:36 AM
To: Multiple recipients of list ORACLE-L

List

Im interested in finding out about the size of SGA . How large should it be?
Is it a different size on Unix than NT

Here I have a 2G database that's holding a 500M oracle dat file and the sga seems very small

Comparitive to an install of 9i on Linux over the weekend the sga on the linux box was about 40M

ORACLE instance started.

Total System Global Area                         17499404 bytes
Fixed Size                                          70924 bytes
Variable Size                                    13156352 bytes
Database Buffers                                  4194304 bytes
Redo Buffers                                        77824 bytes

Database mounted.
Database opened.

SVRMGR> select 17499404 * 1024 * 1024 from dual; 17499404*1

1.8349E+13

Thanks
bob

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bob Metelsky
INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------