Hi Gurus

Users on one of my databases are complaining about the performance.
The spec is 4 processor Solaris with 8GB memory.
Oracle 9206 (32 bit)
Database buffer = 2560M
SGA = 3.3 GB
Unix kernel parameter shmmax = 4096MB

Facts as I know Max shhmax = 4096 MB
Max SGA size for 32bit is between 3.5- 3.75GB

In your expert opinion - What is the maximum size for SGA for this
instance.?
Many thanks
Kirpal


*************************************************************************************
The message is intended for the named addressee only and may not be disclosed to or used by anyone else, nor may it be copied in any way.

The contents of this message and its attachments are confidential and may also be subject to legal privilege. If you are not the named addressee and/or have received this message in error, please advise us by e-mailing [Email address protected] and delete the message and any attachments without retaining any copies.

Internet communications are not secure and COLT does not accept responsibility for this message, its contents nor responsibility for any viruses.

No contracts can be created or varied on behalf of COLT Telecommunications, its subsidiaries or affiliates ("COLT") and any other party by email Communications unless expressly agreed in writing with such other party.

Please note that incoming emails will be automatically scanned to eliminate potential viruses and unsolicited promotional emails. For more information refer to www.colt.net or contact us on +44(0)20 7390 3900.


Oracle LazyDBA home page