欢迎光临重庆思庄数据库运维服务中心!重庆思庄是甲骨文(Oracle)产品重庆地区金牌代理商,是红帽、甲骨文重庆官方培训点,与VUE合作,成立重庆思庄VUE国际考试中心!
咨询热线:
023-68037655
13883183259
搜索
首页
技术服务
安装类服务
安全类服务
优化类服务
更新类服务
紧急类服务
日常类服务
备份恢复服务
规划咨询服务
解决方案
按年服务
按次服务
按项目服务
自定义服务
软件产品
数据库
中间件
系统集成
企业管理
操作系统
管理软件
虚拟化
服务器存储
培训服务
Oracle培训
Linux培训
专题培训
企业定制培训
客户案例
通信行业
医疗行业
保险行业
金融行业
行政行业
教育行业
大型制造
关于思庄
公司简介
联系我们
加入思庄
新闻动态
环境设施
技术分享
常见问题
思庄论坛
当前位置:
主页
>
关于思庄
>
技术分享
>
Oracle Database 12c R2: Administration Workshop Ed 3
发布时间:
2017-06-29
oracle 12.2教材知识点:
Getting Started
Course Objectives
Exploring Oracle Database Architecture
Introducing Oracle Database
Relation Database Models
Oracle SQL and PL/SQL
Oracle Database Server Architecture
Connecting to Oracle Databases
Oracle Database Tools
Oracle-Supplied User Accounts
Querying the Oracle Data Dictionary
Managing Database Instances
Initialization Parameter Files
Starting Up Oracle Databases
Shutting Down Oracle Databases
Opening and Closing PDBs
Working with the Automatic Diagnostic Repository (ADR)
Querying Dynamic Performance Views
Creating PDBs
Methods and Tools to Create PDBs
Creating PDBs from Seed with SQL*Plus
Cloning PDBs with SQL*Plus
Unplugging and Pluggin In PDBs with SQL*Plus
Dropping PDBs with SQL*Plus
Configuring the Oracle Network Environment
Oracle Net Services
How Listeners Work
Configuring Listeners for Dynamic Service Registration
Configuring Listeners for Static Service Registration
Configuring Local Naming for Connections
Testing Oracle Net Connectivity with tnsping
Configuring Communidation Between Databases
Dedicated Versus Shared Server Configurations
Administering User Security
Creating Users
Granting Privileges
Creating and Granting Roles
Revoking Privileges and Roles
Creating and Assigning Profiles
Authenticating Users
Assigning Quotas to Users
Applying the Principal of Least Privilege
Creating and Managing Tablespaces
How Table Data is Stored
Creating Tablespaces in SQL*Plus
Altering and Dropping Tablespaces in SQL*Plus
Viewing Tablespace Information in SQL*Plus
Implementing Oracle Managed Files
Moving and Renaming Online Data Files in SQL*Plus
Managing Storage Space
Oracle Database Space Management Features
Block Space Management
Row Chaining and Migration
Free Space Management Within Segments
Types of Segments
Allocating Extents
Understanding Deferred Segment Creation
Space-Saving Features
Managing UNDO Data
Undo Data: Overview
Transactions and Undo Data
Storing Undo Information
Comparing Undo Data and Redo Data
Managing Undo
Local Undo Mode Versus Shared Undo Mode
Configuring Undo Retension
Categories of Undo
Moving Data
Moving Data: General Architecture
Oracle Data Pump: Overview
Oracle Data Pump: Benefits
Data Pump Export and Import Clients
Data Pump Utility: Interfaces and Modes
Data Pump Import: Transformations
SQL*Loader Overview
Loading Methods
Backup and Recovery Concepts
DBA Responsibilities
Categories of Failure
Understanding Instance Recovery
Understanding Types of Backups
Comparing Complete and Incomplete Recovery
Oracle Data Protection Solutions
Flashback Technology
Monitoring and Tuning Database Performance
Managing Performance Activities
Performance Planning Considerations
Database Maintenance
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor
Performance Monitoring
Performance Tuning Methodology
Database Server Statistics and Metrics
SQL Tuning
SQL Tuning Process
Oracle Optimizer
Optimizer Statistics
SQL Plan Directives
Adaptive Execution Plans
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer
Oracle Database Resource Manager
Oracle Database Resource Manager: Overview
Resource Manager Elements
Using Resource Manager to Allocate Resources
Creating a Simple Resource Plan
Creating a Complex Resource Plan
Using the Active Session Pool Feature
Limiting CPU Utilization at the Database Level
Limiting CPU Utilization at the Server Level
Enterprise Manager Cloud Control
Controlling the Enterprise Manager Cloud Control Framework
Starting the Enterprise Manager Cloud Control Framework
Stopping the Enterprise Manager Cloud Control Framework
Introduction to Oracle Database Cloud Service
Oracle Cloud: Overview
Database Cloud Service Offerings
DBCS Architecture
Features and Tooling
Additional Database Configuration Options
Creating DBCS Database Deployments
Automated Database Provisioning
Creating a Database Deployment
How SSH Key Pairs are Used
Creating an SSH Key Pair
Storage Used for Database Files
Managing DBCS Database Deployments
Cloud Tooling
Accessing Tools and Features from the DBCS Console
Managing the Compute Node Associated With a Database Deployment
Managing Network Access to DBCS
Enabling Access to a Compute Node Port
Scaling a Database Deployment
Backing Up and Restoring DBCS Database Deployments
Backing Up and Recovering Databases on DBCS
Backup Destination Choices
Backup Configuration
Creating an On-Demand Backup
Customizing the Backup Configuration
Performing Recovery by Using the Console
Performing Recovery by Using the dbaascli Utility
Patching DBCS Database Deployments
Patching DBCS
Using the DBCS Console to Manage Patches
Using the dbaascli Utility to Manage Patches
Creating Master Encryption Keys for PDBs
CDB and PDB Master Encryption Keys
Determining Whether You Need to Create and Activate and Encryption Key for a PDB
Creating and Activating an Encryption Key
Tablespace Encryption by Default
Tablespace Encryption by Default in DBCS
Transparent Data Encryption (TDE) Overview
Components of TDE
Using TDE
Defining the Keystore Location
Controlling Tablespace Encryption by Default
Managing the Software Keystore and Master Encryption Key
Managing the Keystore in CDBs and PDBs
以上内容转自
重庆思庄技术论坛
技术服务
安装类服务
安全类服务
优化类服务
更新类服务
紧急类服务
日常类服务
备份恢复服务
规划咨询服务
软件产品
数据库
中间件
系统集成
企业管理
操作系统
管理软件
虚拟化
服务器存储
客户案例
通信行业
医疗行业
保险行业
金融行业
行政行业
教育行业
大型制造
关于思庄
公司简介
联系我们
加入思庄
新闻动态
环境设施
技术分享
常见问题
网站地图
XML地图
联系我们
重庆思庄科技有限公司
023-68037655 / 68429836
重庆思庄科技有限公司 版权所有© 备案号:渝ICP备12004239号-1
<<
QQ在线
QQ在线
QQ在线