Oracle 11g: New Features for Administrators培训成都常州济南长沙武汉重庆

Oracle 11g: New Features for Administrators培训
Oracle 11g: New Features for Administrators培训
培训大纲：
1. Oracle Database 11g: Installation and Upgrade Enhancements
Benefits of Oracle''s Infrastructure grid and self-tuning capabilities
Changes to the Oracle database installation process and the steps for installing Oracle Database 11g
Oracle Database 11g''s upgrade enhancements and the steps for performing an upgrade
Running the Oracle Database Upgrade Assistant as part of an upgrade
Common post-upgrade steps and adjustments to initialization parameters and the steps for creating a database
Enabling Direct Network File System and installing a hot patch
Best practices and recommendations for testing and analyzing an Oracle Database 11g installation
Create a new Oracle Database 11g database
2. Oracle Database 11g: Storage Enhancements
Ways to enhance efficiency and performance of Oracle Database 11g by using Automatic Storage Management (ASM) Fast Mirror Resync and ASM Preferred Mirror Read
Ways to use ASM to enhance scalability and performance and control disk group attributes and compatibility
Adding an offlined disk without ASM and also with ASM, following a nondata issue
Syntax for performing disk group checks, mounting disk groups for fast rebalance, and forcing a disk group drop
Correct method for backing up ASM metadata using ASMCMD extensions
Back up ASM metadata using ASMCMD extensions
3. Oracle Database 11g: Change Management Overview and SQL Plan Management
Steps for managing change when upgrading or reconfiguring Oracle Database, including setting up a snapshot standby database as a test environment
General uses and benefits of SQL Performance Analyzer for ascertaining performance gains following a database change
Steps for capturing the SQL workload using SQL tuning sets
Tasks that can be performed when managing components using the SQL Performance Analyzer
Ways in which the different phases of the SQL Performance Analyzer help to assess the SQL performance impact of change
Elements of SQL plan management and the steps for seeding SQL plan baselines
Ways to load and evolve SQL plan baselines, select SQL plans, and set up various SQL plan management scenarios
Executing all phases of SQL plan management
Seed SQL Plan Baselines for your most regressing statements
4. Oracle Database 11g: Database Replay and Automatic SQL Tuning
Benefits of using Database Replay and the concepts and reasons behind recreating a production database workload in a test environment.
Identify the scope of Database Replay''s capabilities by recognizing the supported database changes and workloads, as well as some of the considerations and available options during capture, replay and replay analysis
Running Database Replay using the Capture Wizard in Enterprise Manager
Replaying workload using the Replay Workload Wizard and using PL/SQL to do the same, as well as calibrating replay clients
Capturing the workload for a small application using Database Replay and replaying it to get the same results as during the original execution
Run Database Replay in Enterprise Manager
How SQL tuning can benefit developers in improving the performance of SQL statements and the methods and DBA controls that you can use in Oracle Database 11g to run the Automatic SQL Tuning feature
General steps and concepts behind configuring Automatic SQL Tuning, reviewing results, and performing a fine tune using PL/SQL
Executing Automatic SQL Tuning and viewing its results
5. Oracle Database 11g: Intelligent Infrastructure Enhancements
The scope of Oracle Database 11g''s AWR Baselines feature, which includes baseline template creation options and baseline views
Creating an AWR Baseline and using it to define alert thresholds
Benefits of the Automatic Maintenance Tasks feature for statistics collection, segment advisor, and Automatic SQL Tuning, and how to control such tasks
Calibrating I/O resources in Oracle Database 11g
How to manage resources and streamline schedules using the Resource Manager and lightweight jobs
Creating and running lightweight scheduler jobs
Calibrate I/O Resources in Oracle Database 11g
6. Oracle Database 11g: Performance Enhancements
Different ways to use Automatic Database Diagnostic Monitor to analyze Oracle Real Application Clusters (RACs) and report on issues affecting the entire database as well as individual instances
Benefits of Oracle Database 11g''s Automatic Memory Management system
Concepts and methods employed in Oracle database 11g for gathering and publishing various kinds of statistics
Observing memory distribution patterns using Automatic Memory Management and also for testing various statistic gatherings on a particular table
Use Automatic Memory Management to observe memory distribution patterns
7. Oracle Database 11g: Partitioning and Storage-Related Enhancements
Employing Oracle Database''s new partitioning scheme to perform interval partitioning
Performing system and virtual column-based partitioning and using Oracle Database 11g''s new partitioning scheme
Performing reference partitioning using Oracle Database 11g''s new partitioning scheme
Performing extended composite partitioning using Oracle Database 11g''s new partitioning scheme and compressing tables
Using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your database''s workload\
Use the SQL Access Advisor to get partitioning recommendations
8. Oracle Database 11g: Using RMAN Enhancements, Flashback and LogMiner
Ways in which enhancements to RMAN in Oracle Database 11g can help you perform faster and optimized backups
Duplicating an active Oracle Database 11g database
Creating and managing archival backups and RMAN catalogs in Oracle Database 11g
Duplicate an active Oracle Database 11g database
Benefits of Flashback Data Archives in Oracle Database 11g for retaining historical data
Using Flashback Data Archives
Using the Flashback Transaction Backout and LogMiner features to locate and roll back transactions and user errors in Oracle Database 11g
9. Oracle Database 11g: Diagnostic Enhancements and Using the Data Recovery Advisor
Scope and capabilities of the Automatic Diagnostic Repository (ADR) feature in Oracle Database 11g
Tasks that can be performed, using the Support Workbench wizard, to handle critical errors in Oracle Database 11g
Configuring incident packages and creating, manipulating, and modifying custom packages
Dealing with critical errors in Oracle Database 11g using the Health Monitor and SQL Repair Advisor tools
Options for assessing data failures in Oracle Database 11g using the Data Recovery Advisor
Getting advice on repairing data failures, executing these repairs using RMAN data repair commands, and setting parameters to detect further corruption
Repair a down database via Enterprise Manager
10. Oracle Database 11g: New Security Features
Ways to configure a password file to use case-sensitive passwords and how to configure security settings in Oracle Database 11g
Different types of encryption in Oracle Database 11g and the steps for managing fine-grained access to external network services
Ways for setting up administrator authentication and managing transparent data encryption and other security settings
Increasing the security of passwords and implementing tablespace encryption in Oracle Database 11g
Best way to encrypt a tablespace in Oracle Database 11g
11. Oracle Database 11g: SecureFiles and Miscellaneous New Features
Ways in which SecureFiles enhance the performance of large object (LOB) data types
Migrating to SecureFiles and for creating, altering, accessing, and monitoring them
Using SecureFiles for compression, data encryption, and performance
Benefits of SQL Query Result Cache and PL/SQL Function Cache as well as using other Oracle Database 11g enhancements to online redefinition, locking mechanisms, and invisible indexes
Benefits of PL/SQL native compilation enhancements, Adaptive Cursor sharing, and temporary tablespace shrink
Using the SQL Query Result Cache in Oracle Database 11g
Ways of employing the SQL Query Result Cache in a given scenario

	备案号：备案号:沪ICP备08026168号-1	.(2014年7月11)...................
