Objetivo

Este Curso Oracle Database 23ai: Administration Workshop é direcionado a administradores de banco de dados e começa explicando a arquitetura de uma instância do Oracle Database e as ferramentas usadas para acessá-la. O Curso Oracle Database 23ai: Administration Workshop inclui a criação e o gerenciamento de um banco de dados, a configuração e o gerenciamento do Oracle Net Services, além da criação e administração de bancos de dados plugáveis ​​(PDBs). Você aprende a criar e gerenciar armazenamento de banco de dados, usuários, backup e implementar a segurança do banco de dados. Além disso, o Curso Oracle Database 23ai: Administration Workshop abrange a proteção do banco de dados contra falhas, carregamento e transporte de dados.

Materiais

Inglês/Português/Lab Prático

Conteúdo Programatico

Introduction to Oracle Database

1. Oracle Database Server Architecture: Overview
2. Oracle Database Instance Configurations
3. Oracle Multitenant Container Database: Introduction
4. Oracle Multitenant Container Database: Architecture
5. Oracle Database Memory Structures
6. Shared Pool
7. Database Buffer Cache
8. Redo Log Buffer
9. Large Pool
10. Java Pool and Streams Pool
11. Program Global Area (PGA)
12. Process Architecture
13. Process Structures
14. Database Writer Process (DBWn)
15. Log Writer Process (LGWR)
16. Checkpoint Process (CKPT)
17. System Monitor Process (SMON)
18. Process Monitor Process (PMON)
19. Recoverer Process
20. Archiver Processes (ARCn)
21. Database Sharding: Introduction
22. Oracle Database Server: Interactive Architecture Diagram

Accessing an Oracle Database

1. Connecting to an Oracle Database Instance
2. Oracle Database Tools
3. Database Tool Choices
4. SQL*Plus
5. Oracle SQL Developer
6. Oracle SQL Developer: Connections
7. Oracle SQL Developer: DBA Actions
8. Database Configuration Assistant (DBCA)
9. Oracle Enterprise Manager Database Express
10. Enterprise Manager Cloud Control 13c Features
11. Oracle Enterprise Manager Component Overview
12. Single Pane of Glass for Enterprise Management
13. Oracle Enterprise Manager Database Management

Creating an Oracle Database by Using DBCA

1. Planning the Database
2. Choosing a Database Template
3. Choosing the Appropriate Character Set
4. How are character sets used?
5. Setting NLS_LANG Correctly on the Client
6. Using the Database Configuration Assistant
7. Using DBCA in Silent Mode

Creating an Oracle Database by Using a SQL Command

1. Creating a Container Database (CDB)
2. Creating a CDB by Using a SQL Command: Example
3. Using the SEED FILE_NAME_CONVERT Clause
4. Using the ENABLE PLUGGABLE DATABASE Clause

Starting Up and Shutting Down a Database Instance

1. Starting the Oracle Database Instance
2. Shutting Down an Oracle Database Instance
3. Comparing SHUTDOWN Modes
4. Opening and Closing PDBs
5. Configuring PDBs to Automatically Open

Managing Database Instances

1. Working with Initialization Parameters
2. Initialization Parameters
3. Modifying Initialization Parameters
4. Viewing Initialization Parameters
5. Working with the Automatic Diagnostic Repository
6. Automatic Diagnostic Repository
7. Viewing the Alert Log
8. Using Trace Files
9. Administering the DDL Log File
10. Querying Dynamic Performance Views
11. Considerations for Dynamic Performance Views
12. Data Dictionary: Overview
13. Querying the Oracle Data Dictionary

Oracle Net Services: Overview

1. Connecting to the Database Instance
2. Oracle Net Services: Overview
3. Defining Oracle Net Services Components
4. Tools for Configuring and Managing Oracle Net Services
5. Oracle Net Listener: Overview
6. The Default Listener
7. Comparing Dedicated and Shared Server Architecture

Configuring Naming Methods

1. Establishing Oracle Network Connections
2. Connecting to an Oracle Database Instance
3. Name Resolution
4. Establishing a Connection
5. User Sessions
6. Naming Methods
7. Easy Connect
8. Local Naming
9. Directory Naming
10. Using Database Services to Manage Workloads
11. Creating Database Services

Configuring and Administering the Listener

1. Objectives
2. Review: Oracle Net Services Overview
3. Oracle Net Listener: Overview
4. The Default Listener
5. Configuring Dynamic Service Registration
6. Configuring Static Service Registration

Configuring a Shared Server Architecture

1. Shared Server Architecture: Overview
2. Comparing Dedicated and Shared Server Architecture: Review
3. Enabling Shared Server
4. Controlling Shared Server Operations
5. SGA and PGA Usage
6. Shared Server Configuration Considerations
7. Practice Overview

