Home » RDBMS Server » Performance Tuning » Memory question
Memory question [message #65192] Fri, 04 June 2004 09:40 Go to next message
Dianna Gibbs
Messages: 1
Registered: June 2004
Junior Member
We currently run VMS 7.3, Oracle 8.1.7.4 OPS; box has 12gig of memory; SGA around 4gig; new server has 32gig of memory; Oracle is only thing running on servers.  Should I increase SGA - Shared Pool and DB_BLOCK_BUFFERS - all my stats look good > 98%.  Any suggestions will be appreciated.  Is it true that having a too large SGA will cause performance issues?

Thanks.
Re: Memory question [message #65193 is a reply to message #65192] Fri, 04 June 2004 12:21 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Previous Topic: How to improve efficiency of Oracle 9i APS
Next Topic: Understanding FIRST_ROWS
Goto Forum:
  


Current Time: Mon Dec 23 00:06:22 CST 2024