• No products in the cart.

Students

Lectures

436

Course Duration

Unlimited Duration

Updated

October 13, 2022

Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment.
Profile Photo
Annapurna Singh
0
24

Courses

490

Students

A database administrator, or DBA, is responsible for maintaining, securing, and operating databases and also ensures that data is correctly stored and retrieved. In addition, DBAs often work with developers to design and implement new features and troubleshoot any issues.


The following features are new in this release:


Oracle Database supplied user accounts are now schema only accounts


Most of the Oracle Database supplied user accounts, except SYS and sample schemas are now schema only accounts, that is, these accounts are created without passwords. This prevents malicious users from logging into these accounts. You can assign passwords to these accounts whenever you want them to be authenticated. To find the status of an account, query the ACCOUNT_STATUS column of the DBA_USERS data dictionary view. If the account is schema only, then the status is NONE.


1. Dry-run validation of an Oracle Clusterware upgrade.


2. Flashback in Data Guard.


3. DML mode in Data Guard.


4. Network file retention and size limits.


5. Automatic indexing feature.


6. Image-based Oracle client installation.


7. AutoUpgrade for an Oracle database.

    • Objectives Unlimited
    • Oracle Database Server Architecture: Overview Unlimited
    • Oracle Multitenant Container Database: Introduction Unlimited
    • Oracle Multitenant Container Database: Architecture Unlimited
    • Oracle Database Instance Configurations Unlimited
    • Database Sharding: Introduction Unlimited
    • Oracle Database Server: Interactive Architecture Diagram Unlimited
    • Summary Unlimited
    • Module 1. Introduction to Oracle Database Deck Unlimited
    • Objectives Unlimited
    • Connecting to an Oracle Database Instance Unlimited
    • Oracle Database Tools Unlimited
    • Database Tool Choices Unlimited
    • SQL*Plus Unlimited
    • Oracle SQL Developer Unlimited
    • Database Configuration Assistant (DBCA) Unlimited
    • Oracle Enterprise Manager Database Express Unlimited
    • Enterprise Manager Cloud Control 13c Features Unlimited
    • Oracle Enterprise Manager Component Overview Unlimited
    • Single Pane of Glass for Enterprise Management Unlimited
    • Oracle Enterprise Manager Database Management Unlimited
    • Summary Unlimited
    • Module 2. Accessing an Oracle Database Deck Unlimited
    • Objectives Unlimited
    • Planning the Database Unlimited
    • Choosing a Database Template Unlimited
    • Choosing the Appropriate Character Set Unlimited
    • How Are Character Sets Used? Unlimited
    • Setting NLS_LANG Correctly on the Client Unlimited
    • Using the Database Configuration Assistant Unlimited
    • Using DBCA in Silent Mode Unlimited
    • Summary Unlimited
    • Module 3. Creating an Oracle Database by Using DBCA Deck Unlimited
    • Objectives Unlimited
    • Creating a Container Database (CDB) Unlimited
    • Creating a CDB by Using a SQL Command: Example Unlimited
    • Using the SEED FILE_NAME_CONVERT Clause Unlimited
    • Using the ENABLE PLUGGABLE DATABASE Clause Unlimited
    • Summary Unlimited
    • Module 4. Creating an Oracle Database by Using a SQL Command Deck Unlimited
    • Objectives Unlimited
    • Starting the Oracle Database Instance Unlimited
    • Shutting Down an Oracle Database Instance Unlimited
    • Comparing SHUTDOWN Modes Unlimited
    • Opening and Closing PDBs Unlimited
    • Configuring PDBs to Automatically Open Unlimited
    • Summary Unlimited
    • Module 5. Starting Up and Shutting Down a Database Instance Deck Unlimited
    • Objectives Unlimited
    • Working with Initialization Parameters Unlimited
    • Initialization Parameters Unlimited
    • Modifying Initialization Parameters Unlimited
    • Viewing Initialization Parameters Unlimited
    • Working with the Automatic Diagnostic Repository Unlimited
    • Automatic Diagnostic Repository Unlimited
    • Viewing the Alert Log Unlimited
    • Using Trace Files Unlimited
    • Administering the DDL Log File Unlimited
    • Querying Dynamic Performance Views Unlimited
    • Considerations for Dynamic Performance Views Unlimited
    • Data Dictionary: Overview Unlimited
    • Querying the Oracle Data Dictionary Unlimited
    • Summary Unlimited
    • Module 6. Managing Database Instances Deck Unlimited
    • Objectives Unlimited
    • Connecting to the Database Instance Unlimited
    • Oracle Net Services Unlimited
    • Defining Oracle Net Services Components Unlimited
    • Tools for Configuring and Managing Oracle Net Services Unlimited
    • Oracle Net Listener Unlimited
    • The Default Listener Unlimited
    • Comparing Dedicated and Shared Server Architecture Unlimited
    • Summary Unlimited
    • Module 7. Oracle Net Services Deck Unlimited
    • Objectives Unlimited
    • Establishing Oracle Network Connections Unlimited
    • Connecting to an Oracle Database Instance Unlimited
    • Name Resolution Unlimited
    • Establishing a Connection Unlimited
    • User Sessions Unlimited
    • Naming Methods Unlimited
    • Easy Connect Unlimited
    • Local Naming Unlimited
    • Directory Naming Unlimited
    • Using Database Services to Manage Workloads Unlimited
    • Creating Database Services Unlimited
    • Summary Unlimited
    • Module 8. Configuring Naming Methods Deck Unlimited
    • Objectives Unlimited
    • Review: Oracle Net Services Overview Unlimited
    • Oracle Net Listener Unlimited
    • The Default Listener Unlimited
    • Configuring Dynamic Service Registration Unlimited
    • Configuring Static Service Registration Unlimited
    • Summary Unlimited
    • Module 9. Configuring and Administering the Listener Deck Unlimited
    • Objectives Unlimited
    • Shared Server Architecture Unlimited
    • Comparing Dedicated and Shared Server Architecture: Review Unlimited
    • Enabling Shared Server Unlimited
    • Controlling Shared Server Operations Unlimited
    • SGA and PGA Usage Unlimited
    • Shared Server Configuration Considerations Unlimited
    • Summary Unlimited
    • Module 10. Configuring a Shared Server Architecture Deck Unlimited
    • Objectives Unlimited
    • Oracle Connection Manager Unlimited
    • Oracle Connection Manager Processes Unlimited
    • Oracle Connection Manager: Architecture Unlimited
    • Using Filtering Rules Unlimited
    • Implementing Intranet Access Control Unlimited
    • Implementing Internet Access Control Unlimited
    • Using Session Multiplexing Unlimited
    • Configuring Oracle Connection Manager Unlimited
    • Configuring the cman.ora File Unlimited
    • Example of a cman.ora File Unlimited
    • Configuring Clients Unlimited
    • Configuring the Database Server Unlimited
    • Configuring the Database Server for Multiplexing (Optional) Unlimited
    • Using the Oracle Connection Manager Control Utility Unlimited
    • Review of Oracle Connection Manager Features Unlimited
    • Summary Unlimited
    • Module 11. Configuring Oracle Connection Manager for Multiplexing and Access Control Deck Unlimited
    • Objectives Unlimited
    • Provisioning New Pluggable Databases Unlimited
    • Tools Unlimited
    • Creating a New PDB from PDB$SEED Unlimited
    • Using the FILE_NAME_CONVERT Clause Unlimited
    • Using OMF or the PDB_FILE_NAME_CONVERT Parameter Unlimited
    • Summary Unlimited
    • Module 12. Creating PDBs from Seed Deck Unlimited
    • Objectives Unlimited
    • Cloning Regular PDBs Unlimited
    • Migrating Data from a Non-CDB into a CDB Unlimited
    • Plugging a Non-CDB into CDB Using DBMS_PDB Unlimited
    • Replicating a Non-CDB into a CDB by Using GoldenGate Unlimited
    • Cloning a Non-CDB or Remote PDB Unlimited
    • Using DBCA to Clone a Remote PDB Unlimited
    • Plugging an Unplugged Regular PDB into CDB Unlimited
    • Plugging in a PDB Using an Archive File Unlimited
    • Cloning Remote PDBs in Hot Mode Unlimited
    • Near-Zero Downtime PDB Relocation Unlimited
    • Using DBCA to Relocate a Remote PDB Unlimited
    • Proxy PDB Unlimited
    • Creating a Proxy PDB Unlimited
    • Summary Unlimited
    • Module 13. Using Other Techniques to Create PDBs Deck Unlimited
    • Objectives Unlimited
    • Changing the PDB Mode Unlimited
    • Modifying PDB Settings Unlimited
    • Impact of Changing Initialization Parameters Unlimited
    • Changing Initialization Parameters: Example Unlimited
    • Using the ALTER SYSTEM Command in a PDB Unlimited
    • Configuring Host Name and Port Number per PDB Unlimited
    • Dropping PDBs Unlimited
    • Summary Unlimited
    • Module 14. Managing PDBs Deck Unlimited
    • Objectives Unlimited
    • Database Storage Architecture Unlimited
    • Logical and Physical Database Structures Unlimited
    • Segments, Extents, and Blocks Unlimited
    • Tablespaces and Data Files Unlimited
    • Default Tablespaces in a Multitenant Container Database Unlimited
    • SYSTEM and SYSAUX Tablespaces Unlimited
    • Types of Segments Unlimited
    • How Table Data Is Stored Unlimited
    • Database Block Content Unlimited
    • Understanding Deferred Segment Creation Unlimited
    • Controlling Deferred Segment Creation Unlimited
    • Monitoring Tablespace Space Usage Unlimited
    • Oracle Database Storage Structures Unlimited
    • Summary Unlimited
    • Module 15. Database Storage Overview Deck Unlimited
    • Objectives Unlimited
    • Creating Tablespaces Unlimited
    • Creating Permanent Tablespaces in a CDB Unlimited
    • Defining Default Permanent Tablespaces Unlimited
    • Temporary Tablespaces Unlimited
    • Altering and Dropping Tablespaces Unlimited
    • Viewing Tablespace Information Unlimited
    • Implementing Oracle Managed Files (OMF) Unlimited
    • Enlarging the Database Unlimited
    • Moving or Renaming Online Data Files Unlimited
    • Summary Unlimited
    • Module 16. Creating and Managing Tablespaces Deck Unlimited
    • Objectives Unlimited
    • Space Management Features Unlimited
    • Block Space Management Unlimited
    • Row Chaining and Migration Unlimited
    • Free Space Management Within Segments Unlimited
    • Allocating Extents Unlimited
    • Using Unusable Indexes Unlimited
    • Using Temporary Tables Unlimited
    • Creating Global Temporary Tables Unlimited
    • Creating Private Temporary Tables Unlimited
    • Table Compression: Overview Unlimited
    • Compression for Direct-Path Insert Operations Unlimited
    • Advanced Row Compression for DML Operations Unlimited
    • Specifying Table Compression Unlimited
    • Using the Compression Advisor Unlimited
    • Resolving Space Usage Issues Unlimited
    • Reclaiming Space by Shrinking Segments Unlimited
    • Shrinking Segments Unlimited
    • Results of a Shrink Operation Unlimited
    • Managing Resumable Space Allocation Unlimited
    • Using Resumable Space Allocation Unlimited
    • Resuming Suspended Statements Unlimited
    • What Operations Are Resumable? Unlimited
    • Summary Unlimited
    • Module 17. Improving Space Usage Deck Unlimited
    • Objectives Unlimited
    • Undo Data Unlimited
    • Transactions and Undo Data Unlimited
    • Storing Undo Information Unlimited
    • Comparing Undo Data and Redo Data Unlimited
    • Managing Undo Unlimited
    • Comparing SHARED Undo Mode and LOCAL Undo Mode Unlimited
    • Configuring Undo Retention Unlimited
    • Categories of Undo Unlimited
    • Guaranteeing Undo Retention Unlimited
    • Changing an Undo Tablespace to a Fixed Size Unlimited
    • Temporary Undo: Overview Unlimited
    • Temporary Undo Benefits Unlimited
    • Enabling Temporary Undo Unlimited
    • Monitoring Temporary Undo Unlimited
    • Summary Unlimited
    • Module 18. Managing Undo Data Deck Unlimited
    • Objectives Unlimited
    • Database User Accounts Unlimited
    • Oracle-Supplied Administrator Accounts Unlimited
    • Creating Oracle Database Users in a Multitenant Environment Unlimited
    • Creating Common Users in the CDB and PDBs Unlimited
    • Creating Schema Only Accounts Unlimited
    • Authenticating Users Unlimited
    • Using Password Authentication Unlimited
    • Using Password File Authentication Unlimited
    • Using OS Authentication Unlimited
    • OS Authentication for Privileged Users Unlimited
    • Assigning Quotas Unlimited
    • Summary Unlimited
    • Module 19. Creating and Managing User Accounts Deck Unlimited
    • Objectives Unlimited
    • Privileges Unlimited
    • System Privileges Unlimited
    • System Privileges for Administrators Unlimited
    • Object Privileges Unlimited
    • Granting Privileges in a Multitenant Environment Unlimited
    • Granting Privileges: Example Unlimited
    • Using Roles to Manage Privileges Unlimited
    • Assigning Privileges to Roles and Assigning Roles to Users Unlimited
    • Oracle-Supplied Roles Unlimited
    • Granting Roles in a Multitenant Environment Unlimited
    • Granting Roles: Example Unlimited
    • Making Roles More Secure Unlimited
    • Revoking Roles and Privileges Unlimited
    • Granting and Revoking System Privileges Unlimited
    • Granting and Revoking Object Privileges Unlimited
    • Summary Unlimited
    • Module 20. Configuring Privilege and Role Authorization Deck Unlimited
    • Objectives Unlimited
    • Profiles and Users Unlimited
    • Creating Profiles in a Multitenant Architecture Unlimited
    • Creating Profiles: Example Unlimited
    • Profile Parameters: Resources Unlimited
    • Profile Parameters: Locking and Passwords Unlimited
    • Oracle-Supplied Password Verification Functions Unlimited
    • Assigning Profiles in a Multitenant Architecture Unlimited
    • Summary Unlimited
    • Module 21. Configuring User Resource Limits Deck Unlimited
    • Objectives Unlimited
    • Database Security Unlimited
    • Monitoring for Compliance Unlimited
    • Types of Activities to be Audited Unlimited
    • Mandatorily Audited Activities Unlimited
    • Understanding Auditing Implementation Unlimited
    • Administering the Roles Required for Auditing Unlimited
    • Database Auditing: Overview Unlimited
    • Configuring Auditing Unlimited
    • Creating a Unified Audit Policy Unlimited
    • Creating an Audit Policy Unlimited
    • Enabling and Disabling Audit Policies Unlimited
    • Auditing Actions in the CDB and PDBs Unlimited
    • Modifying a Unified Audit Policy Unlimited
    • Auditing Top-Level Statements Only Unlimited
    • Viewing Audit Policy Information Unlimited
    • Value-Based Auditing Unlimited
    • Fine-Grained Auditing Unlimited
    • FGA Policy Unlimited
    • Audited DML Statement: Considerations Unlimited
    • FGA Guidelines Unlimited
    • Archiving and Purging the Audit Trail Unlimited
    • Purging Audit Trail Records Unlimited
    • Summary Unlimited
    • Module 22. Implementing Oracle Database Auditing Deck Unlimited
    • Objectives Unlimited
    • Moving Data: General Architecture Unlimited
    • Oracle Data Pump: Overview Unlimited
    • Oracle Data Pump: Benefits Unlimited
    • SQL Loader: Overview Unlimited
    • Summary Unlimited
    • Module 23. Introduction to Loading and Transporting Data Deck Unlimited
    • Objectives Unlimited
    • SQL Loader: Review Unlimited
    • Creating the SQL*Loader Control File Unlimited
    • SQL*Loader Loading Methods Unlimited
    • Protecting Against Data Loss Unlimited
    • SQL*Loader Express Mode Unlimited
    • Using SQL*Loader to Load a Table in a PDB Unlimited
    • Summary Unlimited
    • Module 24. Loading Data Deck Unlimited
    • Objectives Unlimited
    • Data Pump Export and Import Clients Unlimited
    • Data Pump Interfaces and Modes Unlimited
    • Data Pump Import Transformations Unlimited
    • Using Oracle Data Pump with PDBs Unlimited
    • Exporting from a Non-CDB and Importing into a PDB Unlimited
    • Exporting and Importing Between PDBs Unlimited
    • Full Transportable Export/Import Unlimited
    • Transporting a Database Over the Network: Example Unlimited
    • Using RMAN to Transport Data Across Platforms Unlimited
    • RMAN CONVERT Command Unlimited
    • Transporting Data with Minimum Down Time Unlimited
    • Transporting a Tablespace by Using Image Copies Unlimited
    • Determining the Endian Format of a Platform Unlimited
    • Transporting Data with Backup Sets Unlimited
    • Transporting a Tablespace Unlimited
    • Transporting Inconsistent Tablespaces Unlimited
    • Database Transport: Data Files Unlimited
    • Transporting a Database Unlimited
    • Transporting a Database with Backup Sets Unlimited
    • Summary Unlimited
    • Module 25. Transporting Data Deck Unlimited
    • Objectives Unlimited
    • External Tables Unlimited
    • ORACLE_LOADER Access Driver Unlimited
    • ORACLE_DATAPUMP Access Driver Unlimited
    • External Tables Unlimited
    • Viewing Information About External Tables Unlimited
    • Summary Unlimited
    • Module 26. Using External Tables to Load and Transport Data Deck Unlimited
    • Objectives Unlimited
    • Proactive Database Maintenance Infrastructure Unlimited
    • Automated Maintenance Tasks: Components Unlimited
    • Predefined Automated Maintenance Tasks Unlimited
    • Maintenance Windows Unlimited
    • Predefined Maintenance Windows Unlimited
    • Viewing Maintenance Window Details Unlimited
    • Automated Maintenance Tasks Unlimited
    • Summary Unlimited
    • Module 27. Automated Maintenance Tasks: Overview Deck Unlimited
    • Objectives Unlimited
    • Configuring Automated Maintenance Tasks Unlimited
    • Enabling and Disabling Maintenance Tasks Unlimited
    • Creating and Managing Maintenance Windows Unlimited
    • Resource Allocations for Automated Maintenance Tasks Unlimited
    • Changing Resource Allocations for Maintenance Tasks Unlimited
    • Summary Unlimited
    • Module 28. Automated Maintenance Tasks: Managing Tasks and Windows Deck Unlimited
    • Objectives Unlimited
    • Performance Management Activities Unlimited
    • Performance Planning Considerations Unlimited
    • Database Maintenance Unlimited
    • Automatic Workload Repository (AWR) Unlimited
    • Automatic Database Diagnostic Monitor (ADDM) Unlimited
    • Configuring Automatic ADDM Analysis at the PDB Level Unlimited
    • Advisory Framework Unlimited
    • Performance Tuning Methodology Unlimited
    • Summary Unlimited
    • Module 29. Database Monitoring and Tuning Performance Overview Deck Unlimited
    • Objectives Unlimited
    • Server-Generated Alerts Unlimited
    • Setting Metric Thresholds Unlimited
    • Reacting to Alerts Unlimited
    • Alert Types and Clearing Alerts Unlimited
    • Database Server Statistics and Metrics Unlimited
    • Performance Monitoring Unlimited
    • Viewing Statistics Information Unlimited
    • Monitoring Wait Events Unlimited
    • Monitoring Sessions Unlimited
    • Monitoring Services Unlimited
    • Summary Unlimited
    • Module 30. Monitoring Database Performance Deck Unlimited
    • Objectives Unlimited
    • Process Architecture Unlimited
    • Process Structures Unlimited
    • Database Writer Process (DBWn & BWnn) Unlimited
    • Log Writer Process (LGWR & LGnn) Unlimited
    • Checkpoint Process (CKPT) Unlimited
    • System Monitor Process (SMON) Unlimited
    • Process Monitor Process (PMON) Unlimited
    • Process Manager (PMAN) Unlimited
    • Recoverer Process (RECO) Unlimited
    • Listener Registration Process (LREG) Unlimited
    • Manageability Monitor Process (MMON) Unlimited
    • Archiver Processes (ARCn) Unlimited
    • Interacting with an Oracle Database: Memory, Processes, and Storage Unlimited
    • Summary Unlimited
    • Module 31. Database Processes Deck Unlimited
    • Objectives Unlimited
    • Managing Memory Components Unlimited
    • Shared Pool Unlimited
    • Database Buffer Cache Unlimited
    • Redo Log Buffer Unlimited
    • Large Pool Unlimited
    • Java Pool Unlimited
    • Streams Pool Unlimited
    • Program Global Area (PGA) Unlimited
    • Managing Memory Components Unlimited
    • Efficient Memory Usage: Guidelines Unlimited
    • Automatic Memory Management Unlimited
    • Monitoring Automatic Memory Management Unlimited
    • Automatic Shared Memory Management Unlimited
    • Understanding Automatic Shared Memory Management Unlimited
    • Oracle Database Memory Parameters Unlimited
    • Managing the SGA for PDBs Unlimited
    • Managing the Program Global Area (PGA) Unlimited
    • Managing the PGA for PDBs Unlimited
    • Summary Unlimited
    • Module 32. Managing Memory Deck Unlimited
    • Objectives Unlimited
    • SQL Tuning Process Unlimited
    • Oracle Optimizer Unlimited
    • Optimizer Statistics Unlimited
    • Optimizer Statistics Collection Unlimited
    • Setting Optimizer Statistics Preferences Unlimited
    • Optimizer Statistics Advisor Unlimited
    • Optimizer Statistics Advisor Report Unlimited
    • Executing Optimizer Statistics Advisor Tasks Unlimited
    • SQL Plan Directives Unlimited
    • Adaptive Execution Plans Unlimited
    • SQL Tuning Advisor: Overview Unlimited
    • SQL Access Advisor: Overview Unlimited
    • SQL Performance Analyzer: Overview Unlimited
    • Managing Automated Tuning Tasks Unlimited
    • Summary Unlimited
    • Module 33. Analyzing SQL and Optimizing Access Paths Deck Unlimited

Popular Courses

top
Managed by Ernesto.net © 2021. All rights reserved.