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)

Report message to a moderator

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.

Report message to a moderator

Previous Topic: dbms_stats
Next Topic: Why does checkpoint only happen at log switch? :(
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 23 15:39:41 CDT 2020
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.