Oracle-L: Recommended, SGA size

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Mon, 07 Oct 2002 08:36:18 -0800
Message-ID: <F001.004E2558.20021007083618@fatcity.com>

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). Received on Mon Oct 07 2002 - 11:36:18 CDT