New to Oracle 9i...Increasing SGA parameters.

From: Denham Eva <EVAD_at_TFMC.co.za>
Date: Thu, 15 Jul 2004 07:29:49 +0200
Message-ID: <B822F724868AE8419D78F162BE7C2DB6AFB93A@cent12000.tfmc.co.za>

Hello Folks,

Once again very confused about what is going on. After some rtfming I am no clearer on how to adjust and manipulate the SGA or Oracle 9i's memory handling.
Does anyone have a good resource on the net which follows a by example format to explaining how to increase memory and its parameters?

Here's my situation briefly, the installation is a vanilla installation. So...
> show sga;

=20
Total System Global Area 135339388 bytes

Fixed Size                   454012 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes

> ALTER SYSTEM set db_cache_size=3D3016524 <- Increase, was 2516524
system altered
> show sga

=20
Total System Global Area 135339388 bytes <- Stays the same size ???

Fixed Size                   453912 bytes=20
Variable Size             130051904 bytes <- Increase fine
Database Buffers            4194304 bytes <- Suddenly decreases :-(
Redo Buffers                 667648 bytes

> shutdown immediate
>startup
> show sga

=20
Total System Global Area 114367768 bytes <- All of sudden smaller ???

Fixed Size                   453912 bytes
Variable Size             109051904 bytes <- Back to original size!
Database Buffers            4194304 bytes <- stays as it was before
reboot?
Redo Buffers                 667648 bytes=20

System: Win2k, Oracle 9i, version 9.0.2

Any help, pointers to resources, and even "Jokes at my expense :-)" will be appreciated=20
Regards
Denham

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 15 2004 - 00:24:12 CDT