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

Report message to a moderator

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: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 20:40:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.