Oracle 11g Database Administration

Length: 5 Days
Audience: Database Administrators responsible for the administration of an existing Oracle 11g database. Programmers and Analysts seeking a greater understanding of the Oracle DBMS.
Prerequisites: Oracle 11g SQL Fundamentals. Not required, but helpful would be Oracle 11g PL/SQL Programming.
Overview: This course provides students with the skills needed to administer and maintain an Oracle 11g 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 additonal topics not presented in the Oracle 11g 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
    • 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
    • MEMORY_TARGET
    • Managing the Result Cache
    • 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
    • Tablespace-Level Encryption
  • User Administration
    • External Authentication
    • Privileges
    • Roles
    • Administrative Users
    • SYSDBA and SYSOPER Privileges
    • Grant & Revoke Statements
    • Profiles
    • Account LOcking
    • Password Management
    • Password Complexity Verification
  • Tables
    • Data Types
    • Integrity Constraints
    • Row Format
    • Row Chaining
    • Deferred Constraint Checking
    • Virtual Columns
    • Index-Organized Tables
    • Partitioned Tables
    • External Tables
  • Indexes
    • Variations of Indexes
    • Guidelines for Index Creation
    • Function-Based Indexes
    • Invisible Indexes
  • Clusters
    • Advantages of Clusters
    • Disadvantages of Clusters
    • Cluster Guidelines
    • Indexed Clusters
    • Hash Clusters
  • Documenting Objects
    • Metadata
    • Comment On
  • Synonyms
    • Private Synonyms
    • Public 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
    • Datapump Export & Import
    • DBNEWID
    • DBMS_METADATA
    • Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Server-Generated Alerts
  • Resumable Space Allocation
  • Online Data Evolution
  • Overview of Oracle's Client-Server Architecture
Back to Oracle 11g Courses