Oracle DBA

Oracle Database Administrator responsible for the designers

COURSE CONTENT

 

 

Introduction to DBA

    • Relational Database Systems
    • Integrity Constraints
    • Structured Query Language(sql)
    • Tasks of an Oracle Database Administrator

Installation of Oracle Database Software

    • Optimal Flexible Architecture (OFA)
    • Oracle Universal Installer
    • Prerequisite Checks
    • Installation
    • Configuration Assistants

Creating an Oracle Database

    • Database Architecture
    • Exploring the Storage Structure
    • Control Files
    • Redo Log Files
    • Tablespaces and Datafiles
    • Segments, Extents, and Blocks
    • Oracle Instance Management
    • Oracle Memory Structures
    • Oracle Processes
    • Data Dictionary
    • Database Control
    • Grid Control
    • Database Configuration Assistant (DBCA) Overview
    • Creating a Database
    • Passwords and Storage
    • File Locations and Backup Recovery
    • Content and Initialization Parameters
    • Other Actions with DBCA

Managing the Database

    • Starting and Stopping iSQL*Plus
    • Starting and Stopping Database Control
    • Accessing Database Control
    • SYSOPER and SYSDBA
    • Database Home Page
    • Changing the Listener Status
    • NOMOUNT MOUNT OPEN States
    • SHUTDOWN Options
    • Initialization Parameter Files
    • Viewing the Alert Log

Net Services

    • Oracle Net Services
    • Oracle Net Listener
    • Monitoring the Listener
    • Listening Addresses
    • Static Database Registration
    • Listener Control Utility
    • Oracle Net Connections
    • Directory Naming
    • Advanced Connections
    • Oracle Net Manager
    • Configuring Service Aliases with Net Manager

Managing Schema Objects

    • Schemas
    • Accessing Schema Objects
    • Schema Object Namespaces
    • Specifying Data Types in Tables
    • Other Data Types
    • Creating and Modifying Tables
    • Understanding Data Integrity
    • Defining Constraints
    • Viewing the Attributes of a Table
    • Viewing the Contents of a Table
    • Creating Indexes
    • Creating Views
    • Using a Sequence

Storage Structures

    • Tablespaces and Data Files
    • Space Management in Tablespaces
    • Storage for Locally Managed Tablespaces
    • Altering a Tablespace
    • Actions with Tablespaces
    • Dropping Tablespaces
    • Viewing Tablespace Information

Administering Users

    • Database User Accounts
    • Creating a User
    • Profiles and Users
    • Authenticating Users
    • Database Users and Schemas
    • Privileges: System and Object
    • Roles
    • Assigning Quota to Users
    • Assigning Roles to Users

Managing Data

    • Objectives
    • Manipulating Data Through SQL/
    • The INSERT Command
    • The UPDATE Command
    • The DELETE Command
    • The COMMIT and ROLLBACK Commands
    • Integrity Constraints and DML
    • Data Pump Export
    • Data Pump Import
    • SQL*Loader
    • The SQL*Loader Control File
    • Control File Syntax Considerations
    • Input Data and Data Files
    • Loading Methods
    • Comparing Direct and Conventional Path Loads
    • Loading Data with SQL*Loader
    • External Tables
    • Transportable tablespace
    • Undo Management
    • Undo Data
    • Transactions and Undo Data
    • Storing Undo Information
    • Monitoring Undo
    • Administering Undo
    • Configuring Undo Retention
    • Guaranteeing Undo Retention
    • Sizing the Undo Tablespace

Backup and Recovery Concepts

    • Backup and Recovery Issues
    • Categories of Failures
    • Instance Recovery
    • Phases of Instance Recovery
    • Tuning Instance Recovery
    • Using the MTTR Advisor
    • Configuring for Recoverability
    • ARCHIVELOG Mode
    • Configuring Backup Strategy
    • Scheduling Backups: Review
    • Backup Control File to Trace
    • Manage Backups
    • Database Recovery
    • Opening a Database
    • Changing Instance Status
    • Keeping a Database Open
    • Scenarios:
    • Loss of a Control File
    • Loss of a Redo Log File
    • Loss of a Data File in NOARCHIVELOG Mode
    • Loss of a Noncritical Data File in ARCHIVELOG Mode
    • Loss of a System-Critical Data File in ARCHIVELOG Mode
    • Oracle Recovery Manager
    • Oracle Recovery Catalog maintenance
    • Backups using Oracle Recovery Manager
    • Recovery using Oracle recovery manager
    • Database Cloning using RMAN
    • Tablespace Point in time recovery
    • Incomplete recovery

Monitoring and Resolving Lock Conflicts

    • Locks
    • Locking Mechanism
    • Data Concurrency
    • DML Locks
    • Enqueue Mechanism
    • Lock Conflicts
    • Possible Causes of Lock Conflicts
    • Detecting Lock Conflicts
    • Resolving Lock Conflicts
    • Deadlocks
    • Performance Monitoring
    • Performance Monitoring
    • Monitoring Methodologies
    • Database and Instance Metrics
    • Data Dictionary Metrics
    • Optimizer Statistics
    • Schedule Optimizer Statistics Collection
    • Dynamic Performance Views
    • Viewing Metric Information
    • Reacting to Performance Issues
    • Reacting to Performance Issues

Proactive Maintenance

    • Server Generated Alerts
    • Thresholds
    • Setting Thresholds
    • Baseline Measurements
    • Tuning and Diagnostic Advisors
    • SQL Tuning and Access Advisors
    • Memory Advisors
    • Segment Advisor
    • Automatic Workload Repository (AWR)
    • Managing the AWR
    • Automatic Database Diagnostic Monitor (ADDM)