· Projects (Project Description, Project Document Guideline)
·
Slides
Week 1 (Oracle Memory
Internals; Oracle Disk
Internals; DBA_howto; Computer Organization; Disk Parameters;
Disk Storage; Review Disks; Examples; File Organization)
Week 2-3 (Database Installation;
Indexing; Single level indexing
examples; multi-level
indexing examples; Tuning
Table and Index)
Week 4 (Database Tuning –Process, Memory; Data Integrity Constraints; Foreign Key Constraints;
Example-foreign key constraints)
Week 5-6 (Part 1: Mid-term Exam, User and Resource Control; creating profiles; creating user;
Database Tuning-User and Rollback Data
Spaces, Recovery, Backup)
Week 7 (Homework 2,
User_Profile (Archive of Create
Profile, create_profile_sql, create_user_sql, create_user, dropuser_sql,
Resource_name, show_profiles_sql, show_users_sql, user_profile_file, User_table_file);
TableSpace_Data_File (Alter_Tablespace_file
, Create_Tablespace_file,
Drop_Tablespace_file, Instruction_file,
CreateTableSpace_Sql)
Week 8 Redo Log
Files
Week 9 Review of Tablespace;
Database Query Tuning;