variable size in SGA

[anuj]

Hi
from the svrmgr prompt
svrmgr>show sga
it shows
Total system global area: 715053084
fixed size: 75804
variable size: 244789248
Database buffer: 459694080
Redo Buffers: 10493952

I want to decrease my SgA size:


sga size should not be greater than 2/3 of physical memory. my server windows Nt meory is 1 GB.
what includes fixed size,vraibale size. and database buffer size. my database buffer size is also high.

pls tell me how to find each and every thing for sga details.

Thanks
Anuj

[grjohnson]

SELECT * FROM V$SGASIZE;

Everything which SHARED_POOL is variable size
The FIXED_SIZE is space used for some small Oracle processes. The rest is pretty much self expalitory.

Cheers,

[julian]

Originally posted by grjohnson
SELECT * FROM V$SGASIZE;

Everything which SHARED_POOL is variable size
The FIXED_SIZE is space used for some small Oracle processes. The rest is pretty much self expalitory.

Cheers,

V$SGASIZE ???

Let me correct you about the fixed area. It contains atomic variables: latches, pointers into other areas of the SGA. They can be found in X$KSMFSV. These variables (their names) are cryptic and non-important (for me and you).

[grjohnson]

That's what I like about you Julian, you cut like a spoon...i.e. blunt...

"latches, pointers into other areas of the SGA"... and what I said was "small Oracle processes"... hence latches, pointers.

and YES, you are correct, it's not v$SGASIZE... sorry....

V$SGASTAT.....

Okay, are we happy now?

Cheers

[Edited by grjohnson on 10-11-2001 at 02:38 AM]

[julian]

:-))