Oracle DBA Checklist - Processes to review cont

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - Processes to review contention for CPU, memory, network or disk resources - Daily Procedures

a) To check CPU utilization, go to x:\web\phase2\default.htm => system metrics=>CPU utilization page. 400 is the maximum CPU utilization because there are 4 CPUs on phxdev and phxprd machine. We need to investigate if CPU utilization keeps above 350 for a while.

(Continued on next question...)

Other Job Interview Questions

• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - Daily Procedures - Free.sql
• Oracle DBA Checklist - Look for I/O Contention - Monthly Procedures
• Oracle DBA Checklist - -Verify DBSNMP is running - Daily Procedures
• Oracle DBA Checklist - Weekly Procedures - existext.sql
• Oracle DBA Checklist - Daily Procedures - nr_extents.sql
• Oracle DBA Checklist - Review Fragmentation - Monthly Procedures
• Oracle DBA Checklist - Perform Tuning and Maintenance - Monthly Procedures
• Oracle DBA Checklist - Processes to review contention for CPU, memory, network or disk resources - Daily Procedures
• Oracle DBA Checklist - Weekly Procedures - nonuPK.sql
• More...