Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database 2 Day DBA
- 1 Introduction
-
2
Installing Oracle Database and Creating a Database
-
2.1
Overview of Installing Oracle Database Software and Creating a Database
- 2.1.1 Checking Oracle Database Installation Prerequisites
-
2.1.2
Deciding on Oracle Database Installation Choices
- 2.1.2.1 Install Option for Oracle Database
- 2.1.2.2 Installation Class for Oracle Database
- 2.1.2.3 Installation Edition for Oracle Database
- 2.1.2.4 Software Installation Directories for Oracle Database
- 2.1.2.5 Database File Location for Oracle Database
- 2.1.2.6 Database Identifiers for Oracle Database
- 2.1.2.7 About Advanced Installation for Oracle Database
- 2.2 Installing Oracle Database Software
-
2.3
Creating and Managing a Database with DBCA
- 2.3.1 Starting DBCA
-
2.3.2
Creating a Database Using DBCA
- 2.3.2.1 DBCA Creation Mode Window
- 2.3.2.2 DBCA Deployment Type Window
- 2.3.2.3 DBCA Database Identification Window
- 2.3.2.4 DBCA Storage Option Window
- 2.3.2.5 DBCA Fast Recovery Option Window
- 2.3.2.6 DBCA Network Configuration Window
- 2.3.2.7 DBCA Database Vault Option Window
- 2.3.2.8 DBCA Configuration Options Window
- 2.3.2.9 DBCA Management Options Window
- 2.3.2.10 DBCA User Credentials Window
- 2.3.2.11 DBCA Creation Option Window
- 2.3.2.12 DBCA Summary Window
- 2.3.2.13 DBCA Progress Window
- 2.3.2.14 DBCA Finish Window
- 2.3.3 Changing the Configuration of a Database Using DBCA
- 2.3.4 Deleting a Database Using DBCA
- 2.3.5 Managing Templates with DBCA
- 2.3.6 Using DBCA to Manage PDBs
- 2.4 Manually Installing the Database Sample Schemas Post-Installation
- 2.5 Installation: Oracle By Example Series
-
2.1
Overview of Installing Oracle Database Software and Creating a Database
-
3
Getting Started with Database Administration
- 3.1 Managing Your Database: An Overview
- 3.2 Configuring the Operating System Environment Variables
- 3.3 Introduction to Oracle Enterprise Manager Database Express
- 3.4 Starting EM Express
- 3.5 Configuring the HTTPS Port for EM Express
- 3.6 About EM Express and Database Cloud Service Deployments
- 3.7 Accessing the Database Home Page
- 3.8 Granting Access to EM Express for Nonadministrative Users
- 3.9 Administering the Database with SQL-Based Management Tools
- 3.10 Getting Started with Database Administration: Oracle by Example Series
- 4 Configuring the Network Environment
-
5
Managing the Oracle Instance
- 5.1 Overview of the Oracle Instance and Instance Management
- 5.2 Shutting Down and Starting Up the Oracle Instance
- 5.3 Viewing and Modifying Initialization Parameters
-
5.4
Managing Memory
- 5.4.1 About Memory Management
- 5.4.2 Enabling Automatic Memory Management
- 5.4.3 Modifying Memory Settings – Automatic Memory Management
- 5.4.4 Enabling Automatic Shared Memory Management
- 5.4.5 Modifying Memory Settings – Automatic Shared Memory Management
- 5.4.6 Enabling Manual Shared Memory Management
- 5.4.7 Modifying Memory Settings - Manual Shared Memory Management
- 5.4.8 Modifying Memory Settings – Automatic PGA Memory Management
- 5.5 Managing the Oracle Instance: Oracle By Example Series
-
6
Managing Database Storage Structures
- 6.1 About Database Storage Structures
- 6.2 Viewing Database Storage Structure Information
- 6.3 Performing Common Database Storage Tasks
- 6.4 Managing the Online Redo Log
-
6.5
Managing Undo Data
- 6.5.1 About Undo Data
- 6.5.2 About Managing Undo Data
- 6.5.3 Viewing Undo Information
- 6.5.4 Computing the Minimum Undo Tablespace Size Using the Undo Advisor
- 6.5.5 Changing the Undo Tablespace to a Fixed Size
- 6.5.6 Changing the Datafiles for an Undo Tablespace to a Fixed Size
- 6.5.7 Changing Undo Management Analysis Parameters
- 6.5.8 Switching Undo Tablespaces
- 6.6 Managing Database Storage Structures: Oracle by Example Series
-
7
Administering User Accounts and Security
- 7.1 About User Accounts
- 7.2 About User Privileges and Roles
- 7.3 About Administrative Accounts and Privileges
- 7.4 Administering Roles
-
7.5
Administering Database User Accounts
- 7.5.1 Viewing User Accounts
- 7.5.2 Example: Creating a User Account
- 7.5.3 Creating a New User Account by Duplicating an Existing User Account
- 7.5.4 Example: Granting Privileges and Roles to a User Account
- 7.5.5 Example: Assigning a Tablespace Quota to a User Account
- 7.5.6 Example: Modifying a User Account
- 7.5.7 Locking and Unlocking User Accounts
- 7.5.8 Expiring a User Password
- 7.5.9 Example: Deleting a User Account
- 7.6 Setting the Database Password Policy
- 7.7 Administering User Accounts and Security: Oracle by Example Series
-
8
Managing Schema Objects
- 8.1 About Schema Objects
- 8.2 About Schema Object Management Privileges
- 8.3 About SQL Developer
-
8.4
Managing Tables
- 8.4.1 About Tables
- 8.4.2 Viewing Tables
- 8.4.3 Viewing Table Data
- 8.4.4 Example: Creating a Table
- 8.4.5 Modifying Table Attributes
- 8.4.6 Example: Loading Data into a Table
- 8.4.7 Deleting a Table
- 8.5 Managing Indexes
- 8.6 Managing Views
- 8.7 Managing Program Code Stored in the Database
- 8.8 Working with Other Schema Objects
- 8.9 Managing Schema Objects: Oracle by Example Series
-
9
Performing Backup and Recovery
- 9.1 Overview of Database Backup and Recovery
- 9.2 Database Backup and Recovery Concepts
- 9.3 Configuring Your Database for Basic Backup and Recovery
-
9.4
Backing Up Your Database
- 9.4.1 Additional Backup Concepts
- 9.4.2 Performing and Scheduling Backups Using RMAN
- 9.4.3 Displaying Backups Stored in the RMAN Repository
- 9.4.4 Validating Backups and Testing Your Backup Strategy
- 9.5 Displaying Backup Reports
- 9.6 Managing Backups
- 9.7 Performing Oracle Advised Recovery
- 9.8 Performing User-Directed Recovery
- 9.9 Performing Backup and Recovery: Oracle By Example Series
-
10
Monitoring and Tuning the Database
- 10.1 Proactive Database Monitoring
- 10.2 Diagnosing Performance Problems Using ADDM
-
10.3
Using Advisors to Optimize Database Performance
- 10.3.1 About Advisors
- 10.3.2 About the SQL Tuning Advisor
- 10.3.3 About the Automatic SQL Tuning Advisor
- 10.3.4 Configuring the Automatic SQL Tuning Advisor
- 10.3.5 Viewing Automatic SQL Tuning Results
- 10.3.6 Running the SQL Tuning Advisor
- 10.3.7 About Tuning SQL Statements on a Standby Database
- 10.3.8 Optimizing Memory Usage with the Memory Advisors
- 10.4 Monitoring and Tuning the Database: Oracle by Example Series
-
11
Analyzing the Impact of Database Changes on SQL Performance
- 11.1 About SPA Quick Check
- 11.2 About Configuring SPA Quick Check
- 11.3 About Validating the Impact of an Initialization Parameter Change
- 11.4 About Validating the Impact of Implementing a SQL Profile
- 11.5 About SQL Performance Analyzer
- 11.6 Specifying Default Settings for SQL Performance Analyzer
- 11.7 Analyzing the Impact of Database Changes on SQL Performance: Oracle by Example Series
-
12
Managing Database Resources
- 12.1 About Resource Management
-
12.2
Managing Plans
- 12.2.1 Creating Plans
- 12.2.2 Viewing Plans
-
12.2.3
Modifying a Plan
- 12.2.3.1 Adding a New Consumer Group to a Plan
- 12.2.3.2 Adding an Existing Consumer Group to a Plan
- 12.2.3.3 Removing a Consumer Group from a Plan
- 12.2.3.4 Setting a Comment for a Consumer Group in a Plan
- 12.2.3.5 Setting Mapping Rules for a Consumer Group
- 12.2.3.6 Setting Mapping Rule Priorities for Consumer Groups
- 12.2.3.7 Setting CPU Directives for a Consumer Group in a Plan
- 12.2.3.8 Setting Parallel Server Directives for a Consumer Group in a Plan
- 12.2.3.9 Setting Runaway Query Directives for a Consumer Group in a Plan
- 12.2.3.10 Setting Session Directives for a Consumer Group in a Plan
- 12.2.3.11 Setting a Plan as the Currently Active Plan
- 12.2.3.12 Changing the Default PDB Directive for a CDB Plan
- 12.2.3.13 Changing Directives for a PDB in a CDB Plan
- 12.2.3.14 Setting a Comment for a PDB Directive in a CDB Plan
- 12.2.3.15 Deleting a Plan
- 12.3 Managing Multiple Database Instances on a Single Server
- 12.4 Managing Database Resources: Oracle by Example Series
-
13
Managing PDBs with EM Express
- 13.1 Getting Started With Managing PDBs Using EM Express
- 13.2 Overview of CDBs and PDBs
- 13.3 About PDBs That Can be Managed in EM Express
- 13.4 Accessing the Containers Page for a CDB
- 13.5 Accessing the Containers Page for an Application Root
- 13.6 Setting Storage Limits for a PDB Using EM Express
- 13.7 Configuring Oracle Managed Files for a CDB Using EM Express
- 13.8 Provisioning a PDB Using EM Express
- 13.9 Removing PDBs Using EM Express
- 13.10 Opening PDBs Using EM Express
- 13.11 Closing PDBs Using EM Express
- 13.12 Managing PDBs with EM Express: Oracle by Example Series
- 14 Managing Oracle Database Software
- Index