SGA size.

From: TB <chessgame_at_gmail.com>
Date: 19 Aug 2005 14:34:49 -0700
Message-ID: <1124487289.058599.307530@f14g2000cwb.googlegroups.com>

Hopefully a simple question. I have Oracle 8.1.7 installed on my IBM AIX 5.2 server. The server only has 1 GB of RAM and a 2G paging space (I'm thinking that is not enough memory). Anyway, I was wondering about the size of the SGA. On this one server I have a test database and the production database. If I log into either database and do a sga show it comes back with:
SQL> show sga

Total System Global Area 366981012 bytes

Fixed Size                    73620 bytes
Variable Size             324890624 bytes
Database Buffers           40960000 bytes
Redo Buffers                1056768 bytes

Are there seperate SGAs for test and prod, or is the SGA for all of Oracle and no matter how many data bases you are running, the SGA is shared by all?

I hope I'm making at least some sense, I'm not a DBA so forgive me if this is a stupid question.

Thanks.

T. Received on Fri Aug 19 2005 - 16:34:49 CDT