Creating PDBs from Seed

1. Provisioning New Pluggable Databases
2. Tools
3. Creating a New PDB from PDB$SEED
4. Using the FILE_NAME_CONVERT Clause
5. Using OMF or the PDB_FILE_NAME_CONVERT Parameter

Using Other Techniques to Create PDBs

1. Cloning Regular PDBs
2. Migrating Data from a Non-CDB into a CDB
3. Plugging a Non-CDB into CDB Using DBMS_PDB
4. Replicating a Non-CDB into a CDB by Using GoldenGate
5. Cloning a Non-CDB or Remote PDB
6. Using DBCA to Clone a Remote PDB
7. Plugging an Unplugged Regular PDB into CDB
8. Plugging in a PDB Using an Archive File
9. Cloning Remote PDBs in Hot Mode
10. Near-Zero Downtime PDB Relocation
11. Using DBCA to Relocate a Remote PDB
12. Proxy PDB: Query Across CDBs Proxying Root Replica
13. Creating a Proxy PDB

Managing PDBs

• Changing the PDB Mode
• Modifying PDB Settings
• Impact of Changing Initialization Parameters
• Changing Initialization Parameters: Example
• Using the ALTER SYSTEM Command in a PDB
• Configuring Host Name and Port Number per PDB
• Dropping PDBs

Database Storage Overview

1. Database Storage Architecture
2. Logical and Physical Database Structures
3. Segments, Extents, and Blocks
4. Tablespaces and Data Files
5. Default Tablespaces in a Multitenant Container Database
6. SYSTEM and SYSAUX Tablespaces
7. Types of Segments
8. How Table Data Is Stored
9. Database Block Content
10. Understanding Deferred Segment Creation
11. Controlling Deferred Segment Creation
12. Monitoring Tablespace Space Usage

Creating and Managing Tablespaces

1. Creating Tablespaces
2. Creating a Tablespace: Clauses
3. Creating Permanent Tablespaces in a CDB
4. Defining Default Permanent Tablespaces
5. Temporary Tablespaces
6. Altering and Dropping Tablespaces
7. Viewing Tablespace Information
8. Implementing Oracle Managed Files (OMF)
9. Enlarging the Database
10. Moving or Renaming Online Data Files
11. Examples: Moving and Renaming Online Data Files

Improving Space Usage

1. Space Management Features
2. Block Space Management
3. Row Chaining and Migration
4. Free Space Management Within Segments
5. Allocating Extents
6. Using Unusable Indexes
7. Using Temporary Tables
8. Creating Global Temporary Tables
9. Creating Private Temporary Tables
10. Table Compression: Overview
11. Table Compression: Concepts
12. Compression for Direct-Path Insert Operations
13. Advanced Row Compression for DML Operations
14. Specifying Table Compression
15. Using the Compression Advisor
16. Resolving Space Usage Issues
17. Reclaiming Space by Shrinking Segments
18. Shrinking Segments
19. Results of a Shrink Operation
20. Managing Resumable Space Allocation
21. Using Resumable Space Allocation
22. Resuming Suspended Statements
23. What operations are resumable?

Managing Undo Data

1. Undo Data: Overview
2. Transactions and Undo Data
3. Storing Undo Information
4. Comparing Undo Data and Redo Data
5. Managing Undo
6. Comparing SHARED Undo Mode and LOCAL Undo Mode
7. Configuring Undo Retention
8. Categories of Undo
9. Guaranteeing Undo Retention
10. Changing an Undo Tablespace to a Fixed Size
11. Temporary Undo: Overview
12. Temporary Undo Benefits
13. Enabling Temporary Undo
14. Monitoring Temporary Undo

Creating and Managing User Accounts

• Database User Accounts
• Oracle-Supplied Administrator Accounts
• Creating Oracle Database Users in a Multitenant Environment
• Creating Common Users in the CDB and PDBs
• Creating Schema-Only Accounts
• Authenticating Users
• Using Password Authentication
• Using Password File Authentication
• Using OS Authentication
• OS Authentication for Privileged Users
• Assigning Quotas

Configuring Privilege and Role Authorization

1. Objectives
2. Privileges
3. System Privileges
4. System Privileges for Administrators
5. Schema-Level Privileges
6. New Developer Role and Simplified Schema Privileges
7. Object Privileges
8. Granting Privileges in a Multitenant Environment
9. Granting Privileges: Example
10. Using Roles to Manage Privileges
11. Assigning Privileges to Roles and Assigning Roles to Users
12. Oracle-Supplied Roles
13. Granting Roles in a Multitenant Environment
14. Granting Roles: Example
15. Making Roles More Secure
16. Revoking Roles and Privileges
17. Granting and Revoking System Privileges
18. Granting and Revoking Object Privileges

Configuring User Resource Limits