友情链接：Cadence培训 ICEPAK培训 EMC培训电磁兼容培训 sas容培训罗克韦尔PLC培训欧姆龙PLC培训 PLC培训三菱PLC培训西门子PLC培训 dcs培训横河dcs培训艾默生培训 robot CAD培训 eplan培训 dcs培训电路板设计培训浙大dcs培训 PCB设计培训 adams培训 fluent培训系列课程培训机构课程短期班培训班系列课程培训机构长期课程列表班实践课程高级课程学校培训机构周末班培训南京 NS3培训 OpenGL培训 FPGA培训 PCIE培训 MTK培训 Cortex训 Arduino培训单片机培训 EMC培训信号完整性培训电源设计培训电机控制培训 LabVIEW培训 OPENCV培训集成电路培训 UVM验证培训 VxWorks培训 CST培训 PLC培训 Python培训 ANSYS培训 VB语言培训 HFSS培训 SAS培训 Ansys培训短期班培训班系列课程培训机构长期课程列表班实践课程高级课程学校培训机构周末班曙海教育企业学院培训课程系列班级长期课程列表班实践课程高级课程学校培训机构周末班短期班培训班系列课程培训机构曙海教育企业学院培训课程系列班级软件无线电培训 FPGA电机控制培训 Xilinx培训 Simulink培训 DSP培训班数字信号培训 Ansys培训 LUA培训单片机培训班 PCB设计课程 PCB培训电源培训电路培训 CST培训 PLC课程变频器课程 Windows培训 R语言培训 Python培训 5G培训