| SGA [message #53586] |
Mon, 30 September 2002 15:38  |
Nena
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
can someone please tell me how can I increase or decreased the size of SGA, I do know that is in init.ora but which of the paramerters do I change
Thanks
Nena
|
|
|
|
| Re: SGA [message #53589 is a reply to message #53586] |
Mon, 30 September 2002 20:50  |
K.K. Raj kumar
Messages: 33
Registered: July 2002
|
Member |
|
|
Hello,
In the init<sid>.ora
db_block_buffers,log_buffer and shared_pool_size are some of the parameters which affect your SGA.
(These information are very much available in all Oracle Documentations)
|
|
|
|
| Re: SGA [message #53617 is a reply to message #53586] |
Tue, 01 October 2002 15:29 |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
It depends of your Oracle version:
8, 8i
db_block_size=
db_block_buffers=
shared_pool_size=
java_pool_size=
large_pool_size=
log_buffer=
9i:
db_cache_size=
shared_pool_size=
java_pool_size=
large_pool_size=
log_buffer=
If you need script to calculate the optimal SGA size, check out This script
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
