application , business , compliances , security

Sample – Oracle SLA / OLA Server Response Time Monitoring Considerations

September 6, 2012

The following SLA / OLA Oracle Server Counters are supported by Oracle version 10g or higher:

  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

https://www.bestitdocuments.com/Samples