Courses » Oracle Courses » Oracle DBA Online Training

 

Oracle DBA Online Training

 

Oracle 10g DBA Online Training Course Content

Introduction:

• 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

PL/SQL

• 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