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
Messages: 30
Registered: December 2006

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)

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: 63929
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.


[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: Wed Oct 26 10:56:53 CDT 2016

Total time taken to generate the page: 0.10664 seconds