Oracle Database 11g: New Features for Oracle 9i DBAs
This course introduces students to the new features of Oracle Database 10g and Oracle Database 11g. You will learn how to upgrade from an Oracle9i database to Oracle Database 11g. As a Database Administrator, you learn how to set up and perform typical tasks using the new features available with Oracle Database 10g and Oracle Database 11g including many of the Advisors. Students learn how to use features that increase database availability, simplify overall database management, and improve performance. Hands-on practice sessions provide students with an opportunity to upgrade an Oracle9i database to Oracle Database 11g and use many of the new features.
Learn To:
Upgrade to Oracle Database 11g
Perform typical DBA tasks tailored to an 11g database
Skills Gained
Upgrade your database from 9i to Oracle Database 11g
Use improved ASM, RMAN, and Flashback features
Use database advisors for proactive database monitoring
Implement improved manageability features simplifying database management
Utilize Enterprise Manager to efficiently manage diagnostic data
Use change management features to master database changes
Who Can Benefit
Technical Administrator
Database Administrators
Prerequisites
Required Prerequisites:
Oracle9i Database: New Features for Administrators
Oracle9i Database: New Features for Administrators
Suggested Next Courses:
Oracle Database 11g: Performance Tuning
Code:
11g-NF
Length:
5 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$3,000
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Modifying Parameters for Automatically Managed Components
Modifying Parameters for Manually Sized Components
Monitoring Automatic Memory Management
Managing Database Storage Structures
Using the SYSAUX Tablespace
Specifying a Default User Tablespace
Using Oracle Managed Files (OMF
Creating Bigfile Tablespaces
Using Nonstandard Block Sizes
Proactively Monitoring Tablespaces
Using the Redo Logfile Sizing Advisor
Implementing Automatic Storage Management (ASM)
ASM: Key Features and Benefits
ASM: General Architecture
Accessing an ASM Instance
ASM Administration
Database Instance Parameter Changes
Migrating Your Database to ASM
Managing Database Space
Understanding Automatic Undo Management
Specifying the Undo Management Mode
Setting the Undo Management Initialization Parameters
Using the Undo Advisor
Administering Users and Database Security
Unlocking Default User Accounts
Specifying a Common Password for System
Securing access by user
Using Fine-Grained Auditing
Auditing the SYS User
Understanding Changes to the Audit Trail
Managing Schema Objects
Using Automatic Segment-space Management
Estimating Table and Index Size Before Creation
Granting Object Privileges on Behalf of the Object Owner
Performing Online Redefinition of Tables
Enabling Data Segment Compression
Automatically Collecting Statistics
Using the Segment Advisor
Accessing and Loading Data
Using Data Pump to Import and Export Data
Managing External Tables
Cross-Platform Transportable Tablespaces
Performing Backup and Recovery Operations
Using RMAN to Back up the SPFILE
Creating Change-aware Incremental Backups
Encrypting backups
Using backup compression
Using RMAN to Perform Recovery: Automatic File Creation During Recovery
Performing Trial Recovery
Enabling and Performing Flashback Database
Recovering From User Errors
Using Flashback Query
Auditing and Recovering Transactions Using the Flashback Transaction Query Feature
Retrieving Row History Information Using the Flashback Version Query Feature
Recovering Table Data Using the Flashback Table Feature
Recovering Dropped Tables using Flashback Drop Feature
Flashing back a transaction
Using LogMiner Enhancements
Managing Performance
Using the SQL Tuning Advisor
Using the SQL Access Advisor
Using the trcsess Utility to Consolidate Output from Trace Files
Using DBMS_MONITOR
Diagnosability Enhancements
Oracle Database 11g Fault Management
Ease Diagnosis: Automatic Diagnostic Workflow
Automatic Diagnostic Repository
Incident Packaging Configuration
Running Health Checks
Using the SQL Repair Advisor
Viewing, Disabling, or Removing a SQL Patch
Miscellaneous New Features
Managing & Using SQL Query Result Cache
Adaptive Cursor Sharing: Architecture
Temporary tablespace shrinkage
Using the client result cache
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
