1 – INTRODUCTION: MANAGING THE DATABASE INSTANCE
- The Database Management Tools
- EM Database Express
- EM Cloud Control
- SQL Developer
- Database Administrator
2 – INTRODUCTION: DATABASE ARCHITECTURE REVIEW
- Database Instance Configurations
- Memory Structures
- Process Structures
- Storage Architecture
3 – INTRODUCTION: STARTING & STOPPING DATABSE SERVICES
- Start & Stop the Database Listener
- ABOUT DATABASE STARTUP/SHUTDOWN
- SYSOPER
- SYSDBA
- DATABASE STATE & STAGES
- STARTUP WITH EM CLOUD CONTROL
- STARTUP WITH SQL*PLUS
- SHUTDOWN WITH EM CLOUD CONTROL
- SHUTDOWN WITH SQL*PLUS
- USING MS WINDOWS SERVICES
4 – INTRODUCTION: ORACLE NETWORK ENVIRONMENT
- Oracle Net Services Architecture
- ORACLE NET CONFIGURATION ASSISTANT
- ORACLE NET MANAGER
- USING EM CLOUD CONTROL
- ADVANCED NETWORK COMPRESSION
- TROUBLESHOOTING NETWORK PROBLEMS
5 – INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT
- About Database Diagnostics
- Fault Diagnosability Infrastructure
- DATABASE INSTANCE HEALTH SNAPSHOT
- THE SUPPORT WORKBENCH
- PROACTIVE DATABASE HEALTH CHECKS
- PACKAGE DIAGNOSTIC DATA
- WORKING WITH THE KNOWLEDGE BASE
6 – STORAGE: TABLESPACE MANAGEMENT
- Starter Tablespaces
- CREATE TABLESPACE WITH EM CC
- CREATE TABLESPACE WITH SQL
- MANAGE TABLESPACES WITH EM CC
- MANAGE TABLESPACES WITH EM DE
- MANAGE TABLESPACES WITH SQL
- DROP TABLESPACE
- ALTER TABLESPACE
7 – STORAGE: ADVANCED TABLESPACE MANAGEMENT
- Managing Temporary Tablespaces
- TEMP TABLESPACE GROUPS WITH EM
- TEMP TABLESPACE GROUPS WITH SQL
- DEFAULT PERMANENT TABLESPACES
- BIGFILE TABLESPACES
- MANAGING THE SYSAUX TABLESPACE
8 – STORAGE: DATA FILES & TEMP FILES MANAGEMENT
- Manage Data Files with EM
- ACCESS METADATA WITH SQL
- MANAGE DATA FILES WITH SQL
- MANAGE TEMP FILES
- ORACLE-MANAGED FILES (OMF)
9 – STORAGE: UNDO DATA & UNDO TABLESPACES
- About UNDO Space Management
- GUARANTEE UNDO RETENTION
- MONITOR UNDO SPACE WITH SQL
- USE THE EM UNDO ADVISOR
10 – SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES
- Database Security Principles
- DATABASE SYSTEM PRIVILEGES
- DATABASE OBJECT PRIVILEGES
- SUPER ADMINISTRATOR ROLES
- PRIVILEGE ANALYSIS
11 – SECURITY & SCHEMAS: USER SECURITY
- Create & Manage User Accounts
- MANAGE USERS WITH EM
- MANAGE USERS WITH SQL
- CREATE USER
- ALTER USER
- DROP USER
- GRANT & REVOKE PRIVILEGES
- RESOURCE LIMITS VIA PROFILES
- ALTER PROFILE
- DROP PROFILE
- PASSWORD MANAGEMENT VIA PROFILES
- ROLE-BASED SECURITY MANAGEMENT
- ALTER USER…DEFAULT ROLE
- SET ROLE
- DELEGATING PRIVILEGE AUTHORIZATION
- WITH ADMIN OPTION & System Privileges
- WITH GRANT OPTION & Object Privileges
- PRINCIPLE OF LEAST PRIVILEGE CHECKLIST
12 – SECURITY & SCHEMAS: DATABASE AUDITING
- Auditing Database Activity
- Traditional Auditing
- Unified Auditing
- Create Audit Policy
13 – SECURITY & SCHEMAS: SQL LOADER
- Loader Concepts
- Loader From the Command Line
- control File Options
- Load Methods
- Loader Express Mode
- Loader From EM
14 – SECURITY & SCHEMAS: EXPORT & IMPORT
- Manage Directory Objects
- The Data Pump Architecture
- Data Pump Export
- Data Pump Import
- Data Pump Dictionary Views
- Using the EM CC Interface
15 – PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING
- Management Advisory Framework
- Performance Monitoring & AWR
- The SQL Tuning Advisor
- Monitoring Exceptions with Metrics
16 – PERFORMANCE & AVAILABILITY: DATA CONCURRENCY
- About System & User Locks
- Monitor & Manage User Locks
- Monitor Locks with Data Dictionary
- Manage Locks with EM
17 – PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS
- Backup & Recovery Structures
- Managing REDO Data
- Configuring for Recoverability
- Instance Recovery
- Recoverability Checklist