Home » RDBMS Server » Performance Tuning » max size of sga in oracle 81 windows 2000 server
max size of sga in oracle 81 windows 2000 server [message #118475] Thu, 05 May 2005 08:36 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
what ia the maximum size of sga in
oracle 8i (windows 2000 server)
Re: max size of sga in oracle 81 windows 2000 server [message #118506 is a reply to message #118475] Thu, 05 May 2005 11:47 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Typically, initially approx 50-60% of ur RAM available. Later on u can change it depending upon the result of measures of performance.
Previous Topic: dbms_stats
Next Topic: Why does checkpoint only happen at log switch? :(
Goto Forum:
  


Current Time: Wed Sep 23 15:39:41 CDT 2020