| Server Parameters !! [message #178794] |
Thu, 22 June 2006 11:49  |
AlinaC
Messages: 45
Registered: November 2005
Location: India
|
Member |
|
|
After installation of Oracle10G REL 2 on Solaris 10 Platform what are the Server Parameters should be configured for better performance of over all database as post installation task? What are parameters should be kept as default? What should be optimal size of SGA and how to calculate that if I implement ASMM ?
Regards,
Alina
|
|
|
|
|
|
| Re: Server Parameters !! [message #179315 is a reply to message #179010] |
Mon, 26 June 2006 19:27  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
| anacedent wrote on Fri, 23 June 2006 21:12 |
If you believe that there is a one size fit all answer, I have a bridge I'll sell you?
|
This was interesting...you know, where I'm from (Florida, USA), we have a similar saying. But we say "I've got some swamp land to sell you".
|
|
|
|
| Re: Server Parameters !! [message #179440 is a reply to message #179315] |
Tue, 27 June 2006 07:24 |
AlinaC
Messages: 45
Registered: November 2005
Location: India
|
Member |
|
|
I have installed Oracle10G REL2 on Solaris 10. My memory size is 4GB and I would like to set DB_KEEP_CACHE_SIZE 300MB, then what are the other variables should I consider for setting up SGA_TARGET to implement ASMM Is there any such formula to calculate total SGA for better performance?
Regards,
Alina
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
