Home About Courses Schedule Services Webinars Contact Search

Oracle Database Administration


Duration: 5 Days

Method: Instructor led, Hands-on workshops

Price: $3200.00

Course Code: OR5510


Database Administrators responsible for the administration of an Oracle database.


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, including Oracle 18c.


OR5450 Oracle SQL or equivalent experience


  • I. 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
  • II. Manageability Features
    • Controlling the Size of the SGA
    • Non-Standard Block Size Buffers
    • Dynamic SGA
    • Automatic Shared Memory Management
    • SGA_TARGET Parameter
    • Automated PGA Memory Management
    • Managing the Result Cache
    • Server Parameter File
    • Creating a Server Parameter File
  • III. Tablespaces & Data Files
    • Extent Management
    • Dictionary-Managed Tablespaces
    • Locally-Managed Tablespaces
    • Free Lists
    • Automatic Segment Space Management
    • Oracle Managed Files
    • SYSAUX Tablespace
    • Tablespace-Level Encryption
  • IV. 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
  • V. Tables
    • Data Types
    • Integrity Constraints
    • Row Format
    • Row Chaining
    • Deferred Constraint Checking
    • Virtual Columns
    • Index-Organized Tables
    • Partitioned Tables
    • External Tables
  • VI. Indexes
    • Variations of Indexes
    • Guidelines for Index Creation
    • Function-Based Indexes
    • Invisible Indexes
  • VII. Clusters
    • Advantages of Clusters
    • Disadvantages of Clusters
    • Cluster Guidelines
    • Indexed Clusters
    • Hash Clusters
  • VIII. Documenting Objects
    • Metadata
    • Comment On
  • IX. Synonyms
    • Private Synonyms
    • Public Synonyms
  • X. Sequences
    • Referencing Sequence Values
    • Evaluating CURRVAL and NEXTVAL
    • Restrictions on Sequences
  • XI. Views
    • Processing a View
    • Restrictions on Views
    • Changing a View Definition
    • Updatable Join Views
  • XII. Managing UNDO Data
    • Automatic Undo Management
    • Rollback Segments
  • XIII. Utilities
    • SQL*Loader
    • Export & Import
    • Datapump Export & Import
    • Automatic Workload Repository
    • Automatic Database Diagnostic Monitor
    • Server-Generated Alerts
  • XIV. Resumable Space Allocation
  • XV. Oracle 18c New Features
    • Online Merging of Partitions and Subpartitions
    • Modifying the Partitioning Strategy
    • SQL Tuning Advisor Exadata Enhancements
    • New SQL Tuning Set API
    • Concurrent SQL Execution with SQL Performance Analyzer
    • SQL Performance Analyzer Result Set Validation
    • Scalable Sequences
    • Memoptimized Rowstore
    • Dropping Oracle ASM File Groups With a Cascade Option
    • Ability to Use Encrypted Passwords for Database Links with Oracle Data Pump
    • Ability to Use Oracle Data Pump to Export and Import the Unified Audit Trail
    • Ability to Create Schema Only Accounts
    • Private Temporary Tables
    • Non-Persistable Data Types
    • Manual termination of Run-Away Queries
    • Approximate Top-N Query Processing
    • Polymorphic Table Functions
    • PL/SQL Hierarchical Profiler (DBMS_HPROF) Enhancements
    • PL/SQL Qualified Expressions
    • SQL*Plus Changes
    • SQL Developer Changes
    • Miscellaneous Database Changes
    • Deprecated Features
    • Desupported Features

ProTech Logo ProTech Themis Logo

We are pleased to announce that effective July 1st, ProTech Training and Themis Education will join forces to become one of the industry's strongest Enterprise IT Training companies. Please click the button below to be redirected or visit our site at ProTechTraining.com.

Contact Information
Themis technical support for classes: themissupport@themisinc.com
ProTech technical support for classes: virtualsupport@protechtraining.com
ProTech/Themis voice: 1 (800) 373-9188 or 412-810-8855
All general inquiries: info@protechtraining.com