Oracle Database 11g Release 2 New Features Seminar
|
Summary
|
|
|||||||||||||
Oracle Database 11g Release 2 New Features Seminar
This Oracle Database 11g Release 2 New Features Seminar is designed to give delegates an appreciation of the new features available in Oracle Database 11g Release 1 and 2 and of how these features may affect current Oracle installations.
The delegate will gain an understanding of:
- Installation changes
- Upgrade issues
- Enterprise Manager changes
- Hot patching
- SQL new features
- PL/SQL new features
- New memory management features
- Database Replay to capture, process and replay a workload
- ASM improvements
- The Data Recovery Advisor and Flashback
- Transaction management using Flashback and LogMiner
- RMAN new features
- Data Guard improvements
- Performance tuning new features
- New security features
- New schema management functionality
- Data warehousing enhancements
- Miscellaneous new features
This Oracle Database 11g Release 2 New Features Seminar is designed for Oracle professionals who need an understanding of Oracle Database 11g Release 1 and 2 new features. This seminar is suitable for users of Release 1 and Release 2.
By the end of the Oracle Database 11g Release 2 New Features Seminar, the delegate will have gained an appreciation of the new features available in Oracle Database 11g Release 1 and 2 and how these can be implemented.
Delegates should have an appreciation of the features available in an Oracle Database 10g database.
There is no practical content within this Oracle Database 11g Release 2 New Features Seminar.
- Oracle Database 11g Release 2 for Experienced 10g Database Administrators
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Automatic Diagnostic Repository (ADR)
- Parameter file management changes
- Automatic Memory Management
- Oracle Grid Infrastructure and Oracle Restart
- Installing Oracle Database 11g
- The DBCA
- Online patching
- Changes in 11g Release 1 and 2
- Upgrade to Oracle Database 11g Release 2
- New parameters
- Deprecated parameters
- Obsolete parameters
- Case sensitive passwords
- Default password
- Privileges audited by default
- Password verify function
- Transparent tablespace encryption
- Fine grained access to database network services
- Data masking
- Securefile LOBs
- Security and OEM
- ADDM New features
- AWR New features
- Auto Task overview
- Auto Task architecture
- Auto Task dictionary views
- Use OEM to manage Auto Task
- Manage Auto Task manually
- The Auto Task maintenance windows
- Email Notification
- File Watcher
- Remote Database Jobs
- Multiple Destination Jobs
- DDL wait option
- Add columns with default value
- Virtual columns
- Invisible indexes
- Read only tables
- New SQL commands
- Lock table parameter
- Client side caching
- Server result cache
- Named notation
- PL/SQL function cache
- PL/SQL native compilation
- Natural sequences
- When Others Then Null
- Create trigger as enabled or disabled
- Compound triggers
- Create trigger follows clause
- PL/SQL Continue statement
- Automatic block corruption reporting
- Automatic quarantine of corrupt undo segments
- Protection from data corruptions
- Improvements to ANALYZE ... VALIDATE STRUCTURE
- Proactive Monitoring with the Health Monitor
- RMAN ENHANCEMENTS
- Automatic channel failover
- Parallel backup and restore for very large files
- Multisection backups
- Improved handling of long-term backups
- Backup failover for archived redo logs
- Archived redo log deletion policy
- Undo backup optimization
- Improved block corruption detection
- Improved block media recovery
- Substitution variables
- Compressed backups
- Virtual private catalogs
- Merge catalogs
- Backup a recovery catalog
- Data Recovery Advisor overview
- DRA through the RMAN command line
- Use DRA through OEM
- Flashback history
- Flashback transaction backout
- Transaction management with LogMiner and Flashback Data Archive
- LogMiner Interface in OEM
- Oracle Total Recall
- Create a Flashback Data Archive
- Flashback query
- Overview of Database Replay
- The Database Replay process
- Capture a workload
- Pre process the captured workload
- Replay the workload
- Database Replay usage
- The DBMS_WORKLOAD Packages
- The exp utility deprecated
- Dump file set compression
- Encryption enhancements
- Rename table
- Dumpfile overwrite
- Partitioned tables
- The transportable parameter
- The data options parameter
- Data Pump legacy mode
- RMAN duplicate database
- Active database duplication
- Snapshot standby database
- Real time query
- Lost write protection
- Repair advisors and fault diagnostics
- The SQL Repair Advisor
- The SQL Access Advisor
- The Streams Performance Advisor
- New DBA Advisor views
- SYSASM role
- Disk group attributes
- Fast disk resync
- Preferred mirror read
- Support for variable extent sizes
- Drop diskgroup force
- Metadata backup and restore
- ASM Cluster File System (ACFS)
- ASM Dynamic Volume Manager (DVM)
- ASM intelligent datapPlacement
- ASM File Access Control
- Fault diagnostic automation
- Automatic diagnostic workflow
- Problems and incidents
- Incident packaging service
- EM Support Workbench
- Improved statistics gathering
- Real time SQL monitoring
- SQL Performance Analyzer
- Intelligent cursor sharing
- SQL Plan management
- Temporary tablespace shrink
- Test Case Builder
- Partitioning enhancements
- Materialized view enhancements
- Query rewrite enhancements
- PIVOT and UNPIVOT commands
- Data compression
- Enhancements to the degree of parallelism
- In memory parallel query
- I/O calibration
- Resource Manager new features
- Default maintenance plan
- New built in plans
- Resource Manager statistics in AWR
- Instance Caging
If you want to find out more about Oracle Database 11g Release 2 New Features Seminar, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from Oracle Database 11g Release 2 New Features Seminar, please fill out the following details:
