Home About Courses Schedule Services Webinars Contact Search

Oracle Database Administration

SEE SCHEDULE

Duration: 5.0 days

Method: Instructor led, Hands-on workshops

Price: $3200.00

Course Code: OR5510



Audience

Database Administrators responsible for the administration of an Oracle database.

Description

This course provides students with the skills needed to administer and maintain an Oracle 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 can be taught for any Oracle version.

Prerequisites

OR5450 Oracle SQL or equivalent experience

Topics

  1. 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
  2. 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
  3. 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
  4. 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
  5. Tables
    • Data Types
    • Integrity Constraints
    • Row Format
    • Row Chaining
    • Deferred Constraint Checking
    • Virtual Columns
    • Index-Organized Tables
    • Partitioned Tables
    • External Tables
  6. Indexes
    • Variations of Indexes
    • Guidelines for Index Creation
    • Function-Based Indexes
    • Invisible Indexes
  7. Clusters
    • Advantages of Clusters
    • Disadvantages of Clusters
    • Cluster Guidelines
    • Indexed Clusters
    • Hash Clusters
  8. Documenting Objects
    • Metadata
    • Comment On
  9. Synonyms
    • Private Synonyms
    • Public Synonyms
  10. Sequences
    • Referencing Sequence Values
    • Evaluating CURRVAL and NEXTVAL
    • Restrictions on Sequences
  11. Views
    • Processing a View
    • Restrictions on Views
    • Changing a View Definition
    • Updatable Join Views
  12. Managing UNDO Data
    • Automatic Undo Management
    • Rollback Segments
  13. Utilities
    • SQL*Loader
    • Export & Import
    • Datapump Export & Import
    • DBNEWID
    • DBMS_METADATA
    • Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Server-Generated Alerts
  14. Resumable Space Allocation
  15. Online Data Evolution
  16. Overview of Oracle’s Client-Server Architecture