Oracle DBA Online Training Modules Overview

Introduction of Oracle DBA

• Oracle Database 12c New and Enhanced Features
• Objectives
• Challenges
• Oracle Database in 11g Release
• High Performance Systems

Basics of Multi Container Database and Pluggable Databases

• New Multitenant Architecture: Benefits
• Other Benefits of Multitenant Architecture
• Multitenant Container Database
• Separating SYSTEM and User Data
• Naming the Containers
• Provisioning a Pluggable Database
• Basics of Multitenant Container Database and Pluggable Databases
• Interacting Within Multitenant Container Database
• Exploring CDB Architecture and Structures

Creating a Multi Container Database and Pluggable Databases

• Steps to Create a Multitenant Container Database
• Creating a Multitenant Container Database Using SQL*Plus
• Exploring CDB and PDB Structures
• Create New PDB from PDB$SEED
• With FILE_NAME_CONVERT
• Without FILE_NAME_CONVERT
• Cloning PDB within the Same CDB
• Plugging a Non-CDB into a CDB
• Dropping a PDB (optional)
• Plug Unplugged PDB in to CDB

Managing Multi Container Databases and Pluggable Databases

• Starting Up a CDB Instance
• Mounting a CDB
• Opening a CDB
• Opening a PDB
• Closing a PDB
• Shutting Down a CDB Instance
• Creating after Startup Trigger to Open All PDBs
• Changing PDB Mode
• Changing PDB Mode with SQL Developer
• Instance Parameter Changes and its Impact on PDBs

Managing Tablespaces and Users in CDB and PDBs

• Creating Permanent Tablespaces in a CDB
• Assigning Default Tablespaces
• Creating Local Temporary Tablespaces
• Assigning Default Temporary Tablespaces
• Users, Roles, and Privileges
• Local Users, Roles, and Privileges
• Creating a Local User
• Common Users
• Creating a Common User
• Common and Local Schemas / Users
• Common and Local Privileges
• Granting and Revoking Privileges
• Creating Common and Local Roles
• Granting Common or Local Privileges / Roles to Roles
• Granting Common and Local Roles to Users
• Granting and Revoking Roles
• Creating Shared and Non-Shared Objects

Backup, Recovery, Flashback CDB and PDBs

• Whole CDB Backup
• User-Managed Hot CDB Backup
• Partial CDB Backup
• Whole PDB Backup
• Partial PDB Backup
• SQL PDB Hot Backup (optional)
• SQL Control File Backup (optional)

Activities:-

• Media Failure: CDB or PDB Temp File Recovery
• Media Failure: PDB Temp File Recovery
• Media Failure: Control File Loss
• Media Failure: Redo Log File Loss
• Media Failure: Root SYSTEM or UNDO Data File
• Media Failure: Root SYSAUX Data File
• Media Failure: PDB SYSTEM Data File
• Media Failure: PDB Non-SYSTEM Data File
• Media Failure: PITR
• Flashback CDB
• Special Situations
• Creating a control file backup script

Heat Map, Automatic Data Optimization and Online Datafile Move

• Enabling Heat Map.
• Automatic Data Optimization – Creating a TIER Policy
• Automatic Data Optimization – Creating a COMPRESS Policy
• Cleanup ADO Policies and Heat Map Statistics
• Moving Data File Online
• In-Database Archiving and Temporal Validity
• Archiving Challenges
• Archiving Solutions
• In-Database Archiving: HCC
• Archiving Challenges and Solutions
• In-Database Archiving
• ORA_ARCHIVE_STATE column
• Session Visibility Control
• Disable Row-Archival
• PERIOD FOR Clause Concept
• Filtering on Valid-Time Columns
• DBMS_FLASHBACK_ARCHIV

Auditing

• Types of Auditing
• Audit Trail Implementation
• Oracle Database 12c Auditing
• Enabling Unified Auditing
• Auditing Data Pump Export
• Auditing RMAN Backups
• Unified Audit Implementation
• Security Roles
• Security SYS Auditing 9-21
• Simplicity Audit Policy 9-22
• Creating the Audit Policy
• Creating the Audit Policy with Object-Specific Actions

Privileges

• New Administrative Privileges
• New Administrative Privilege SYSBACKUP
• New Administrative Privilege SYSDG
• New Administrative Privilege SYSKM
• OS Authentication and OS Groups
• Password Authentication for SYSBACKUP
• Password Authentication for SYSDG
• New System Privilege PURGE DBA_RECYCLEBIN 10-19
• Creating Policies Database and Role Analysis
• Creating Policies Context Analysis
• Analyzing and Reporting
• SYSTEM and OBJECT Used Privileges
• Used Privileges Results
• Compare Used and Unused Privileges

Oracle Data Pump, SQL*Loader, and External Tables

• Full Transportable Export/Import Overview
• Full Transportable Export/Import Usage
• Full Transportable Export/Import Example
• Plugging a Non-CDB into CDB Using Data Pump
• Plugging a Non-CDB into CDB Using Replication
• Transporting a Database over the Network Example
• Disabling Logging for Oracle Data Pump Import Overview
• Disabling Logging for Oracle Data Pump Import Usage
• Disabling Logging for Oracle Data Pump Import Command-Line Examples
• Exporting Views as Tables Overview
• Exporting Views as Tables Usage
• Exporting Views as Tables Command-Line Examples
• Specifying the Encryption Password
• Compressing Tables during Import
• SQL*Loader and External Table Enhancements

Recovery Manager New Features

