The following Oracle Server 10g or higher counters that can be monitored as part an SLA:

1. Number of active connections
2. Buffer Cache Hit Ratio
3. CPU Usage Per Second
4. CPU Usage Per Transaction
5. Current Logons Count
6. Current Open Cursors Count
7. Current OS Load
8. Cursor Cache Hit Ratio.
9. Database CPU Time Ratio
10. Host CPU Utilization (Percentage)
11. Disk Sort Per Second
12. Disk Sort Per Transaction
13. Global Cache Average CR Get Time
14. Global Cache Average Current Get Time
15. Global Cache Blocks Corrupted
16. Global Cache Blocks Lost
17. Hard Parse Count Per Second
18. Hard Parse Count Per Transaction
19. Logons Per Second
20. Memory Sorts Ratio
21. Network Traffic Volume Per Second
22. Open Cursors Per Second
23. Open Cursors Per Transaction
24. Parse Failure Count Per Second
25. Parse Failure Count Per Transaction
26. PGA Cache Hit Percentage
27. Physical Read IO Requests Per Second
28. Physical Reads Direct Per Second
29. Physical Write IO Requests Per Second
30. Physical Write Total IO Requests Per Second
31. Physical Writes Direct Per Second
32. Physical Writes Per Second
33. Process Limit Percentages
34. PX downgraded Parallel Operation Per Second
35. PX downgraded to serial Per Second
36. PX downgraded percentage Per Second
37. Recursive Calls Per Second
38. Recursive Calls Per Transaction
39. Redo Allocation Hit Ratio
40. Session Limit Percentage
41. Shared Pool Free Percentage
42. Soft Parse Ratio

www.bestitdocuments.com