Home » RDBMS Server » Performance Tuning » SGA Tuning
SGA Tuning [message #65954] Sat, 05 February 2005 05:16 Go to next message
Ammes
Messages: 1
Registered: February 2005
Junior Member
Hi,

We are running SAP 4.6c with ORACLE 9.2.0.5 on AIX. Database is configured with Dynamic SGA, and we have set SGA_MAX_SIZE also.
When we look at the memory management at OS level it shows high utilization of memory.
We don’t know whether the memory allocated to SGA is completely used or not.
How to find out how much memory is been utilized by the SGA, whether it needs to be allocated more
memory or can be reduced from the SGA.

Please help me in resolving this issue

Thanks and Regards

Ammes.
Re: SGA Tuning [message #65964 is a reply to message #65954] Mon, 07 February 2005 01:08 Go to previous message
vinay
Messages: 27
Registered: December 1999
Junior Member
I am not very sure but you can try to refer statspack. you should be able to get a rough idea !!!
Previous Topic: Index not properly used when LIKE operator used
Next Topic: Response time
Goto Forum:
  


Current Time: Tue Apr 16 14:30:10 CDT 2024