| How much SGA..? [message #117395] |
Wed, 27 April 2005 00:18  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Can any one tell me that is it true or false that , By default 50% of RAM is allocated to the oracle SGA when database is started?
Note :- answer me in true or false
from :- sunil
|
|
|
|
|
|
| Re: How much SGA..? [message #117430 is a reply to message #117400] |
Wed, 27 April 2005 05:54  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Girish i know the size of SGA is based on the parameter in init.ora.... but when i install oracle 9i database software then i m not specifying any parameter value for SGA but default some SGA size is taken into consideration i think it is nearly 50% of RAM of the server ....
Please check out this issue with few more Oracle DBA Expert.. i am not telling that your answer is wrong but i have doubt...b'coz when we do coustom installation at that time it ask probably for size ...but when we are not doing custom installion of Oracle Database software do we specify the size of SGA?
Thanks For your help
From:- Sunil
|
|
|
|
| Re: How much SGA..? [message #117435 is a reply to message #117430] |
Wed, 27 April 2005 06:09 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
In case of typical installations oracle calculates the size as approx 70% of physical ram size for the system on which database is getting installed.
No we do not specify SGA size while doing typical installation for Oracle.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
