Seminar-Konfigurator

Detaillierte Beschreibung

ORACLE Database 12c

Admin, Install and Upgrade Accelerated

Inhalte
  • 1. Tag
  • Oracle Database 12c Overview
  • Introduction & Architecture
  • Instance Configurations, Memory Structures, Process Structures
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Container and Pluggable Database Overview
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Grid Infrastructure for a Standalone Server
  • Configuring Storage for Automatic Storage Management (ASM)
  • Installing Grid Infrastructure for a Standalone Server
  • Installing Oracle Database Software
  • Planning Your Installation, System Requirements
  • Using 4 KB Sector Disks
  • Setting Environment Variables
  • Creating an Oracle Database by Using DBCA
  • Planning the Database Storage Structure
  • non-CDB or CDB, Types of Databases (based on workload)
  • Choosing the Appropriate Character Set
  • Using the Database Configuration Assistant (DBCA)
  • Using Oracle Restart
  • Overview & Process startup
  • Controlling Oracle Restart
  • Oracle Restart Configuration
  • Using the SRVCTL Utility
  • 2. Tag
  • Introduction to Upgrading to Oracle Database 12c
  • Upgrade Methods, Data Migration Methods
  • Overview of Upgrade Process
  • Performing a Rolling Upgrade, Upgrading a CBD
  • Preparing to Upgrade to Oracle Database 12c
  • Developing a Test Plan, Performance Testing
  • Using the Pre-Upgrade Information Tool
  • Backing Up the Database
  • Installing the Oracle Database 12c Software
  • Preparing the New Oracle Home
  • Upgrading to Oracle Database 12c
  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Migrating Data by Using Oracle Data Pump
  • Data Pump Overview
  • Migrating by Using Data Pump
  • Importing by Using a Network Link
  • 3. Tag
  • Exploring the Oracle Database Architecture
  • Architecture Overview
  • Instance Configurations, Memory Structures
  • Process Architecture, Process Structures
  • Database Storage Architecture
  • Managing the Database Instance
  • Understanding the Enterprise Manager Management Framework
  • Logging in to Oracle Enterprise Manager Database Express
  • Using the Enterprise Manager Database Express Home Page
  • Using Enterprise Manager Cloud Control
  • Using SQL*Plus and SQL Developer
  • Initialization Parameter Files
  • Configuring the Oracle Network Environment
  • Oracle Net Services and Net Listener
  • Listener Control Utility, Assistant and Manager
  • Enterprise Manager Cloud Control
  • Managing Database Storage Structures
  • Database Block Contents
  • Exploring the Storage Structure
  • Creating and Managing Tablespaces
  • 4. Tag
  • Administering User Security
  • Database User Accounts, Administrative Accounts
  • Authentication, Privileges, Roles, Profiles
  • Managing Data Concurrency
  • Locking Mechanism, Data Concurrency
  • DML Locks, Enqueue Mechanism, Lock Conflicts
  • Managing Undo Data
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Configuring Undo Retention
  • Implementing Oracle Database Auditing
  • Separation of Responsibilities, Database Security
  • Monitoring for Compliance, Standard Database Auditing
  • Unified Audit Data Trail
  • Performing Database Maintenance
  • Database Maintenance
  • Viewing the Alert History
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework, Enterprise Manager and Advisors
  • 5. Tag
  • Managing Performance
  • Performance Monitoring
  • Tuning Activities, Performance Planning
  • Instance Tuning, Monitoring Performance, Managing Memory
  • Performance Tuning Methodology & Data
  • Managing Performance: SQL Tuning
  • SQL Tuning, Oracle Optimizer
  • SQL Plan Directives, Adaptive Execution Plans
  • SQL Tuning Advisor
  • Managing Resources by Using Database Resource Manager
  • Database Resource Manager Concepts
  • Using the Resource Manager
  • Default Maintenance Resource Manager Plan
  • Resource Manager Workflow
  • Specifying Resource Plan Directives
  • Resource Allocation Methods for Resource Plans
Ihre Wunschthemen
Diese Konfiguration jetzt anfragen