Oracle Database 11g

Course Topics

Oracle Database 11g Workshop1

Exploring the Oracle Database Architecture
 
•	Oracle Database Architecture Overview
•	Oracle ASM Architecture Overview
•	Process Architecture
•	Memory structures
•	Logical and physical storage structures
•	ASM storage components
Installing your Oracle Software
•	Tasks of an Oracle Database Administrator
•	Tools Used to Administer an Oracle Database
•	Installation: System Requirements
•	Oracle Universal Installer (OUI)
•	Installing Oracle Grid Infrastructure
•	Installing Oracle Database Software
•	Silent Install
Creating an Oracle Database
•	Planning the Database
•	Using the DBCA to Create a Database
•	Password Management
•	Creating a Database Design Template
•	Using the DBCA to Delete a Database
Managing the Oracle Database Instance
•	Start and stop the Oracle database and components
•	Use Oracle Enterprise Manager
•	Access a database with SQL Plus
•	Modify database installation parameters
•	Describe the stages of database startup
•	Describe database shutdown options 
•	View the alert log
•	Access dynamic performance views
Manage the ASM Instance
•	Set up initialization parameter files for ASM instance
•	Start up and shut down ASM instances
•	Administer ASM disk groups
Configuring the Oracle Network Environment
•	Use Enterprise Manager to create and configure the Listener
•	Enable Oracle Restart to monitor the listener
•	Use tnsping to test Oracle Net connectivity
•	Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures
•	Storage Structures
•	How Table Data Is Stored
•	Anatomy of a Database Block
•	Space Management in Tablespaces
•	Tablespaces in the Preconfigured Database
•	Actions with Tablespaces
•	Oracle Managed Files (OMF)
Administering User Security
•	Database User Accounts
•	Predefined Administrative Accounts
•	Benefits of Roles
•	Predefined Roles
•	Implementing Profiles
Managing Data Concurrency
•	Data Concurrency
•	Enqueue Mechanism
•	Resolving Lock Conflicts 
•	Deadlocks
Managing Undo Data
•	Data Manipulation
•	Transactions and Undo Data
•	Undo Data Versus Redo Data
•	Configuring Undo Retention
Implementing Oracle Database Auditing
•	Describe DBA responsibilities for security
•	Enable standard database auditing
•	Specify audit options 
•	Review audit information
•	Maintain the audit trail
Database Maintenance
•	Manage optimizer statistics
•	Manage the Automatic Workload Repository (AWR)
•	Use the Automatic Database Diagnostic Monitor (ADDM)
•	Describe and use the advisory framework
•	Set alert thresholds 
•	Use server-generated alerts
•	Use automated tasks
Performance Management
•	Performance Monitoring
•	Managing Memory Components
•	Enabling Automatic Memory Management (AMM)
•	Automatic Shared Memory Advisor 
•	Using Memory Advisors
•	Dynamic Performance Statistics
•	Troubleshooting and Tuning Views
•	Invalid and Unusable Objects
Backup and Recovery Concepts
•	Part of Your Job
•	Statement Failure
•	User Error
•	Understanding Instance Recovery
•	Phases of Instance Recovery
•	Using the MTTR Advisor
•	Media Failure
•	Archive Log Files
Performing Database Backups
•	Backup Solutions: Overview
•	Oracle Secure Backup
•	User-Managed Backup
•	Terminology
•	Recovery Manager (RMAN)
•	Configuring Backup Settings
•	Backing Up the Control File to a Trace File
•	Monitoring the Flash Recovery Area
Performing Database Recovery
•	Opening a Database
•	Data Recovery Advisor
•	Loss of a Control File
•	Loss of a Redo Log File
•	Data Recovery Advisor
•	Data Failures
•	Listing Data Failures
•	Data Recovery Advisor Views
Moving Data
•	Describe ways to move data
•	Create and use directory objects
•	Use SQL*Loader to move data
•	Use external tables to move data
•	General architecture of Oracle Data Pump
•	Use Data Pump export and import to move data
Working with Support
•	Use the Enterprise Manager Support Workbench
•	Work with Oracle Support
•	Log service requests (SR) 
•	Manage patches

