Understanding Oracle Database Architecture - Oracle Database: Administration Workshop
Understanding Oracle Database Instance Configurations
Understanding Oracle Database Memory and Process Structures
Understanding Logical and Physical Database Structures
Understanding Oracle Database Server Architecture
Accessing an Oracle Database with Oracle supplied Tools - Oracle Database: Administration Workshop
Using the Database Configuration Assistant (DBCA)
Using Oracle Enterprise Manager Cloud Control
Using racle enterprise Manager Database Express
Using SQL Developer
Using SQL Plus
Managing Database Instances - Oracle Database: Administration Workshop
IStarting Up Oracle Database Instances
Using Data Dictionary Views
Shutting Down Oracle Database Instances
Using Dynamic Performance Views
Using the Automatic Diagnostic Repository (ADR)
Using the Alert Log and Trace Files
Managing Initialization Parameter Files
Managing Tablespaces and Datafiles - Oracle Database: Administration Workshop
Viewing Tablespace Information
Creating, Altering and Dropping Tablespaces
Managing Table Data Storage
Implementing Oracle Managed Files
Moving and Renaming Online Data Files
Moving Data - Oracle Database: Administration Workshop
Using External Tables
Using Oracle Data Pump
Using SQL*Loader
Managing Undo - Oracle Database: Administration Workshop
Understanding Transactions and Undo Data
Storing Undo Information
Configuring Undo Rentention
Comparing Undo Data and Redo Data
Understanding Temporary Undo
Configuring Oracle Net Services - Oracle Database: Administration Workshop
Using Oracle Net Services Administration Tools
Configuring Communication Between Database Instances
Configuring the Oracle Net Listener
Connecting to an Oracle Database Instance
Comparing Dedicated and Shared Server Configurations
Administering Naming Methods
Managing Users, Roles and Privileges - Oracle Database: Administration Workshop
Assigning Quotas to Users
Applying the Principal of Least Privilege
Creating and Assigning Profiles
Administering User Authentication Methods
Managing Oracle Database Users, Privileges, and Roles
Managing Storage - Oracle Database: Administration Workshop
Managing Resumable Space Allocation
Shrinking Segments
Deferring Segment Creation
Using Space-Saving Features
Deploying Oracle Database Space Management Features
Managing Different Types of Segments
Using Table and Row Compression
Understanding Block Space Management
Using Real Application Testing
Using SQL Performance Analyzer to test the impact of database changes
Use Database Replay to check impact of system change on performance
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
