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.
> show sga;
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
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
> show sga
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
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
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: