TB wrote:
> 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.
>
Each DB has its own SGA, make sure you leave enough room, eg sum of SGA sizes =
1/2 physical memory.
Received on Fri Aug 19 2005 - 16:58:54 CDT
