Dba_oracle database operation and maintenance monitoring (case) (to be learned)

2014-07-27 Baoxinjian

I. Summary

1-whether the database account is locked for monitoring

2-size of database table space

3-Process Abnormal stop monitoring

Process monitoring with too long processing time in the 4-session

Ii. Case 1-whether the account is locked and monitored

1. How to monitor

2. How to Handle

Iii. Case 2-tablespace size not monitored

1. How to monitor

2. How to Handle

Iv. Case 3-process abnormal stop monitoring

1. How to monitor

2. How to Handle

v. process monitoring in case 4-session with too long processing time

1. How to monitor

2. How to Handle

vi. Invalid object monitoring in case 5-oracle