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.
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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
