RE: Recommended, SGA size

I accidentially hit enter which set the message by mistake

The size should have been

rob_at_test_db -> select 17499404 / 1024 / 1024 from dual;

17499404/1024/1024

        16.6887321

So I have a 17M SGA

The 40M of 9i on Linux was without a database being built (yet)

>
> 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
>

-- 
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).