SGA Tuning [message #65954] |
Sat, 05 February 2005 05:16  |
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  |
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 !!!
|
|
|