Home » RDBMS Server » Performance Tuning » How to decide on SGA sizing ???
How to decide on SGA sizing ??? [message #281037] Thu, 15 November 2007 07:51 Go to next message
girishta
Messages: 30
Registered: December 2006
Member
Hi,

I want to know how to decide on the SGA sizing ... Say .. in an OLTP environment like banking sectors where the rate of transactions will be very high...

Please i want to know the basis for same ... For eg where am working the DB size is 1.5TB and the SGA is 15GB ...(10GB DBcache etc...) and we are having 256GB RAM with 40 CPUs .. (Around 20 DBs are there)

Thanks
Giri
Re: How to decide on SGA sizing ??? [message #281053 is a reply to message #281037] Thu, 15 November 2007 09:41 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you encounter any performances or other problems?

use Statspack and check advisor sections.

Regards
Michel

[Updated on: Thu, 15 November 2007 09:42]

Report message to a moderator

Previous Topic: Index
Next Topic: Help needed in tuning this query
Goto Forum:
  


Current Time: Fri Dec 09 04:12:59 CST 2016

Total time taken to generate the page: 0.08526 seconds