Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
Oracle9i Database: New Features for Administrators
 
 
 
 
oracle certified training  
 
code. 9I-FEAT-ADMIN   length. 5 days
type. Instructor-Led   partner. Oracle
price.
$3,000 :: contact for GSA GOV.
 
 
This course is taught on Oracle9i Release 2. This course introduces students to the new features in Oracle9i that impact database administration. Students learn how to use Oracle9i capabilities to increase database availability, to simplify database performance monitoring and tuning, and to improve database manageability. The course also covers security and development platform changes that students need to understand if applications running in databases they support use the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 
Database Administrators
 
prerequisites
  
 

Enterprise DBA Part 1B: Backup and Recovery
 
skills gained
  
 

Utilize enhanced security options to protect Oracle9i database contents
Simplify database management tasks using Oracle9i features
Implement Oracle9i capabilities to improve database performance
Increase database availability using Oracle9i features
Assist developers using Oracle9i features in their applications


 
course content details  
 


  Oracle Server Security

Connecting as the DBA
Secure Application Role
Fine Grain Access Control Enhancements
Encryption Enhancements
Oracle Label Security
Oracle Login Server
Oracle Enterprise Login Assistant
Enterprise User Security Enhancements




  High-Availability Options

Two-pass Instance or Crash Recovery
Fast-Start Time-Based Recovery Limit
Mean Time To Recover (MTTR) Advisory
Changes to Parameters Related to Recovery
Changes to V$INSTANCE_RECOVERY
Oracle Flashback
Resumable Space Allocation
Export/Import Enhancements


  Backup and Recovery

RMAN Manageability Enhancements
RMAN Reliability Enhancements
Miscellaneous RMAN Enhancements


  Data Protection and Disaster Recovery

General Data Guard Architecture
Data Guard Broker, Data Guard Manager, and Data Protection Modes
Log Archive Destination Attributes
Creating Standby Redo Logs
Standby File Management
Background Managed Recovery Mode
Physical Standby and Parallel Recovery
Switchover and Failover


  Oracle9i LogMiner Enhancements

DDL Statement Support
Data Dictionary Access and Dictionary Information in the Redo Logs
Dictionary Staleness Detection
Optionally Display Only Committed Transactions Information
Database Supplemental Logging and Table Supplemental Logging
Optionally Record Primary Key Information
DBMS_LOGMNR_D.SET_TABLESPACE Procedure
LogMiner Restrictions, LogMiner Views, and LogMiner Viewer


  Database Resource Manager Enhancements

Active Session Pool
Maximum Estimated Execution Time
Automatic Consumer Group Switching
Undo Quota
Oracle Supplied Plans


  Online Operations

Online Index Rebuild Enhancements
Index Organized Table Availability Enhancements
Online Table Redefinition
Online Analyze Validate
Quiescing the Database
Server-Side Parameter File (SPFILE)


  Segment and Index Management

Global Index Maintenance During Partition DDLs
Partition types
Enhanced Parallel DML
Metadata API
Common Extraction, Transformation, and Loading Process
External Tables
Automatic Space Management Segments
Data Block Compression


  Performance Improvements

Enabling and Disabling Index Usage Monitoring
Cursor Sharing Enhancements
Cached Execution Plans and Execution Statistics
First Rows Optimization
Gathering Statistic Estimates
Optimizer Dynamic Sampling
Optimizer Cost Model Enhancements
Gathering System Statistics


  Real Application Clusters

Real Application Clusters Architecture
Global Cache Service and Dynamic Resource Remastering
Block Transfers
High Availability Features
Real Application Clusters Guard
Parameter File Enhancements and SRVCTL Commands
Real Application Clusters and Oracle Enterprise Manager
Background Processes and Initialization Parameters


  File Management

Oracle-Managed Files (OMF)
Default Temporary Tablespace
FILESYSTEMIO_OPTIONS Parameter




  Tablespace Management

Automatic SQL Execution Memory Management
Tuning PGA_AGGREGATE_TARGET
Dynamic SGA
Memory Management Using Enterprise Manager




  Memory Management

Automatic SQL Execution Memory Management
Tuning PGA_AGGREGATE_TARGET
Dynamic SGA
Memory Management Using Enterprise Manager


  Oracle Enterprise Manager And DBA Studio

Console Launched Standalone and Connections Using Management Server
HTML Database Reports and Database Configuration Report
User-Defined Events and Event Handler
Blackout Enhancements and Job System Enhancements
Intelligent Agent Enhancements and Events Creation Enhancements
Email-to-Page Email Address
Support for Message Transformation
Change Management Pack Enhancements


  SQL Enhancements

SQL:1999 Standard Join Syntax
Scalar Subqueries
Analytical Function, Grouping, and Constraint Enhancements
Index Scans and Function-Based Indexes
Multi-Table INSERT Statement
LONG to LOB Migration
Common SQL Parser
Native PL/SQL Execution


  Globalization Support

New Time and Interval Data Types
Enhanced Unicode Support
Linguistic Sorting and Length Semantics
Implicit Type Conversion for SQL NCHAR Datatype
SQL*Loader Unicode support
Character Set Scanner and Conversion
Oracle Locale Builder
New or Modified Globalization Settings


  Setting Up a Database Workspace

Installing Workspace Manager
Workspace Manager Administrator Role
Enabling and Disabling Table Versioning
DDL Operations and Version-Enabled Tables
Resolve Workspace Conflicts
Session Context Information
Import and Export Considerations
Workspace Metadata Views



 
Sun Microsystems Training Special


ExitCertified - Oracle 100% Student Satisfaction


find a course
 
phone us
 
view course schedule





Sun Microsystems Training Special

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware