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.
Printable View
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.
You may find this interesting...
http://www.adp-gmbh.ch/ora/concepts/sga.html
HTH.
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
In 9i, this is more than 100k in size.Quote:
Originally posted by nir_s
...less than 100k in size.
Quote:
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
Hi ggnanaraj,
Please read up Oracle 9i DBA Adminstration Guide available for download from Oracle Technology Network in .pdf format.
Hope this helps!!
MZ
http://asktom.oracle.com/pls/ask/f?p...:365088445659,Quote:
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.
HTH
I think u need the oracle 9i DBA Administration guide.Quote:
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