Oracle Database 11g New Features for Administrators 2.1 Training institute in Chennai ISQL Global
This
Oracle Database 11g: New Features for Administrators Accelerated training explores key enhancements of Oracle Database 11g Release 1,
Release 2 & 11g Release 2 Patch Set 1. Learn to manage change, diagnose and recover from problems.
This Oracle Database 11g: New Features for Administrators Accelerated course teaches you about change management features and other key
enhancements in Oracle Database 11g Release 1 and Release 2. You'll explore managing change, diagnosing and recovering from problems,
ensuring high availability, while improving scalability and performance.
Learn To:
- Implement manageability features to simplify database management.
- Use change management features to master database changes.
- Use database advisors to provide proactive database monitoring.
- Increase data availability by using ASM, RMAN and Flashback feature enhancements.
- Describe the key new capabilities in Oracle Database 11g (11.2.0.2).
- Identify
how these new features can be applied in your own environments.
- Identify technical advantages and business benefits associated with these technologies.
- Proceed
towards the adoption and implementation of Oracle Database 11g Patch Set 1 with greater confidence.
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 consolidation onto database clouds.
Database Administration Topics
Expert Oracle Universityinstructors will teach you how to strengthen security, while exploring several other areas of particular interest
to Database Administrators. In addition, you'll participate in hands-on practice sessions that will help reinforce your
understanding of the new capabilities of Database 11g.
Explore Other Features of Oracle Database 11g
This course also gives you the opportunity to learn about the general new
features of the Oracle Database 11g (11.2.0.2). You'll examine the benefits, while using new features to manage storage and space,
strengthen resource management and database manageability.
Suggested Prerequisite
- Working knowledge of Oracle Database 10g
Audience- Database Administrators
- Sales Consultants
- Support Engineer
- Technical Consultant
- Data Warehouse Administrator
Course Objective- Use Total Recall to create, protect, and use history data
- Use Data Pump in legacy mode
- Describe the key new capabilities in Oracle Database 11g (11.2.0.2)
- Manage space with the enhanced segment management
- Use the capabilities of the enhanced database manageability
- Install
Oracle Database 11g Release 2
- Install Oracle Grid Infrastructure
- Use the Oracle ASM and ACFS enhancements
- Implement
table compression and hybrid columnar compression
- Implement data warehousing and partitioning enhancements
- Use the SQL Performance Analyzer
- Use Database Replay to record and replay workloads
- Use Resource Manager enhancements
- Use Oracle Restart to manage components
- Use Enterprise Manager to monitor SQL commands
- Use the new and enhanced RMAN features
Course Topics
Oracle Grid Infrastructure- Installing Oracle Grid Infrastructure for a Standalone Server
- Creating an ASM Disk Group
- ASM Dynamic Volume Manager
- ASM Cluster File System
- ASM File System Snapshot
Installation and Upgrade Enhancements- Oracle Database Upgrade Enhancements
- Upgrading Your Time Zone File and Timestamp with Time Zone Data
- Installing Oracle Database 11g Release 2
- Online Patching
Oracle Restart- Controlling Oracle Restart
- Using the srvctl Utility
- Manually
Adding Components to the Oracle Restart Configuration
ASM Enhancements- Using ASMCMD Extensions
- Using ASM Scalability and Performance Enhancements
- ASM Disk Group Compatibility
- ASM File Access Control
- Seting up ASM fast mirror resync
- ASM Optimal Disk Placement
Storage Enhancements- Using 4 KB-Sector Disks
- Using Table Compression
- SQL Access Advisor
- Hybrid
Columnar Compression
- Segment Creation on Demand
Data Warehouse and Partitioning Enhancements- Partitioning Enhancements
- Preprocessing Data for Oracle_LOADER Access Driver in External Tables
- Degree of Parallelism Enhancements
- System-Managed
Indexes for List Partitioning
- In-Memory
Parallel Query
Oracle SecureFiles- Accessing SecureFiles Metadata
- Creating SecureFiles
- Using SecureFile Compression
- Migrating to SecureFiles
- Enabling SecureFiles Storage
Security and Networking Enhancements- Secure Password Support
- Transparent
Data Encryption
- Setting Database Administrator Authentication
- Supporting IPv6 Address Notification
- Hardware Security Module
- Automatic
Secure Configuration
- Managing Default Audits
- Tablespace Master Key Re-Key
SQL Performance Analyzer- SQL Performance Analyzer: Overview
- Using SQL Performance Analyzer
- SQL Performance Analyzer: PL/SQL Example
- SQL Performance Analyzer: Data Dictionary Views
- Using Enterprise Manager to Access SQL Performance Analyzer
SQL Plan Management- Loading SQL Plan Baselines
- Viewing Important Baseline SQL Plan Attributes
- SQL Plan Management: Overview
- Purging SQL Management Base Policy
- Using the MIGRATE_STORED_OUTLINE Functions
- Loading a SQL Plan Baseline Automatically
Database Replay- Database Replay Data Dictionary Views
- Database Replay PL/SQL Procedures
- Supported
Workloads
- Database Replay System Architecture
- Database Replay Workflow in Enterprise Manager
- Using Database Replay
Automatic SQL Tuning- Automatic SQL Tuning in Oracle Database 11g
- Using the PL/SQL Interface to Generate Reports
- Configuring Automatic SQL Tuning
- Controlling the Automatic SQL Tuning Task
- Selecting Potential SQL Statements for Tuning
Intelligent Infrastructure Enhancements- Fixed Policy CPU Resource Management
- Using New Automatic Workload Repository Views
- Creating AWR Baselines
- Instance Caging
- Controlling Automatic Maintenance Tasks
- Scheduler
Enhancements
- Defining Alert Thresholds Using Static Baseline
Diagnosability Enhancements- ADRCI: The ADR Command-Line Tool
- Running Health Checks Manually
- Using the Enterprise Manager Support Workbench
- Incident
Packaging Service (IPS)
- Seting Up Automatic Diagnostic Repository
- Using the SQL Repair Advisor
- Invoking IPS Using ADRCI
SQL Monitoring & Performance Enhancements- Using Table Annotation to Control Result Caching
- Using the DBMS_ADDM Package
- Enabling Automatic Memory Management & Using New Statistic Preferences
Features
- Viewing the SQL Monitoring Report
- Viewing Session Details
- New and Modified Views
- Locking Enhancements & Adaptive Cursor Sharing
- SQL Monitoring in Oracle Database 11g Release 2
Backup and Recovery Enhancements- Optimized Backups
- Using New Settings for Binary Compression
- Creating Archival Backups
- Enhancements
to Database Duplication
- Introduction to Oracle Secure Backup Cloud Module
- Creating and Using Virtual Private Catalogs
- Using New SET NEWNAME Clauses
- TSPITR
Enhancements and Modifications
Flashback Technology, LogMiner, and Data Pump & Data Recovery Advisor- Flashback
Transaction Backout
- Oracle Total Recall
- Enterprise Manager LogMiner Interface
- Data
Recovery Advisor RMAN Command-Line Interface
- Assessing Data Failures
- Setting Parameters to Detect Corruption
- Data
Pump Legacy Mode
- Data Recovery Advisor Views
Introduction to Oracle Database 11.2.0.2- Course Objectives & Lesson Roadmap
- New Software Updates Option
- Oracle ASM Configuration After Installation
- Grid
Infrastructure Configuration after Installation & Upgrading Grid Infrastructure
- Upgrading Out-of-Place & Upgrading In-Place
- Oracle ASM Configuration Assistant Enhancements
- Installing and Upgrading with Patch Sets
Oracle ASM and ACFS Enhancements- Protecting Oracle ACFS with Encryption
- Using Oracle ACFS Replication
- Securing Oracle ACFS
- What
You Already Know: ASM, ADVM and ACFS
Enhanced Segment Management- Allocating Space
- Segments on Demand: Scope
- Controlling Deferred Segment Creation
- Viewing Segment Information in Enterprise Manager
- Creating a Range-Partitioned Table
- Viewing Partitions With and Without Segments
- Managing Space for Schema Objects
- Additional
Automatic Functionality
Performance Enhancements- Using the PARALLEL_TARGET_PERCENTAGE Attribute
- Prioritizing Parallel Statement Queuing
- Creating and Enabling Resource Plans
- Limiting Resource Usage & Monitoring Resource Usage
- Managing Query Workloads
- Parallel
Statement Queuing
- Configuring Automatic SQL Tuning
- Managing Parallel Execution of Workloads
Enhanced Real Application Testing- When to Use What?
- Data Dictionary Changes for Integration
- Using Enterprise Manager to Access SQL Performance Analyzer
- Realistic
Testing with Real Application Testing
- Using the Workload Analyzer
- Using Remote SPA with Active Data Guard
- Preprocessing a Database Workload
- Controlling DB Replay with Timeout