Location: Courses
/ Oracle DBA Project
|
CLASS 3 (More DBA than developer)
OBJECTIVES
After this class, students will be able to:
· integrate all the forms and reports created in class 2 and perform
box tests;
· write easy to read user's manual for the software we developed;
· write some maintenance routines to monitor database performance;
· evaluate development database performance and tun it if necessary.
DELIVABLES:
User manual
Monitoring scripts
Well tuned Oracle database
CLASS 4 (More DBA)
OBJECTIVES
After this class, students will be able to:
· use RMAN to do reliable database backup and recovery;
· write a reliable backup and disaster recovery strategy and fully
test it;
· write procedures for daily maintenance routines such as analyzing
tables and indexes, recycling unused spaces, checking alert and trace
logs.
DELIVABLES:
Reliable backup and recovery procedure
Daily database maintenance routines
CLASS 5 (More DBA)
OBJECTIVES
After this class, students will be able to:
· use Oracle utilities such as autotrace and tkprof to tune application
queries for better performance;
· tune Oracle engine parameters to achieve better performance;
· assembling all documents and deploys the project.
DELIVABLES:
The whole project.
Previous
page <<
page 1 page 2
page 3 page
4 PAGE 5
|