Oracle 11g New Features Performance for DBAs

Currency:
11g

Audience:
Oracle DBAs and system administrators.

Prerequisites:
Conversant with Oracle 10g or 9i architecture, schema objects, etc.

Summary:
This DBA-oriented course presents the more useful new and enhanced features incorporated as part of Oracle 11g such as:

• Change management
• Database automation
• Storage management
• Fault diagnosis
• High-availability
• Security
• Partitioning
• Etc.

At regular intervals, hands-on practicals are used to enhance the attendee's learning experience. Then Oracle 11g features are summarised in terms of best practices and performance. OLTP and BI/data warehousing are given equal billing.

Objectives:
Upon completion of this presentation, the delegate should have a practical knowledge of Oracle 11g's new features and enhancements as these relate to both transactional on Bi solutions.

Format:
Lecture and hands-on, including:

• Management: automatic SQL tuning
• Storage management: table compression
• BI (data warehousing): partition manipulation and loading