• Backing Up and Restoring Very Large Files
• RMAN Duplication Enhancements
• Duplicating an Active Database
• What Is New?
• The NOOPEN Option
• Duplicating Pluggable Databases
• Recovering Databases with Third-Party Snapshots
• Transporting Data across Platforms
• Data Transport
• Transporting Database Process Steps
• Transporting Tablespace Process Steps
• Table Recovery
• Recovering Tables from Backups
• Specifying the Recovery Point-in-Time
• Process Steps of Table Recovery

Oracle Data Guard

• Standby Databases
• Far Sync Instances
• Oracle Data Guard Services
• Configuration of Far sync Instance
• Supported protection modes for Far sync instances
• Configuring Redo Transport services
• Cascading redo transport destinations
• Cascading Physical standby database
• Cascading multiple Physical standby’s
• Apply services
• Data guardUpgrade using SQL apply
• Oracle Datagurad Scenario’s
• Downgrading database in Data guard Configuration
• Creating standby using rman

Practice Test & Interview Questions

Sacrostect Services offers advanced Oracle DBA interview questions and answers along with Oracle DBA resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.

Oracle Performance Tuning Training

CourseContent

Performance Tuning Overview

• Introduction to Performance Tuning
• Introduction to Performance Tuning Features and Tools

Designing And Developing For Performance

• Oracle Methodology
• Understanding Investment Options
• Understanding Scalability
• System Architecture
• Application Design Principles
• Workload Testing, Modeling, and Implementation
• Deploying New Applications

Performance Improvement Methods

• The Oracle Performance Improvement Method
• Emergency Performance Methods

Configuring A Database For Performance

• Performance Considerations for Initial Instance Configuration
• Creating and Maintaining Tables for Good Performance
• Performance Considerations for Shared Servers

Automatic Performance Statistics

• Overview of Data Gathering
• Automatic Workload Repository
• Automatic Performance Diagnostics
• Introduction to Database Diagnostic Monitoring
• Automatic Database Diagnostic Monitor

Memory Configuration And Use

• Understanding Memory Allocation Issues
• Configuring and Using the Buffer Cache
• Configuring and Using the Shared Pool and Large Pool
• Configuring and Using the Redo Log Buffer
• PGA Memory Management

 I/O Configuration And Design

• Understanding I/O
• Basic I/O Configuration

Understanding Operating System Resources

• Understanding Operating System Performance Issues
• Solving Operating System Problems

Understanding CPU

• Finding System CPU Utilization

Instance Tuning Using Performance Views

• Instance Tuning Steps
• Interpreting Oracle Statistics
• Wait Events Statistics
• Idle Wait Events

Tuning Networks

• Understanding Connection Models
• Detecting Network Problems
• Solving Network Problems

SQL Tuning Overview

• Introduction to SQL Tuning
• Goals for Tuning
• Identifying High-Load SQL
• Automatic SQL Tuning Features
• Developing Efficient SQL Statements

Automatic SQL Tuning

• Automatic SQL Tuning Overview
• SQL Tuning Advisor
• Managing SQL Profiles with APIs
• SQL Tuning Sets
• SQL Tuning Information Views

The Query Optimizer

• Optimizer Operations
• Choosing an Optimizer Goal
• Enabling and Controlling Query Optimizer Features
• Understanding the Query Optimizer
• Understanding Access Paths for the Query Optimizer
• Understanding Joins

Managing Optimizer Statistics

• Understanding Statistics
• Automatic Statistics Gathering
• Manual Statistics Gathering
• System Statistics
• Managing Statistics
• Viewing Statistics

Using Indexes And Clusters

• Understanding Index Performance
• Using Function-based Indexes for Performance
• Using Partitioned Indexes for Performance
• Using Index-Organized Tables for Performance
• Using Bitmap Indexes for Performance
• Using Bitmap Join Indexes for Performance
• Using Domain Indexes for Performance
• Using Clusters for Performance
• Using Hash Clusters for Performance

Optimizer Hints

• Understanding Optimizer Hints
• Using Optimizer Hints

Using Plan Stability

• Using Plan Stability to Preserve Execution Plans
• Using Plan Stability with Query Optimizer Upgrades

Using EXPLAIN PLAN

• Understanding EXPLAIN PLAN
• The PLAN_TABLE Output Table

Running EXPLAIN PLAN

• Displaying PLAN_TABLE Output
• Reading EXPLAIN PLAN Output
• Viewing Parallel Execution with EXPLAIN PLAN
• Viewing Bitmap Indexes with EXPLAIN PLAN
• Viewing Partitioned Objects with EXPLAIN PLAN

Using Application Tracing Tools

• End to End Application Tracing
• Using the trcsess Utility
• Understanding SQL Trace and TKPROF
• Using the SQL Trace Facility and TKPROF
• Avoiding Pitfalls in TKPROF Interpretation
• Sample TKPROF Output

Job Opportunities in Oracle DBA

Who wouldn’t prefer a job that assures a fast paced global career, higher than average perks? The job opportunities in the domain of Oracle DBA are quite plenty. And with the increase in the colossal demand for the qualified experts across the top industries, more & more number of aspirants are planning towards securing their career in this domain. And also in response to the whooping salary packages for the certified professionals in this domain most of the professionals who are working in other prominent technologies are working towards making a career transition into this domain.

Oracle DBA Online Training by SacrosTek Systems will set you on the right career path of achieving success in this domain.

SacrosTek Systems offer certification programs for Oracle DBA. Certificates are issues on successful completion of the course and the assessment examination. Students are requested to participate in the real-time project program to get first-hand experience on the usage and application of the Oracle DBA. The real-time projects are designed by our team of industry experts to help students get best possible exposure to the Oracle DBA and its applications.