| Oracle 9.2.0 OEM Performance manager!!!! [message #68456] |
Wed, 01 October 2003 13:27  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
Hello,
I was using OEM Performance Manager that comes witht the OEM console(Oracle 9.2.0) tools to check the performance of one of my databases.
I selected the 'Database Health Overview summary' chart.
I noticed that the 'database memory was in a critical red condition'- specially focussed red on the Library cache. So I increased the shared pool from 320MB to 512MB and also increaes the open_cursors from 300 to 900. I'm sure the shared_pool_size was set correctly because anymore increase in the shared pool causes more 'Shared pool %' to be free. Now the % of shared_pool free is about 17-20% on peak usage.
I even put in a 10% value of the total shared pool size to the shared pool resevere parameter. Still the condition is red. When I seek for advice on the manager it says 'check the total hard parse count' and 'similar sql statements'. Is there any other parameter I can tweak safely to make sure the library hit is lowered. I referred several doucments on this, and nothing helps.
Currently the buffer cache hit ratio is 99% or above
and Library cache hit is 93% or above and the condition is still red for library cache.
If you can e-mail me at 'indengr@yahoo.com' I can even send you the snapshot of the screen I'm looking at.
Thanks
tony
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
