Oracle Database 11g: Administration Workshop II Release 2

Course overview

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

• Diagnose and repair data failures with Flashback technology.
• Manage space to optimize database storage so you can respond to growing space requirements.
• Monitor and manage major database components, including memory, performance and resources.
• Secure the availability of your database through appropriate backup and recovery strategies.
• Automate DBA tasks with the Scheduler.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Course Objectives

• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a database
• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL