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: 65150
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: BUFFER CACHE
Next Topic: Need to perform INDEX RANGE SCAN instead of FTS
Goto Forum:
  


Current Time: Mon Aug 21 22:41:16 CDT 2017

Total time taken to generate the page: 0.11752 seconds