Oracle 10g Architecture
Memory and Processes
Instances
Database Structure
SQL Query Processing
Oracle 10g XE Installation
Using DBCA
Trouble Shooting
Creating Database
OS Configuration
Authentication
Parameter File
Data dictionary management
Database Interfaces
Using SQL*Plus and isql*Plus
Accessing data and structure
Using query, manipulation and transaction commands
Creating, altering and dropping database information
Database Starting and Stopping
Starting processes - dbconsole, listener, isqlplus, database instance
Startup modes
Parameter file
Alert log
Shutdown operations
Table Spaces and Data Files
Purpose and use of tablespaces and datafiles
Create, manage, drop tablespaces
System tablespaces and user tablespaces
Retrieving status information for tablespaces and datafiles
Schema Objects
Creating and modifying tables
Selecting appropriate data types
Constraints
Viewing table contents
Creating and managing indexes and views
Creating and using sequences
Undo Management
Undo/rollback concepts
Configure and size undo features
Using the Undo Advisor
Undo tablespaces
Undo for transactions and rollback/recovery
Data Administration
Moving data using DML
Data Pump for export and import
SQL Loader for importing external data
Administering Oracle directories
PL/SQL for Administrators
PL/SQL Overview
Anonymous blocks
Procedures, functions, packages
Triggers
Supplied procedures
Managing Users
Creating and managing user accounts
Profiles, roles, privileges and user assignment
User resource management
Database Security
Security principles
Default user accounts
Password management features
Auditing database actions
Network Management
Managing Oracle listener
Net services
Connect time failover
Using Net Manager to configure resolution methods, database connectivity
Configuring and administering shared servers
Backup and Recovery Concepts
Overview of backup and recovery
Failure point identification
Configuring checkpoints, redo logs, archiving
Configure database for recovery
RMAN overview
Flash recovery area
Database Backups
Cold and hot datafile/tablespace backups
Automated backups
Incremental backups
Image copies
Multiplexed archive logs
Control file backups
Spfile/password file backups
Database Recoveries
Restore and recovery overview
Non-critical datafile recovery
Critical file recovery
Recovering damaged archive logs
Recovering control files
Lock Management
Detecting locking issues
Transactions and locking
Configuring optimum lock strategies
Resolving potential deadlocks
Performance Guidelines
Performance issues
SQL optimiser statistics
Gathering performance metrics
Enterprise Manager performance features
Diagnostics and Tuning
Setting automated alerts
Collecting baseline metrics
Using advisors
Automatic Database Diagnostic Monitor
Automated Workload Repository
Responding to server alerts
