Oracle EBS maintenance and diagnosis learning summary, oracleebs maintenance and Diagnosis

Oracle EBS maintenance and diagnosis learning summary, oracleebs maintenance and Diagnosis
Document directory

Blog of Sunan Sheng 1. Basic Oracle status 2

1.1 check the Oracle instance status 2

1.2 check the Oracle listening status 2

1.3 check which listeners started on the local machine 3

2. Check the Oracle object status 4

2.1 Check Control File status 4

2.2 check Oracle redo log status 4

2.3 check the Oracle tablespace status 5

2.4 check for invalid objects 6

3. Check the usage of Oracle-related resources 7

3.1 v $ resource_limit Resource Check 7

3.2 check database connection 7

3.3 check table space usage 8

3.4 check the maximum extended value of the next extended and tablespace 9

4. Other 10

4.1 check database wait events 10

4.2 search for the top 10 SQL statements with poor performance

4.3 SQL 10 that has been running for a long time

4.4 monitor what SQL 10 A database user is running

Document address

Http://wenku.baidu.com/view/063386198e9951e79b8927aa