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 optimising repeated queries

Building an Oracle 11g Database

Creating the database

• Setting the initialisation 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 managed and Oracle-managed files

Configuring storage patterns for database objects

• Structuring data and index segments
• Sizing database objects by defining extents and block occupancy
• Eliminating row migration with PCTFREE and Data Pump
• Compressing table data to conserve storage
• Shrinking tables and indexes online to regain space

Partitioning to Support Administration and Availability

Creating table partitions and subpartitions

• Selecting partitioning methods: range, list, hash, interval
• Partitioning tables based on virtual columns
• Setting up automatic partition allocation
• Referencing the partitioning method in child tables
• Administering partitions with merge, split, add and drop

Maintaining index partitions

• Maximising performance with local and global indexes
• Monitoring index partition usage
• Rebuilding unusable indexes