ORACLE 11g DBA Online Training

ORACLE 11g DBA Training

ENTERPRISE EDITION INSTALLATION
• Identify system requirements
• The optimal flexible architecture (OFA)
• ORACLE_base
• ORACLE_home
• Configure the installation environment
• Enterprise edition installation • DBCA
THE ADMINISTRATOR INTERFACE
• Enterprise Manager Tour
• Using Em SQL Worksheet
• Duties Of A Database Administrator
• Exploring The Oracle Database Architecture: General
THE ORACLE ENTERPRISE ARCHITECTURE
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
• What is an ORACLE database instance?
• More about the system global area (SGA)
• About the PGA (Managing Memory)
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
• Instance Background Processes
• SQL Execution Processes
CREATING AN ORACLE DATABASE
• Create A New Database
• Configure An Existing Database
• Drop A Database
• Manage DBCA Templates
• Manually Create A Database
MANAGING THE DATABASE INSTANCE
• Configuring A Linux Environment
• Starting & Stopping Database Control
• Starting & Stopping The Database Listener
• Starting & Stopping The Database Instance
• More About The Database Files
MANAGE DATABASE STORAGE STRUCTURES: TABLE SPACES
• About Tablespaces
• Table space Management
• Drop Tablespace
• Alter Tablespace
MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
• More About Temporary Tablespaces
• About Temporary Tablespace Groups
• More About Permanent Tablespaces
• More About Bigfile Tablespaces
• More About The Sysaux Tablespace
MANAGE DATABASE STORAGE STRUCTURES
• Data Files & Temp Files
• Managing Data Files
• Managing Temp Files
• Enable ORACLE-Managed Files (OMF)
MANAGING UNDO DATA
• About Undo Space Management
• Configure Automatic Undo Management
• Undo_Management
• Undo_TablespaceUndo_Retention
• Guarantee Undo Retention
• Monitor Undo Space
• Use The Undo Advisor
NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
• Shared Servers Architecture
• Configure Shared Servers
• Monitor Shared Server
• V$Shared_Server
• V$Shared_Server_Monitor
• V$Session
• V$Circuit
• V$Dispatcher & V$Dispatcher_Config
• V$Queue
SECURITY: IMPLEMENTING DATABASE SECURITY
• Database System Privileges
• Database Object Privileges
• Administrator Auditing Of Database Activity
• Enhanced Default Security Settings
SECURITY: ADMINISTERING USER SECURITY
• Create & manage database accounts
• Grant & Revoke Database Privileges
• Resource Limits Via Profiles
• Alter Profile
• Drop Profile
• Password Management Via Profiles
• About Role-Based Security
• With Admin Option
• Alter User Default Role
• Set Role
• Enhanced Default Security Settings
MOVING DATA: SQL LOADER
• Loader Concepts
• Control File Options
• Load Methods
• Using The Em Interface
MOVING DATA: EXPORT & IMPORT
• Manage Directory Objects
• About The Data Pump Architecture
• Data Pump Export
• Data Pump Import
• Data Pump Data Dictionary Views
• Using The Em Interface
DATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
• The Management & Advisory Framework
• Manage The Automatic Workload Repository
• Automatic Database Diagnostic Monitor
• Use Metrics & Alert Thresholds
• Automatic Maintenance Tasks
MANAGING CONCURRENCY & LOCKS
• About Latches & Locks
• Manage & Monitor Latches
• Manage & Monitor Locks
• V$Lock
• V$Locked_Object
• V$Session
• V$Session_Wait
• DBA_Blockers &DBA_Waiters
• DBA_Dml_Locks &DBA_DDL_Locks
• DML_Locks
BACKUP & RECOVERY CONCEPTS & CONFIGURATION
• About Database Backup & Recovery Structures
• Managing Redo Data
• Managing Archival Data
• Automatic Crash Recovery
• Creating A Basic Backup Strategy