Warning: include() [function.include]: URL file-access is disabled in the server configuration in /nfs/cs/classes/www/06U/cis399oracle/lectures/week8.php on line 14

Warning: include(http://www.cs.uoregon.edu/classes/06U/cis399oracle/utility_functions.php) [function.include]: failed to open stream: no suitable wrapper could be found in /nfs/cs/classes/www/06U/cis399oracle/lectures/week8.php on line 14

Warning: include() [function.include]: Failed opening 'http://www.cs.uoregon.edu/classes/06U/cis399oracle/utility_functions.php' for inclusion (include_path='.:/private/apps/php-5.2.4/lib/php') in /nfs/cs/classes/www/06U/cis399oracle/lectures/week8.php on line 14

CIS 399 - Introduction to Oracle and SQL

Week 8 Lecture Notes

Monday, August 14 2006

  1. Overview of a DBA's Duties
  2. Using the Enterprise Manager
  3. Understanding Oracle Storage Files
    1. Protecting Control Files
    2. Creating Tablespaces and Datafiles
    3. Configuring Undo and Redo Operations
  4. Configuring Space for Schema Objects
    1. Setting Table Storage Parameters
    2. Defining Clusters
    3. Creating Partitions

Tuesday, August 15 2006

  1. Exporting and Importing Data
    1. Using SQL Scripts
    2. Using the Data Pump
    3. Using SQL*Loader and External Tables
  2. Maintaining the DBMS
    1. Patches and Updates
    2. Starting and Shutting Down the Database
  3. Backing up the Database
    1. Complications in Backing up Databases
    2. Shutdown and System Backups (cold)
    3. Continuous Backups and Archives (hot)
  4. Monitoring and Improving Database Performance
    1. Monitoring Tools
    2. Optimizing Queries
  5. Obtaining Useful Information From System Views

Wednesday, August 16 2006

  1. In-class presentations of group projects

Thursday, August 17 2006

  1. In-class presentations of group projects

Answers to Questions / Clarifications

Back to Main Page

Valid XHTML 1.0 Strict