| Miss and Hits [message #543484] |
Wed, 15 February 2012 00:38  |
 |
sandeip
Messages: 23
Registered: May 2011
Location: pune
|
Junior Member |
|
|
My production database version: 11.2.0.1.0 and
OS version is :Microsoft Windows Server 2003
Standard Edition
Service Pack 2
can you please tell me,what is the ideal value of following to my database,
Redo latch statistics
statistics per seconds
Library Cache Latch Statistics (Per-Second)
Total Latch Misses (Per-Second)
Total Latch Sleeps (Per-Second)
Total Latch Sleeps (Per-Second)
Total Latch Gets (Per-Second)
Wait Statistics (Per-Second)
Library Cache Latch Hit Ratio
Default Buffer Pool Busy Waits (Per-Second)
Total Waits/Gets From All Undo Segments Per-Second
Dispatcher Process Queue Response Time (All Networks)
Dispatcher Busy Rate (All Networks)
|
|
|
|
|
|
|
|
|
|
| Re: Miss and Hits [message #543520 is a reply to message #543518] |
Wed, 15 February 2012 02:12  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
You need to monitor things that are important to your users: response tome for queries; how long do the batch jobs take; and so on. Wall clock time for user operations, man. Nothing else matters.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
