-
sga size
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.
-
-
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
-
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
-
Hi ggnanaraj,
Please read up Oracle 9i DBA Adminstration Guide available for download from Oracle Technology Network in .pdf format.
Hope this helps!!
MZ
Mohammad Zahid
Software Developer
Database Management Applications.
Vancouver, Canada
E-mail: mzahid@shaw.ca
-
Re: sga size
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
Amar
"There is a difference between knowing the path and walking the path."
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|