Oracle 10g Database Administration

Length: 5 Days
Audience: Database Administrators responsible for the administration of an Oracle database.
Prerequisites: Oracle 10g SQL & SQL*Plus. Not required, but helpful would be Oracle 10g PL/SQL Programming.
Overview: This course provides students with the skills needed to administer and maintain an Oracle 10g database. Included in the course are detailed instructions on the facilities available for database design, administration, and daily operation including user management and logical backup and recovery. The issues involved in creating a new instance and database are also presented. The Data Dictionary is examined in detail to create an awareness among participants of the wealth of system information available to the informed user of the system. Dynamic performance tables are also examined to provide access to additional information about a database and instance.
Numerous workshops serve to reinforce and expand upon topics presented during lectures.
This course includes additional topics not presented in the Oracle 10g Database Administration Lite course. Some topics presented in both courses will be covered in more detail in this course.
Topics discussed include:
  • Overview of Oracle Architecture
    • Data Files
    • Redo Log Files
    • Control Files
    • Data Dictionary
    • Dynamic Performance Tables
    • Server Processes
    • Starting a Database
    • Shutting Down a Database
    • Quiescing a Database
    • Data Base Buffers
    • Trace and Alert Files
  • Manageability Features
    • Controlling the Size of the SGA
    • SGA_MAX_SIZE
    • Non-Standard Block Size Buffers
    • Dynamic SGA
    • Automatic Shared Memory Management
    • SGA_TARGET Parameter
    • Automated PGA Memory Management
    • PGA_AGGREGATE_TARGET
    • WORKAREA_SIZE_POLICY
    • Server Parameter File
    • Creating a Server Parameter File
  • Tablespaces & Data Files
    • Extent Management
    • Dictionary-Managed Tablespaces
    • Locally-Managed Tablespaces
    • PCTFREE and PCTUSED
    • Free Lists
    • Automatic Segment Space Management
    • Oracle Managed Files
    • SYSAUX Tablespace
    • Bigfile Tablespaces
  • User Administration
    • External Authentication
    • Privileges
    • Roles
    • Administrative Users
    • SYSDBA and SYSOPER Privileges
    • DBA Connection Through SQL*Plus
    • Grant & Revoke Statements
    • Profiles
    • Account Locking
    • Password Management
    • Password Complexity Verification
  • Tables
    • Data Types
    • Integrity Constraints
    • Row Format
    • Row Chaining
    • Deferred Constraint Checking
    • Index-Organized Tables
    • Partitioned Tables
    • External Tables
  • Indexes
    • Variations of Indexes
    • Guidelines for Index Creation
    • Function-Based Indexes
  • Clusters
    • Advantages of Clusters
    • Disadvantages of Clusters
    • Cluster Guidelines
    • Indexed Clusters
    • Hash Clusters
  • Documenting Objects
    • Metadata
    • Comment On
  • Synonyms
  • Sequences
    • Referencing Sequence Values
    • Evaluating CURRVAL and NEXTVAL
    • Restrictions on Sequences
  • Views
    • Processing a View
    • Restrictions on Views
    • Changing a View Definition
    • Updatable Join Views
  • Managing UNDO Data
    • Automatic Undo Management
    • Rollback Segments
  • Utilities
    • SQL*Loader
    • Export
    • Import
    • DBNEWID
    • DBMS_METADATA
    • Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Server-Generated Alerts
  • Resumable Space Allocation
  • Flashback Query
  • Online Data Evolution
  • Overview of Oracle's Client-Server Architecture
Back to Oracle 10g Courses