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

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

Other related posts: