1.

And Why Are These Important ?

Answer»
  • Monitor impact on system’s CPU:
  • Instance sys vcpu + Instance user vcpu
  • Locks requests / waits
  • Active locks
  • Monitor impact on system’s storage (IO) / memory:
  • Buffer reads / writes / waits
  • Page reads / writes /
  • Disk reads / writes
  • Monitor instance health & status
  • Dbspaces TOTAL / used / free SPACE
  • Checkpoint intervals & duration
  • Sequential scans number
  • Number of not yet backup-ed logical logs
  • Number of active sessions
  • And of course the instance ONLINE log.

 

 


Discussion

No Comment Found

Related InterviewSolutions