·         INFO 366 Syllabus

 

·         Projects

1.      Project Description,

2.      Project Document Guideline

 

Course 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

 Homework 1

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) , Oracle Architecture Overview, Storage Concepts and Setting, 

 

Week 8 Redo Log File

Week 9 Physical DB Tuning,  Physical DB Queries Tuning, DB Tuning Class