Oracle?? Database 11g Administration: Hands-On Training Class

• Create, maintain and support Oracle 11g databases and instances
• Automate database administration tasks with Oracle Enterprise Manager 11g Database Control
• Provide transaction support and flashback capability with UNDO tablespaces
• Control user access and ensure database security through privileges and roles
• Employ effective storage management to maximize space usage
• Partition large tables and indexes to ease administration and improve performance

Introduction to Oracle Database 11g Administration

Your responsibilities as an Oracle 11g DBA

• Configuring the instance and database
• Maintaining security
• Balancing user requirements and resources
• Ensuring database availability

The Oracle 11g architecture

• Processing transactions with the server
• Identifying types of Oracle 11g processes and memory structures
• Determining database file structure
• Archiving redo log information
• Sizing the Result Cache for optimizing repeated queries

Building an Oracle 11g Database

Creating the database

• Setting the initialization parameters
• Simplifying memory allocation with memory targets
• Establishing network connectivity
• Converting from text-based to server parameter files
• Configuring control files and redo log files

Starting and stopping the database

• Mounting and opening the database with SQL*Plus
• Authenticating connections having SYSDBA privilege
• Closing the database and shutting down the instance

Automating Database Management

The Oracle Enterprise Manager architecture

• Navigating the graphical interface
• Comparing command-line and graphical techniques

Administering with Database Control

• Equipping Database Control to manage additional databases
• Setting thresholds and generating alerts
• Verifying changes in the data dictionary
• Performing privilege management

Performing Flashback Operations

Managing space for rollback and read consistency

• Configuring UNDO tablespaces
• Monitoring expansion of rollback segments
• Swapping to an alternative UNDO tablespace

Resetting data to recent points in time with flashback

• Tracking changes to data values with row history
• Obtaining transaction history with Flashback Transaction
• Performing efficient recovery of data with Flashback Table
• Retrieving dropped tables and dependent objects from the recycle bin

Securing the Database

Establishing user accounts

• Authenticating users with sophisticated password checking
• Allocating space quotas for user schemas
• Limiting resource usage through profiles

Enforcing security

• Granting and revoking system and object privileges
• Simplifying privilege management with roles
• Preventing changes to read-only tables

Controlling Database Storage

Defining logical and physical structures

• Creating, altering, and dropping tablespaces
• Handling sort data efficiently with temporary tablespaces
• Comparing traditionally
  Hands-On Training
  Extensive hands-on exercises using both GUI tools and SQL*Plus provide you with the practical skills to administer an Oracle 11g database. Exercises include:
  • Building an Oracle database
  • Troubleshooting with automated alerts
  • Managing tablespaces with different block sizes
  • Maintaining UNDO tablespaces and retention periods to enable and perform flashback operations
  • Securing data by controlling user access with privileges and roles
  • Monitoring and optimizing space usage
  • Setting up and maintaining partitioned objects