facebook twitter googleplus linkedin blogger

Oracle High Availability 11g DBA Course

1. ASM and Database Security (30 Hours)

    Automatic Storage Management (6 Hours)

  • ASM General Architecture and Functionalities
  • Dynamic Performance View Additions
  • Managing an ASM Instance
  • ASM Disk Groups
  • Using asmcmd Command Line
  • Migrating Your Database to ASM Storage
  • Creating an ASM instance in a separate Oracle Home
  • Migrating a tablespace to use ASM storage
  • 2. VLDB Support (3 Hours)

  • Creating Bigfile Tablespaces
  • Packages and data dictionary changes to support VLDB
  • Creating and maintaining temporary tablespace groups (TTG)
  • Partitioning and Partitioned Indexes
  • Skipping unusable indexes
  • Creating and using hash-partitioned global indexes
  • DML Error Logging
  • Interpreting Bigfile ROWIDs
  • 3. Managing Resources (3 Hours)

  • Database Resource Manager Concepts and Configuration
  • Creating a New Resource Plan
  • Active Session Pool Mechanism
  • Maximum Estimated Execution Time
  • Creating a Complex Plan
  • Administering and Monitoring Resource Manager
  • Resource Plan Directives
  • Creating Resource Consumer Groups
  • 4. Automating Tasks with the Scheduler (3 Hours)

  • Scheduler Concepts
  • Creating a Job Class and a Window
  • Managing Jobs, Programs, Chains, Events, Schedules, priority
  • Viewing and Purging Job Logs
  • Creating a program and a schedule
  • Creating a job that uses a program and a schedule
  • Altering the program and schedule for the job and observing the behavior change of the job
  • Monitoring job runs
  • 5. Database Security (3 Hours)

  • Virtual Private Database: Overview
  • Creating a Column-Level Policy
  • Writing a Policy Function
  • Policy Types
  • Column level VPD with column masking
  • Transparent Data Encryption
  • Setting the listener password
  • Implement VPD
  • 6. Data Movement (3 Hours)

  • External Tables Concepts
  • Creating a Directory object and External Table
  • Data Pump
  • Transport Database
  • RMAN CONVERT DATABASE Command
  • Transport Tablespace
  • Create a Directory Object
  • Create a Temporary Table
  • 7. Using Globalization Support (3 Hours)

  • Globalization Support Features
  • Encoding Schemes
  • Database Character Sets and National Character Sets
  • Specifying Language-Dependent Behavior
  • Locale Variants
  • Using Linguistic Comparison and Sorting
  • Data Conversion Between Client and Server Character Sets
  • Determining the Default NLS Settings
  • Contact



    Phone no. - 00-971564914177

    Training

    OraSols - The Complete Oracle Solutions in one place.

    All training sessions if online will be recorded and training Video is shared at the end of session. Class Room Training for a batch of 4 and above will be provided. Individual online training by special focusing on Real time examples and Interviews and job related queries will be covered in details to meet the IT best practices.  Click to read more....