• Profiles and Users
• Creating Profiles in a Multitenant Architecture
• Creating Profiles: Example
• Profile Parameters: Resources
• Profile Parameters: Locking and Passwords
• Oracle-Supplied Password Verification Functions
• Assigning Profiles in a Multitenant Architecture

Implementing Oracle Database Auditing

1. Database Security
2. Monitoring for Compliance
3. Types of Activities to be Audited
4. Mandatorily Audited Activities
5. Understanding Auditing Implementation
6. Administering the Roles Required for Auditing
7. Database Auditing: Overview
8. Configuring Auditing
9. Creating a Unified Audit Policy
10. Creating an Audit Policy: Systemwide Audit Options
11. Creating an Audit Policy: Object-Specific Actions
12. Creating an Audit Policy: Specifying Conditions
13. Enabling and Disabling Audit Policies
14. Auditing Actions in the CDB and PDBs
15. Modifying a Unified Audit Policy
16. Auditing Top-Level Statements Only
17. Viewing Audit Policy Information
18. Value-Based Auditing
19. Fine-Grained Auditing
20. FGA Policy
21. Audited DML Statements: Considerations
22. FGA Guidelines
23. Archiving and Purging the Audit Trail
24. Purging Audit Trail Records

Introduction to Loading and Transporting Data

1. Moving Data: General Architecture
2. Oracle Data Pump: Overview
3. Oracle Data Pump: Benefits
4. SQL Loader: Overview

Loading Data

1. SQL Loader: Review
2. Creating the SQL*Loader Control File
3. SQL*Loader Loading Methods
4. Protecting Against Data Loss
5. SQL*Loader Express Mode
6. Using SQL*Loader to Load a Table in a PDB

Transporting Data

1. Data Pump Export and Import Clients
2. Data Pump Interfaces and Modes
3. Data Pump Import Transformations
4. Using Oracle Data Pump with PDBs
5. Exporting from a Non-CDB and Importing into a PDB
6. Exporting and Importing Between PDBs
7. Full Transportable Export/Import
8. Full Transportable Export/Import: Example
9. Transporting a Database Over the Network: Example
10. Using RMAN to Transport Data Across Platforms
11. RMAN CONVERT Command
12. Transporting Data with Minimum Down Time
13. Transporting a Tablespace by Using Image Copies
14. Determining the Endian Format of a Platform
15. Transporting Data with Backup Sets
16. Transporting a Tablespace
17. Transporting Inconsistent Tablespaces

Using External Tables to Load and Transport Data

1. External Tables
2. External Tables: Benefits
3. ORACLE_LOADER Access Driver
4. ORACLE_DATAPUMP Access Driver
5. External Tables
6. Viewing Information About External Tables
7. Practice Overview

Automated Maintenance Tasks: Overview

1. Proactive Database Maintenance Infrastructure
2. Automated Maintenance Tasks: Components
3. Predefined Automated Maintenance Tasks
4. Maintenance Windows
5. Predefined Maintenance Windows
6. Automated Maintenance Tasks

Automated Maintenance Tasks: Managing Tasks and Windows

1. Configuring Automated Maintenance Tasks
2. Enabling and Disabling Maintenance Tasks
3. Creating and Managing Maintenance Windows
4. Resource Allocations for Automated Maintenance Tasks
5. Changing Resource Allocations for Maintenance Tasks
6. Summary
7. Practice Overview

Database Monitoring and Tuning Performance Overview

1. Objectives
2. Performance Management Activities
3. Performance Planning Considerations
4. Database Maintenance
5. Automatic Workload Repository (AWR)
6. Automatic Database Diagnostic Monitor (ADDM)
7. Configuring Automatic ADDM Analysis at the PDB Level
8. Advisory Framework
9. Performance Tuning Methodology

Monitoring Database Performance

1. Objectives
2. Server-Generated Alerts
3. Setting Metric Thresholds
4. Reacting to Alerts
5. Alert Types and Clearing Alerts
6. Database Server Statistics and Metrics
7. Performance Monitoring
8. Viewing Statistics Information
9. Monitoring Wait Events
10. Monitoring Sessions
11. Monitoring Services

Analyzing SQL and Optimizing Access Paths

1. Objectives
2. SQL Tuning Process
3. Oracle Optimizer
4. Optimizer Statistics
5. Optimizer Statistics Collection
6. Setting Optimizer Statistics Preferences
7. Optimizer Statistics Advisor
8. Optimizer Statistics Advisor Report
9. Executing Optimizer Statistics Advisor Tasks
10. SQL Plan Directives
11. Adaptive Execution Plans
12. SQL Tuning Advisor: Overview
13. SQL Access Advisor: Overview
14. SQL Performance Analyzer: Overview
15. Managing Automated Tuning Tasks