Oracle Database 10g: New Features for Administrators Release 2
This course introduces students to the new features in Oracle Database 10g Release 2 - the database for Grid computing. Students learn how to use Oracle Database 10g new features to increase database availability, to simplify database performance monitoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security changes that students need to understand. Hands-on practice sessions give students an opportunity to examine many of the new features, and to practice database administration with Enterprise Manager Database Control.
Learn to:
VLDB Enhancements
Flashback Recovery
Automatic Management
Enhancements to Storage Management
Backup and Recovery Enhancements
Enhancements Space Management
Skills Gained
Using Database Control to simplify database management
Proactively monitoring the database
Increasing data availability by using improved point in time recovery features
Implementing Automatic Storage Management
Managing Metric Baselines
Using Oracle Secure Backup
Simplifying Instance Configuration
Using Data Pump Export and Import
Configuring the Scheduler
Using the Automatic Workload Repository
Managing Services
Creating Bigfile Tablespaces
Creating Hash-Partitioned Global Indexes
Creating Compressed Backup sets in RMAN
Configuring Flashback Database
Creating the SYSAUX Tablespace
Who Can Benefit
Database Administrators
Database Designers
Project Manager
Data Warehouse Administrator
Sales Consultants
Support Engineer
Technical Consultant
Prerequisites
9i DBA Fundamentals
Oracle9i Database Administration Fundamentals I
Oracle9i Database Administration Fundamentals II
Oracle9i Database: New Features for Administrators
Code:
10gDB-NF
Length:
5 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$3,000 / contact for GSA GOV.
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.
Metric Baseline and Adaptive Threshold Considerations
Classification of Eligible Metrics
Configure Normalization Metrics
Application Tuning
Automatic Statistics Gathering
Enhanced Query Optimization
Using Enterprise Manager to Gather Dictionary Statistics
Automatic SQL Tuning
SQL Tuning Loop
SQL Tuning Advisor
Concurrency Wait Class: Drill Down
Duplicate SQL page
System Resource Management
Database Resource Manager
Setting Idle Timeouts
Switching Back to the Initial Consumer Group at End of Call
Creating a Mapping Using Database Control
Using the RATIO Allocation Method
Monitoring the Resource Manager Using EM
Switching Plans at Scheduler Window Boundaries
Automating Tasks with the Scheduler
Privileges for Scheduler Components
Creating a Scheduler Job
Creating a Job Class
Creating a Window
Managing Jobs, Programs, Schedules, Windows, and Priority
Job chains
Using events
Space Management
Tablespace Space Usage Monitoring
Shrinking Segments
Automatic Segment Advisor
Fast Ramp-Up
Sorted Hash Cluster
Segment Metadata Dump and Verification
Improved VLDB Support
Create and maintain bigfile tablespaces
Interpret ROWIDs referencing bigfile tablespaces
Create temporary tablespace groups
Create list-partitioned index-organized tables
Create hash-partitioned global indexes
Partitioned IOT Enhancements
Skipping Unusable Indexes
Bitmap Index Storage Enhancements
Backup and Recovery Enhancements
New Backup and Recovery Strategy
Flash Backup and Recovery
Best Practices for the Database and Flash Recovery Area
Backup Maintenance
Implementing Fast Recovery
Automated Instance Creation and TSPITR
RMAN Command Changes
Setting Duration and Throttling Option
Oracle Backup
Installation
Implement the Oracle suggested strategy
RMAN and Oracle Backup
Database Backup/restore to tape
Install Oracle Backup (CLI)
Flashback Any Error
Flashback Database
Flashback Drop
Recycle Bin
Resource optimized DROP TABLE...PURGE for partitioned tables
Flashback Versions Query
Guaranteed Undo Retention
SCN and Time Mapping Enhancements
Restore Point Usage
General Storage Enhancements
SYSAUX Tablespace and Occupants
Tablespace Rename
Default Permanent Tablespace
Designating a Default Permanent Tablespace
Copying Files Using the Database Server
Redo Logfile Size Advisor
Dropping an Empty Data File
Automatic Storage Management
ASM: Key Features and Benefits
ASM Instance Creation
Accessing an ASM Instance
Starting Up and Shutting Down an ASM Instance
ASM Disk Group
ASM Files
Migrate Your Database to ASM
ASM and XML DB
Maintaining Software
Oracle Database 10g Upgrade Paths
Pre-Upgrade Utility Enhancements
DBUA Advantages
New Post-Upgrade Status Utility
Recompiling Invalid Objects
Performing the Manual Upgrade
OPatch Utility
Support for ASM only upgrade
Security
Virtual Private Database enhancements
Policy Types
Enhanced Enterprise User Auditing
Transparent Data Encryption
Enhanced Proxy Capabilities
Username and Password in Wallet
OS Audit in XML format
Connect role change
Services
Traditional Workload Dispatching
Grid Workload Dispatching
High Availability of Services in RAC
Service Aggregation and Tracing
The trcsess Utility
Session-Based and End-to-End Tracing
Using Enterprise Manager to Enable Statistics Aggregation
Using Enterprise Manager to Enable and View SQL Tracing
Miscellaneous New Features
Transaction Monitoring
Configurationless Client Connect
Resumable Space Allocation Enhancements
Implicit Conversion Between CLOB and NCLOB
UTL_MAIL and UTL_COMPRESS Package
LogMiner Enhancements
Asynchronous COMMIT
Direct Attach to SGA for Statistic Collection
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.
