For Online Training Aspirants (With Placement)

Name :

Email :

Phone :

Message :


Oracle DBA Online Training Course Content:

Oracle 10g DBA Course Content


  • Identify the oracle product
  • Describe the basic concept of a relational database


Installing oracle database 10g software:

  • System requirements.
  • Use Oracle Optimal Flexible Architecture (OFA)
  • Install software with the Oracle Universal Installer.


Create an oracle database:

  • Oracle Database Architecture.
  • Oracle instance architecture.
  • Use the management framework.
  • Use the Database Creation Assistant.


Controlling the database:

  • Start and stop the agent
  • Start and stop the enterprise manager database console
  • Start and stop the listener
  • Startup and shutdown the database


Storage Structures

  • Defining the tablespaces and data files
  • Create tablespaces
  • Manage tablespaces
  • Obtain tablespace information
  • Create and manage tablespace using oracle enterprises manager.


Administering users:

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by users.


Managing schema objects

  • Create and modify tables
  • Define constraints
  • View the attributes of a table
  • View the contents of a table
  • Create indexes and views


Managing Data

  • Manipulating data through SQL
  • Using Import
  • Using Export
  • Using SQL Loader



  • Identify PL/SQL objects
  • Understand triggers and triggering events
  • Identify configuration options that affect PL/SQL performance


Oracle Database Security

  • Apply the principal of least privilege
  • Manage default user accounts
  • Implement standard password security features
  • Audit database activity


Oracle Net Services

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners
  • Use the listener control utility to control the Oracle Net Listener
  • Use the Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity


Oracle Shared Server

  • Understand when to use Oracle Shared Servers
  • Configure Oracle Shared Servers
  • Monitoring Shared Servers


Performance Monitoring

  • Troubleshoot invalid and unusable objects
  • Gather optimizer statistics
  • View performance metrics
  • React to performance issues


Proactive Maintenance: Objectives

  • Set warning and critical alert thresholds
  • Collect and use baseline metrics
  • Use tuning and diagnostic advisors
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Manage the Automatic Workload Repository


Undo Management

  • Monitor and administer undo
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor


Monitoring and Resolving Lock Conflicts

  • Detect and resolve lock conflicts
  • Manage deadlocks


Backup and Recovery

  • Describe the basics of database backup, restore and recovery
  • List the types of failure that may occur in an Oracle Database
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log files, and archived log file
  • Configure ARCHIVELOG mode


Database backups

  • Create consistent database backups
  • Back your database up without shutting it down
  • Create incremental backups
  • Automate database backups
  • Monitor the flash recovery area


Database Recovery

  • Recover from loss of a control file
  • Recover from loss of a redo log file
  • Recover from loss of a data file


Using Globalization Support

  • Datetimes with Timezones
  • Specifying Language-Dependent Behavior
  • Locale Variants
  • Linguistic Sorting
  • Case and Accent Insensitive Sorts
  • Linguistic Comparisons
  • Obtaining Information about the Current NLS Configuration


Diagnostic Sources

  • The Alert Log
  • Viewing Alerts with EM
  • Alerts Notification
  • Editing Thresholds
  • Trace Files


Recovering from non-critical losses

  • Creating New Temporary Tablespace
  • Recreating Redo Log Files
  • Recovering an Index Tablespace
  • Read-Only Tablespace Recovery
  • Loss of Password Authentication File


Automatic Storage Management

  • ASM Concepts
  • ASM General Architecture
  • Creating an ASM instance
  • Creating tablespaces that use ASM storage
  • Viewing ASM information
  • Migrating a tablespace to use ASM storage.


Flashback database

  • When to Use Flashback Technology
  • Configuring Flashback Database
  • Monitoring Flashback Database
  • Best Practices for the Database and Flash Recovery Area
  • Flash Recovery Area Space Usage
  • Flashback Database Examples


Monitoring and Managing Memory

  • Oracle Memory Structures
  • Automatic PGA Memory Management


© Copyright 2013 Tectist., All rights reserved