Oracle Database 11g Workshop 2

Exploring the Oracle Database Architecture
•	Oracle Database Architecture Overview
•	Oracle ASM Architecture Overview
•	Process Architecture
•	Memory structrues
•	Logical and physical storage structures
•	ASM storage components
Installing your Oracle Software
•	Tasks of an Oracle Database Administrator
•	Tools Used to Administer an Oracle Database
•	Installation: System Requirements
•	Oracle Universal Installer (OUI)
•	Installing Oracle Grid Infrastructure
•	Installing Oracle Database Software
•	Silent Install
Creating an Oracle Database
•	Planning the Database
•	Using the DBCA to Create a Database
•	Password Management
•	Creating a Database Design Template
•	Using the DBCA to Delete a Database
Managing the Oracle Database Instance
•	Start and stop the Oracle database and components
•	Use Oracle Enterprise Manager
•	Access a database with SQLPlus
•	Modify database installation parameters
•	Describe the stages of database startup
•	Describe database shutdown options 
•	View the alert log
•	Access dynamic performance views
Manage the ASM Instance
•	Set up initialization parameter files for ASM instance
•	Start up and shut down ASM instances
•	Administer ASM disk groups
Configuring the Oracle Network Environment
•	Use Enterprise Manager to create and configure the Listener
•	Enable Oracle Restart to monitor the listener
•	Use tnsping to test Oracle Net connectivity
•	Identify when to use shared servers and when to use dedicated servers
Managing Database Storage Structures
•	Storage Structures
•	How Table Data Is Stored
•	Anatomy of a Database Block
•	Space Management in Tablespaces
•	Tablespaces in the Preconfigured Database
•	Actions with Tablespaces
•	Oracle Managed Files (OMF)
Administering User Security
•	Database User Accounts
•	Predefined Administrative Accounts
•	Benefits of Roles
•	Predefined Roles
•	Implementing Profiles
Managing Data Concurrency
•	Data Concurrency
•	Enqueue Mechanism
•	Resolving Lock Conflicts 
•	Deadlocks
Managing Undo Data
•	Data Manipulation
•	Transactions and Undo Data
•	Undo Data Versus Redo Data
•	Configuring Undo Retention
Implementing Oracle Database Auditing
•	Describe DBA responsibilities for security
•	Enable standard database auditing
•	Specify audit options 
•	Review audit information
•	Maintain the audit trail
Database Maintenance
•	Manage optimizer statistics
•	Manage the Automatic Workload Repository (AWR)
•	Use the Automatic Database Diagnostic Monitor (ADDM)
•	Describe and use the advisory framework
•	Set alert thresholds 
•	Use server-generated alerts
•	Use automated tasks
Performance Management
•	Performance Monitoring
•	Managing Memory Components
•	Enabling Automatic Memory Management (AMM)
•	Automatic Shared Memory Advisor 
•	Using Memory Advisors
•	Dynamic Performance Statistics
•	Troubleshooting and Tuning Views
•	Invalid and Unusable Objects
Backup and Recovery Concepts
•	Part of Your Job
•	Statement Failure
•	User Error
•	Understanding Instance Recovery
•	Phases of Instance Recovery
•	Using the MTTR Advisor
•	Media Failure
•	Archive Log Files
Performing Database Backups
•	Backup Solutions: Overview
•	Oracle Secure Backup
•	User-Managed Backup
•	Terminology
•	Recovery Manager (RMAN)
•	Configuring Backup Settings
•	Backing Up the Control File to a Trace File
•	Monitoring the Flash Recovery Area
Performing Database Recovery
•	Opening a Database
•	Data Recovery Advisor
•	Loss of a Control File
•	Loss of a Redo Log File
•	Data Recovery Advisor
•	Data Failures
•	Listing Data Failures
•	Data Recovery Advisor Views
Moving Data
•	Describe ways to move data
•	Create and use directory objects
•	Use SQL*Loader to move data
•	Use external tables to move data
•	General architecture of Oracle Data Pump
•	Use Data Pump export and import to move data
Working with Support
•	Use the Enterprise Manager Support Workbench
•	Work with Oracle Support
•	Log service requests (SR)