Sun Microsystems, Inc.
spacer spacer
spacer   Sun Educational Services  
spacer
black dot
  black fade
spacer
  Course Catalog
logo

Administrative Tasks

( WT-1253-180 )


     Course DescriptionBack To Top

Course Offered in Partnership With DigitalThink

In this course, students will learn how to monitor a database, how to manage its physical structure, and how to use the import, export, and loader utilities. In addition, they will learn the skills to manage the physical aspects of an Oracle database and gain an understanding of the most critical performance metrics that should be monitored.

In conjunction with the other four courses in the Oracle8 Database Administration Certification Series, this course helps students prepare for Oracle Certified Professional Exam number 1Z0-013, Oracle8: Database Administration, part of the Oracle8 DBA certification track.

This course requires a computer running either Windows, Macintosh, or UNIX.

eMentoring Services are included with this course.

  • Course length: 8 hours

    • Course details
        id:      WT-1253-180
        subscription duration:  180 days
        list price:  $  325.00


     
         Languages Offered Back To Top

    This course is currently available in English only.

     
         Prerequisites Back To Top

    To succeed fully in this course, students should be able to:

  • Demonstrate completion of Database Creation and Architecture, Managing Users and Connectivity, and Managing Database Objects, or equivalent knowledge and experience

    •  
         Skills Gained Back To Top

    Upon completion of this course, you should be able to:

  • Monitor critical aspects of an Oracle database's performance
  • Manage database control files and redo log files
  • Place a database into archivelog mode
  • Manage tablespaces and data files
  • Create and manage rollback segments
  • Use the import and export utilities
  • Use SQL*Loader to load data from flat files

    •  
         Related Courses Back To Top

  • Before: Database Creation and Architecture
  • Before: Managing Users and Connectivity
  • Before: Managing Database Objects
  • After: Extended Database Features

    •  
         Course Content Back To Top



    Module 1: Course introduction Back To Top

  • Course introduction
  • Prerequisites
  • What you need
  • Course resources
  • Your learning community
  • Meet your instructor
  • The course project


    • Module 2: Routine database monitoring Back To Top

  • Routine database monitoring
  • What to monitor?
  • The alert log
  • Finding the alert log
  • Contents of the alert log
  • Renaming the alert log
  • Checking license compliance
  • Monitoring free space
  • Checking for objects that won't extend
  • The database buffer cache hit ratio
  • Improving the buffer cache hit ratio
  • Buffer cache hit ratio scope
  • Shared pool hit ratios
  • Collecting statistics
  • Monitoring I/O
  • Detecting redo log buffer contention
  • Module wrap-up


    • Module 3: Managing the control file and the database parameters Back To Top

  • Managing the control file and the database parameters
  • Protecting control files
  • Removing a control file
  • Adding a control file
  • Backing up a control file
  • Re-creating control files
  • Checking database parameter values
  • The v$parameter dynamic performance view
  • Changing database parameters
  • Module wrap-up


    • Module 4: Managing the redo log Back To Top

  • Managing the redo log
  • Protecting redo log files
  • Listing redo log files
  • Creating new redo log files
  • Dropping redo log files
  • Moving redo log files
  • Manually switching log files
  • Module wrap-up


    • Module 5: Archiving redo log files Back To Top

  • Archiving redo log files
  • Archive log mode
  • The archive log destination
  • Naming archive log files
  • Manually archiving a log file
  • Archive log history
  • Module wrap-up


    • Module 6: Managing tablespaces and data files Back To Top

  • Managing tablespaces and data files
  • Creating tablespaces
  • Tablespace information
  • Adding space
  • The AUTOEXTEND option
  • Coalescing free space
  • Dropping tablespaces
  • Read-only tablespaces
  • Temporary tablespaces
  • Temporary tablespaces and the data dictionary
  • Taking it offline
  • Moving data files
  • Module wrap-up


    • Module 7: Managing rollback segments Back To Top

  • Managing rollback segments
  • Rollback segments
  • Creating rollback segments
  • Bringing rollback segments online
  • Public versus private rollback segments
  • The ROLLBACK_SEGMENTS parameter
  • Sizing rollback segments
  • Rollback segment contention
  • The optimal rollback segment size
  • Assigning transactions to rollback segments
  • Rollback segment information
  • Altering and dropping rollback segments
  • Module wrap-up


    • Module 8: Importing and exporting data Back To Top

  • Importing and exporting data
  • The import and export utilities
  • The export utility
  • The import utility
  • Importing data
  • Parameter files
  • Compressing extents
  • The direct path option
  • Other export/import options
  • Module wrap-up


    • Module 9: Loading data with SQL*Loader Back To Top

  • Loading data with SQL*Loader
  • The SQL*Loader utility
  • The SQL*Loader command
  • The SQL*Loader control file
  • SQL*Loader data types
  • Loading delimited data
  • Loading fixed-width data
  • Handling nulls
  • Passing data through a function
  • Direct path loads
  • Module wrap-up


    • Module 10: Course conclusion Back To Top

  • Course conclusion
  • Where do you go from here?
  • We'd love your feedback
  • Help us help you learn!


    • Terms of Use.  Privacy Policy.  Feedback.  Copyright 1994-2002 Sun Microsystems, Inc.