 班級規(guī)模及環(huán)境--熱線:4008699035 手機(jī):15921673576( 微信同號) |
|
每期人數(shù)限3到5人。 |
| 上課時間和地點(diǎn) |
上課地點(diǎn)：【上海】：同濟(jì)大學(xué)(滬西)/新城金郡商務(wù)樓(11號線白銀路站) 【深圳分部】：電影大廈(地鐵一號線大劇院站)/深圳大學(xué)成教院 【北京分部】：北京中山學(xué)院/福鑫大樓 【南京分部】：金港大廈(和燕路) 【武漢分部】：佳源大廈（高新二路） 【成都分部】：領(lǐng)館區(qū)1號（中和大道） 【沈陽分部】：沈陽理工大學(xué)/六宅臻品 【鄭州分部】：鄭州大學(xué)/錦華大廈 【石家莊分部】：河北科技大學(xué)/瑞景大廈 【廣州分部】：廣糧大廈 【西安分部】：協(xié)同大廈
最近開課時間(周末班/連續(xù)班/晚班）：2020年3月16日 |
| 實(shí)驗(yàn)設(shè)備 |
☆資深工程師授課
☆注重質(zhì)量
☆邊講邊練
☆合格學(xué)員免費(fèi)推薦工作
★實(shí)驗(yàn)設(shè)備請點(diǎn)擊這兒查看★ |
| 質(zhì)量保障 |
1、培訓(xùn)過程中，如有部分內(nèi)容理解不透或消化不好，可免費(fèi)在以后培訓(xùn)班中重聽；
2、培訓(xùn)結(jié)束后,授課老師留給學(xué)員聯(lián)系方式,保障培訓(xùn)效果,免費(fèi)提供課后技術(shù)支持。
3、培訓(xùn)合格學(xué)員可享受免費(fèi)推薦就業(yè)機(jī)會。 |
課程大綱 |
| |
- Oracle Database 11g: New Features for Administrato
Oracle Database 11g: New Features for Administrators DBA Release 2 (11gR2-DB-NF)培訓(xùn)
培訓(xùn)大綱：
1. Oracle Grid Infrastructure
Installing Oracle Grid Infrastructure for a Standalone Server
Creating an ASM Disk Group
ASM Cluster File System
ASM Dynamic Volume Manager
ASM File System Snapshot
2. Installation and Upgrade Enhancements
Installing Oracle Database 11g Release 2
Oracle Database Upgrade Enhancements
Online Patching
Upgrading Your Time Zone File and Timestamp with Time Zone Data
3. Oracle Restart
Controlling Oracle Restart
Using the srvctl Utility
Manually Adding Components to the Oracle Restart Configuration
4. ASM Enhancements
Setting up ASM Fast Mirror Resync
Using ASM Scalability and Performance Enhancements
ASM Disk Group Compatibility
Using ASMCMD Extensions
ASM File Access Control
ASM Optimal Disk Placement
5. Storage Enhancements
Using 4 KB-Sector Disks
Using Table Compression
Hybrid Columnar Compression
SQL Access Advisor
Segment Creation on Demand
6. Data Warehouse and Partitioning Enhancements
Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
Degree of Parallelism Enhancements
In-Memory Parallel Query
Partitioning Enhancements
System-Managed Indexes for List Partitioning
7. Oracle SecureFiles
Enabling SecureFiles Storage
Creating SecureFiles
Using SecureFiles Compression
Accessing SecureFiles Metadata
Migrating to SecureFiles
8. Security and Networking Enhancements
Secure Password Support
Automatic Secure Configuration
Managing Default Audits
Setting Database Administrator Authentication
Transparent Data Encryption
Hardware Security Module
Tablespace Master Key Re-Key
Supporting IPv6 Address Notification
9. SQL Performance Analyzer
Using SQL Performance Analyzer
Using Enterprise Manager to Access SQL Performance Analyzer
SQL Performance Analyzer: PL/SQL Example
SQL Performance Analyzer: Data Dictionary Views
10. SQL Plan Management
Overview
Loading SQL Plan Baselines
Using the MIGRATE_STORED_OUTLINE Functions
Viewing Important Baseline SQL Plan Attributes
Loading a SQL Plan Baseline Automatically
Purging SQL Management Base Policy
11. Database Replay
Using Database Replay
Database Replay System Architecture
Supported Workloads
Database Replay Workflow in Enterprise Manager
Database Replay PL/SQL Procedures
Database Replay Data Dictionary Views
12. Automatic SQL Tuning
Automatic SQL Tuning in Oracle Database 11g
Selecting Potential SQL Statements for Tuning
Controlling the Automatic SQL Tuning Task
Configuring Automatic SQL Tuning
Using the PL/SQL Interface to Generate Reports
13. Intelligent Infrastructure Enhancements
Using New Automatic Workload Repository Views
Creating AWR Baselines
Alert Thresholds Using Static Baseline
Controlling Automatic Maintenance Tasks
Fixed Policy and CPU Resource Management
Instance Caging
Scheduler Enhancements
14. Diagnosability Enhancements
Setting Up Automatic Diagnostic Repository
ADRCI: The ADR Command-Line Tool
Incident Packaging Service (IPS)
Using the Enterprise Manager Support Workbench
Invoking IPS Using ADRCI
Running Health Checks Manually
Using the SQL Repair Advisor
15. SQL Monitoring
SQL Monitoring in Oracle Database 11g Release 2
Viewing Session Details
Viewing the SQL Monitoring Report
16. Performance Enhancements
Using the DBMS_ADDM Package
New and Modified Views
Enabling Automatic Memory Management
Using New Statistic Preferences Features
Locking Enhancements
Adaptive Cursor Sharing
Using Table Annotation to Control Result Caching
17. Application Maintenance and Upgrade Enhancements
Online Redefinition Enhancements
Creating and Using Invisible Indexes
18. Backup and Recovery Enhancements
Using New SET NEWNAME Clauses
Optimized Backups
Using New Settings for Binary Compression
Enhancements to Database Duplication
Creating Archival Backups
TSPITR Enhancements and Modifications
Creating and Using Virtual Private Catalogs
Introduction to Oracle Secure Backup Cloud Module
19. Flashback Technology, LogMiner, and Data Pump
Oracle Total Recall
Flashback Transaction Backout
Enterprise Manager LogMiner Interface
Data Pump Legacy Mode
20. Data Recovery Advisor
Assessing Data Failures
Data Recovery Advisor RMAN Command-Line Interface
Data Recovery Advisor Views
Setting Parameters to Detect Corruption
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
???
?
?
?
?
?
|
首頁 課程表 在線聊 報名 講師 品牌 QQ聊 活動 就業(yè)