课程简介
Course Introduction
This course will cover basic principles of how to maintain database and how to tune database performance.Such knowledge helps to tune applications on database management system,operation system,hardware,network.Specifically,We will choose Oracle DBMS as an example to address the performance management.This course will include sets of experimental ___________script and data to help student master the skill in database management activities.
This course related information includes:
Lecture:Friday ,8:30-11:00,Room 906,Teaching Building.
Experiment 7:00-9:30pm,week 2.4,6,8,10
Email:namelh@gmail.com
Course Info:www.scholat.com/course/DBMM
Teacher Homepage:www.scholat.com/namelh
How to complete the course successfully?
1.Final exam (70%)
2. Assigments,include case studies,programming and experimental evaluation,report solutions and results
3.assignments should be submitted with our course platform.
教学大纲
Teaching Syllabus
This course will cover basic principles of how to maintain database and how to tune database performance.Such knowledge helps to tune applications on database management system,operation system,hardware,network.Specifically,We will choose Oracle DBMS as an example to address the performance management.This course will include sets of experimental ___script and data to help student master the skill in database management activities.
The lectures will include:
1 General introducetion:Introduction of Database Management,Tuning principles,Course Organization,and Reqirements.
2. Database Backup introduction
3.Cool Backup and Hot Backup
4.Recovery Manager RMAN
5.Data import and Export
6.Query Tuning:Query Plan
7.Query Tunning:Oracle Hint.
8.Memory Optimization.(JAVA POOL)
9.Oracle Performance Monitor(Statpack,AWR)
10.Concurrency Tuning:Lock Tuning,Weaken Isolation Guarantees.
11.Index Tuning(Index and join),IO performance tuning.
12 .Evaluation and Exam.
