sga size

[ser]

when u query the sga view it gives some values such as fixed size,variable size, etc . i want to know what does fixed size comprise of, same with variable size and their meaning.

[ggnanaraj]

You may find this interesting...
http://www.adp-gmbh.ch/ora/concepts/sga.html

HTH.

[nir_s]

Hi,

Fixed Size
- Contains general information about the state of the
database and the instance, which the background processes need
to access.
- No user data is stored here.
- This area is usually less than 100k in size.

Variable Size
- This section is influenced by the following init.ora
parameters :shared_pool_size ,large_pool_size and
java_pool_size

Regards,
Nir

[ggnanaraj]

Originally posted by nir_s
...less than 100k in size.

In 9i, this is more than 100k in size.

TST: SYS> show sga

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes

[mzahid]

Hi ggnanaraj,

Please read up Oracle 9i DBA Adminstration Guide available for download from Oracle Technology Network in .pdf format.

Hope this helps!!

MZ

[adewri]

Originally posted by ser
when u query the sga view it gives some values such as fixed size,variable size, etc . i want to know what does fixed size comprise of, same with variable size and their meaning.

http://asktom.oracle.com/pls/ask/f?p...:365088445659,

HTH

[akhadar]

Originally posted by mzahid
Hi ggnanaraj,

Please read up Oracle 9i DBA Adminstration Guide available for download from Oracle Technology Network in .pdf format.

Hope this helps!!

MZ

I think u need the oracle 9i DBA Administration guide.