Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
About the Authors
About the Technical Editor
Title Page
Copyright Page
Contents at a Glance
Contents
Preface
Introduction
1. Installing Oracle Database Software
Plan for an Oracle Database Software Installation
Supported Platforms
Obtain the Oracle Database Software
User Accounts
Disk Space and Directories
The Prerequisite Checks
Install the Oracle Database Software
The OUI Inventory
The OUI Dialog: Interactive Install
Silent Install and Response Files
Windows and Linux Variations
Exercise 1-1: Install the Oracle Database Software
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
2. Creating an Oracle Database Using DBCA
Create a Database by Using the Database Configuration Assistant (DBCA)
The Instance, the Database, and the Data Dictionary
Using the DBCA to Create a Database
The DBCA Dialog
Exercise 2-1: Create a Database with DBCA
Generate Database Creation Scripts by Using DBCA
Generating the Scripts
The Creation Scripts
The Initialization Parameter File
Exercise 2-2: Generate Database Creation Scripts by Using DBCA
Manage Database Design Templates by Using DBCA
Exercise 2-3: Manage Database Design Templates by Using DBCA
Configure Database Options by Using DBCA
Exercise 2-4: Configure Database Options by Using DBCA
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
3. Exploring the Oracle Database Architecture
List the Architectural Components of an Oracle Database
Single-Instance Database Architecture
Distributed Systems Architectures
Exercise 3-1: Identify the Components of the Database Server
Explain the Memory Structures
The Database Buffer Cache
The Log Buffer
The Shared Pool
The Large Pool
The Java Pool
The Streams Pool
Exercise 3-2: Investigate the Memory Structures of the Instance
Describe the Background Processes
SMON, the System Monitor
PMON, the Process Monitor
DBWn, the Database Writer
LGWR, the Log Writer
CKPT, the Checkpoint Process
MMON, the Manageability Monitor
MMNL, the Manageability Monitor Light
MMAN, the Memory Manager
LREG, the Listener Registration Process
ARCn, the Archiver
RECO, the Recoverer Process
Some Other Background Processes
Exercise 3-3: Investigate the Processes Running in Your Instance
Explain the Relationship Between Logical and Physical Storage Structures
The Physical Database Structures
The Logical Database Structures
The Data Dictionary
Exercise 3-4: Investigate the Storage Structures in Your Database
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
4. Managing the Database Instance
Use Database Management Tools
Working with SQL*Plus
Log On as a Normal or Privileged User
Working with Database Express
Working with SQL Developer
Exercise 4-1: Use Database Management Tools
Understand Initialization Parameter Files
Static and Dynamic Parameter Files
Static and Dynamic Parameters and the Initialization Parameter File
The Basic Parameters
Changing Parameters
Exercise 4-2: Query and Set Initialization Parameters
Start Up and Shut Down an Oracle Database Instance
Starting the Database Listener
Database Startup and Shutdown
Exercise 4-3: Start Up and Shut Down an Oracle Database Instance
View the Alert Log and Access Dynamic Performance Views
The Alert Log
The DDL Log
The Dynamic Performance Views
Exercise 4-4: Use the Alert Log and Dynamic Performance Views
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
5. Configuring the Oracle Network Environment
Configure Oracle Net Services
Oracle Net and the Client-Server Paradigm
Establishing a Session
Creating a Database Listener
Dynamic Service Registration
Shared Server
Use Tools for Configuring and Managing the Oracle Network
The Net Manager
The Net Configuration Assistant
The Listener Control Utility
The TNS_ADMIN Environment Variable
Configure Client-Side Network
Easy Connect Name Resolution
Local Naming Name Resolution
Directory Naming and External Naming
Testing Oracle Net Connectivity
Exercise 5-1: Configure Oracle Net
Understand Database Resident Connection Pooling
Configure Communication Between Databases
Exercise 5-2: Create and Use a Database Link
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
6. Managing Database Storage Structures
Describe the Storage of Table Row Data in Blocks
The Oracle Data Storage Model
Segments, Extents, Blocks, and Rows
Exercise 6-1: Investigate Storage Structures
Create and Manage Tablespaces
Tablespace Creation
Exercise 6-2: Create, Alter, and Drop Tablespaces
Altering Tablespaces
Dropping Tablespaces
Extent Management
Segment Space Management
Oracle Managed Files (OMF)
Exercise 6-3: Change Tablespace Characteristics
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
7. Managing Space
Explain How Oracle Database Server Automatically Manages Space
Extent Management
Exercise 7-1: Segment Space Management
Automatic Segment Space Management (ASSM)
Save Space by Using Compression
Exercise 7-2: Investigate Compression
Proactively Monitor and Manage Tablespace Space Usage
Use the Segment Advisor
Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
Manage Resumable Space Allocation
Exercise 7-3: Use Resumable Space Allocation
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
8. Administering User Security
Create and Manage Database User Accounts
User Account Attributes
Authentication Methods
Creating Accounts
Exercise 8-1: Create Users
Grant and Revoke Privileges
System Privileges
Object Privileges
Exercise 8-2: Grant Direct Privileges
Create and Manage Roles
Creating and Granting Roles
Predefined Roles
Enabling Roles
Privilege Analysis
Exercise 8-3: Create and Grant Roles
Create and Manage Profiles
Password Profile Limits
Creating and Assigning Profiles
Exercise 8-4: Create and Use Profiles
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
9. Managing Undo Data
Explain DML and Undo Data Generation
Database Transactions
Undo Generation
Executing SQL Statements
How Transactions Use Undo Segments
Exercise 9-1: Use Undo Data
Monitor and Administer Undo Data
Error Conditions Related to Undo
Parameters for Undo Management
Sizing and Monitoring the Undo Tablespace
Temporary Undo
Creating and Managing Undo Tablespaces
Exercise 9-2: Work with Undo Tablespaces
Describe the Difference Between Undo Data and Redo Data
Configure Undo Retention
Configuring Undo Retention to Support Long-Running Queries
Flashback Query and Undo Retention
Exercise 9-3: Work with Transactions and Flashback Query
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
10. Managing Data Concurrency
Describe the Locking Mechanism and How Oracle Manages Data Concurrency
Shared and Exclusive Locks
The Enqueue Mechanism
Automatic and Manual Locking
Monitor and Resolve Locking Conflicts
The Causes of Lock Contention
Detecting Lock Contention
Solving Lock Contention
Deadlocks: A Special Case
Exercise 10-1: Monitor and Resolve Locking Conflicts
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
11. Implementing Oracle Database Auditing
Explain DBA Responsibilities for Security and Auditing
Reasons for Audit
Auditing Techniques
Enable Standard Database Auditing and Unified Auditing
Enable Standard Auditing
Enable Unified Auditing
Exercise 11-1: Use Unified Auditing
Two-Minute Drill
Q&A Self Test
Self Test Answers
12. Performing Database Maintenance
Manage the Automatic Workload Repository (AWR)
Gathering AWR Statistics
Managing the AWR
Exercise 12-1: Monitor the Automatic Workload Repository
Use the Automatic Database Diagnostic Monitor (ADDM)
Exercise 12-2: Generate an ADDM Report
Describe and Use the Advisory Framework
The Memory Advisors
The SQL Advisors
The Automatic Undo Advisor
The Mean Time to Recover (MTTR) Advisor
The Data Recovery Advisor
The Segment Advisor
The SQL Repair Advisor
Set Alert Thresholds
Alert Condition Monitoring and Notifications
Setting Thresholds
Exercise 12-3: Configure Alerts
Use Automated Tasks
The Autotasks
Controlling the Autotasks
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
13. Managing Performance
Use Enterprise Manager to Monitor Performance
A Performance Tuning Methodology
Performance Monitoring Data
The Database Express Performance Pages
Exercise 13-1: Use Enterprise Manager to Monitor Activity
Use Automatic Memory Management
PGA Memory Management
SGA Memory Management
Automatic Memory Management
Exercise 13-2: Set the Memory Management Parameters
Use the Memory Advisor to Size Memory Buffers
Exercise 13-3: Use the Memory Advisors
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
14. Managing Performance: SQL Tuning
Manage Optimizer Statistics
Object Statistics
How the Optimizer Uses Statistics
Gathering Statistics Manually
Exercise 14-1: Gather Optimizer Statistics
Use the SQL Tuning Advisor
The Capabilities of the SQL Tuning Advisor
The SQL Tuning Advisor API: The DBMS_SQLTUNE Package
Exercise 14-2: Run the SQL Tuning Advisor for a SQL Statement
Use the SQL Access Advisor to Tune Workload
The Capabilities of the SQL Access Advisor
Using the SQL Access Advisor with DBMS_ADVISOR
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
15. Managing Resources Using Database Resource Manager
Configure the Database Resource Manager
The Need for Resource Management
The Resource Manager Architecture
Resource Manager Configuration
Access and Create Resource Plans
CPU Method
Use of the Ratio CPU Method
The Active Session Pool Method
Limiting the Degree of Parallelism
Controlling Jobs by Execution Time
Terminating Sessions by Idle Time
Restricting Generation of Undo Data
Exercise 15-1: Create and Implement a Resource Manager Plan
Monitor the Resource Manager
Exercise 15-2: Test and Monitor a Resource Manager Plan
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
16. Automating Tasks by Using Oracle Scheduler
Use Oracle Scheduler to Simplify Management Tasks
The Scheduler Architecture
Scheduler Objects
Exercise 16-1: Creating a Job with the Scheduler API
Use Job Chains to Perform a Series of Related Tasks
Use Scheduler Jobs on Remote Systems
Use Advanced Scheduler Features to Prioritize Jobs
Using Job Classes
Using Windows
Exercise 16-2: Use Scheduler Windows to Control the Resource Manager
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
17. Moving Data
Describe Ways to Move Data
Create and Use Directory Objects
Use SQL*Loader to Load Data from a Non-Oracle Database
Using SQL*Loader
SQL*Loader Express Mode
Use External Tables to Move Data via Platform-Independent Files
Exercise 17-1: Use Directories, SQL*Loader, and External Tables
Explain the General Architecture of Oracle Data Pump
Use Data Pump Export and Import to Move Data between Oracle Databases
Capabilities
Using Data Pump with the Command-Line Utilities
Tablespace Export and Import
Exercise 17-2: Use Data Pump Export/Import
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
18. Backup and Recovery: Concepts and Configuration
Identify the Importance of Checkpoints, Redo Logfiles, and Archive Logfiles
Instance Recovery
The Impossibility of Database Corruption
Checkpointing
Protecting the Online Redo Logfiles
Archivelog Mode and the Archiver Process(es)
Backup and Recovery: Configuration
Exercise 18-1: Investigate and Adjust the Redo Log Configuration
Configure the Fast Recovery Area
Configure Archivelog Mode
Exercise 18-2: Enable Archivelog Mode
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
19. Backup and Recovery Operations
Create Consistent Database Backups
Exercise 19-1: Consistent Server-Managed Backup
Back Up Your Database Without Shutting It Down
Exercise 19-2: Perform Server-Managed Open Backups
Create Incremental Backups
Automate Database Backups
Manage Backups
The RMAN Repository
Reports on Backups
Administering Backups
Determine the Need for Performing Recovery
Use Recovery Manager (RMAN) and the Data Recovery Advisor to Perform Recovery of the Controlfile, Redo Logfile, and Datafile
The Health Monitor and the ADR
Using the DRA
Exercise 19-3: Use the DRA to Diagnose and Repair a Problem
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
20. Installing Oracle Grid Infrastructure for a Standalone Server
Configure Storage for Oracle Automatic Storage Management (ASM)
GI Architecture
ASM Architecture
ASM Disks
Creating ASM Disks
Install Oracle Grid Infrastructure for a Standalone Server
Exercise 20-1: Install Grid Infrastructure
Two-Minute Drill
Q&A Self Test
Lab Exercise
Self Test Answers
Lab Answer
21. Using Oracle Restart
Use Oracle Restart to Manage Components
Administering the Oracle Restart Processes
Administering Registered Resources
The Restart Capability
Exercise 21-1: Configure a Database for Oracle Restart
Two-Minute Drill
Q&A Self Test
Lab Exercise
Self Test Answers
Lab Answer
22. Upgrading Oracle Database Software and Migrating Data
Describe Upgrade Methods
Software Upgrade
Database Upgrade: DBUA or Manual
Describe Data Migration Methods
Describe the Upgrade Process
Migrating Data by Using Oracle Data Pump
Exercise 22-1: Perform a Data Pump Full Database Migration
Two-Minute Drill
Q&A Self Test
Self Test Answers
23. Database Upgrade: Preparation, Upgrading, and Post-Upgrade Tasks
Describe Upgrade Requirements when Certain Features or Options Are Used in Oracle Database
Oracle Label Security and Oracle Data Vault
Oracle Warehouse Builder
Use the Pre-Upgrade Information Tool Before Performing an Upgrade
Prepare the New Oracle Home Prior to Performing an Upgrade
Upgrade the Database to Oracle Database 12c by Using the Database Upgrade Assistant (DBUA)
Perform a Manual Upgrade to Oracle Database 12c by Using Scripts and Tools
Migrate to Unified Auditing
Perform Post-Upgrade Tasks
Exercise 23-1: Simulate Some Upgrade Tasks
Two-Minute Drill
Q&A Self Test
Lab Question
Self Test Answers
Lab Answer
A. About the Download
System Requirements
Installing and Running Total Tester
About Total Tester
Technical Support
Glossary
Index
← Prev
Back
Next →
← Prev
Back
Next →