AUDIENCE:   Existing Oracle 10G DBA's needing a thorough understanding of the New Features in Oracle 11G from a DBA viewpoint. PREREQUISITES:   The course is for experienced Oracle Version 10.2 DBAs. DURATION:   2 days. Hands on. OBJECTIVES:   This event is designed to bring existing R10.2 DBAs up to date with the new features in the 11g release, covering the following areas: 1) 11g DBA database server features 2) 11g Enterprise Manager new features 3) 11g RMAN new features The course addresses database server issues that all DBAs will need to be aware of. As a product, Oracle is ever expanding its horizons to a degree that now encompasses a significant proportion of the datacentre skills requirement. There is no longer time for an individual to learn Oracle offerings in their entirety. In response, many data centres have DBAs specialising in particular areas of Oracle DBA and we have adjusted our course breakdown to reflect this. The “11G new features for DBAs” course is a good introduction that will make all DBAs aware of platform advancements at the new release. COURSE CONTENT:   1 Changes to the database server Parameters, OFA changes, New admin subdirectories, Alert log changes, Table-level control of CBO statistics 2 Database Replay Architecture, Capture, AWR, Replay Analysis 3 SQL Performance Analyzer SPA Architecture, What to change ?, SPA package, SQL Performance analyzer workflow, Creating a SQL Tuning Set, Creating a SQL performance analyzer task, Reporting 4 Transaction management LogMiner interface in Oracle Enterprise Manager, LogMiner command line interface, Flashback Data Archive 5 Table and index partitioning Extended composite partitioning, Reference partitioning, Interval partitioning, System partitioning, Tablespace transport for a single partition, Virtual column partitioning Partition Advisor, Partition Advisor 6 Schema management DDL wait option, Adding columns with a default value, Virtual columns, Invisible indexes, Read only tables 7 Storage NFS improvements, Secure Files (Next generation LOBS), Version control - Oracle File Group Repository, Oracle 11g XML data storage 8 RMAN Data recovery advisor, Advise failure and repair options, Repair failure preview, Pro-active health checks, Validate database, Enterprise Manager interface to RMAN, Flashback logs, Zlib compression, Parallel backup of the same datafile, Backup committed undo, Virtual private catalog, Merging catalogs MB07/01