Book description
A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053
Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:
- Instance management
- Networking and storage
- Security
- SQL
- Oracle Recovery Manager and Oracle Flashback
- Oracle Automatic Storage Management
- Resource manager
- Oracle Scheduler
- Automatic workload repository
- Performance tuning
- Three bonus exams available with free online registration
Table of contents
- Cover Page
- OCA/OCP Oracle Database 11g All-in-One Exam Guide
- Copyright Page
- Dedication
- Contents
- Introduction
-
PART I Oracle Database 11g Administration
-
CHAPTER 1 Architectural Overview of Oracle Database 11g
- Exam Objectives
- Oracle Product Stack
- Oracle Server Family
- Oracle Development Tools
- Oracle Applications
- Prerequisite Concepts
- Oracle Concepts
- SQL Concepts
- Operating System Concepts
- Single-Instance Architecture
- Single-Instance Database Architecture
- Distributed Systems Architectures
- Instance Memory Structures
- The Database Buffer Cache
- The Log Buffer
- The Shared Pool
- The Large Pool
- The Java Pool
- The Streams Pool
- Instance Process Structures
- 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
- ARCn, the Archiver
- RECO, the Recoverer Process
- Some Other Background Processes
- Database Storage Structures
- The Physical Database Structures
- The Logical Database Structures
- The Data Dictionary
- Two-Minute Drill
- Single-Instance Architecture
- Instance Memory Structures
- Instance Process Structures
- Database Storage Structures
- Self Test
- Self Test Answers
-
CHAPTER 2 Installing and Creating a Database
- Exam Objectives
- Identify the Tools for Administering an Oracle Database
- The Oracle Universal Installer
- Database Creation and Upgrade Tools
- Tools for Issuing Ad Hoc SQL: SQL*Plus and SQL Developer
- Oracle Enterprise Manager
- Other Administration Tools
- Plan an Oracle Database Installation
- Choice of Operating System
- Hardware and Operating System Resources
- Optimal Flexible Architecture
- Environment Variables
- Install the Oracle Software by Using the Oracle Universal Installer (OUI)
- Create a Database by Using the Database Configuration Assistant
- The Instance, the Database, and the Data Dictionary
- Using the DBCA to Create a Database
- The Scripts and Other Files Created by the DBCA
- The DBCA’s Other Functions
- Two-Minute Drill
- Identify the Tools for Administering an Oracle Database
- Plan an Oracle Database Installation
- Install the Oracle Software by Using the Oracle Universal Installer (OUI)
- Create a Database by Using the Database Configuration Assistant
- Self Test
- Self Test Answers
-
CHAPTER 3 Instance Management
- Exam Objectives
- Set Database Initialization Parameters
- Static and Dynamic Parameters and the Initialization Parameter File
- The Basic Parameters
- Describe the Stages of Database Startup and Shutdown
- Starting and Connecting to Database Control
- Starting the Database Listener
- Starting SQL*Plus
- Database Startup and Shutdown
- Use the Alert Log and Trace Files
- Use Data Dictionary and Dynamic Performance Views
- The Data Dictionary Views
- The Dynamic Performance Views
- Two-Minute Drill
- Describe the Stages of Database Startup and Shutdown
- Set Database Initialization Parameters
- Use the Alert Log and Trace Files
- Use Data Dictionary and Dynamic Performance Views
- Self Test
- Self Test Answers
-
CHAPTER 4 Oracle Networking
- Exam Objectives
- Configure and Manage the Oracle Network
- Oracle Net and the Client-Server Paradigm
- A Word on Oracle Net and Communication Protocols
- Establishing a Session
- Creating a Listener
- Database Registration
- Techniques for Name Resolution
- The Listener Control Utility
- Configuring Service Aliases
- Filenames and the TNSADMIN Environment Variable
- Database Links
- Use the Oracle Shared Server Architecture
- The Limitations of Dedicated Server Architecture
- The Shared Server Architecture
- Configuring Shared Server
- When to Use the Shared Server
- Two-Minute Drill
- Configure and Manage the Oracle Network
- Use the Oracle Shared Server Architecture
- Self Test
- Self Test Answers
-
CHAPTER 5 Oracle Storage
- Exam Objectives
- Overview of Tablespaces and Datafiles
- The Oracle Data Storage Model
- Segments, Extents, Blocks, and Rows
- File Storage Technologies
- Create and Manage Tablespaces
- Tablespace Creation
- Altering Tablespaces
- Dropping Tablespaces
- Oracle-Managed Files (OMF)
- Space Management in Tablespaces
- Extent Management
- Segment Space Management
- Two-Minute Drill
- Overview of Tablespaces and Datafiles
- Create and Manage Tablespaces
- Space Management in Tablespaces
- Self Test
- Self Test Answers
-
CHAPTER 6 Oracle Security
- Exam Objectives
- Create and Manage Database User Accounts
- User Account Attributes
- Authentication Methods
- Creating Accounts
- Grant and Revoke Privileges
- System Privileges
- Object Privileges
- Create and Manage Roles
- Creating and Granting Roles
- Predefined Roles
- Enabling Roles
- Create and Manage Profiles
- Password Management
- Resource Limits
- Creating and Assigning Profiles
- Database Security and Principle of Least Privilege
- Public Privileges
- Security-Critical Instance Parameters
- Work with Standard Database Auditing
- Auditing SYSDBA Activity
- Database Auditing
- Value-Based Auditing with Triggers
- Fine-Grained Auditing (FGA)
- Two-Minute Drill
- Create and Manage Database User Accounts
- Grant and Revoke Privileges
- Create and Manage Roles
- Create and Manage Profiles
- Database Security and Principle of Least Privilege
- Work with Standard Database Auditing
- Self Test
- Self Test Answers
-
CHAPTER 1 Architectural Overview of Oracle Database 11g
-
PART II SQL
-
CHAPTER 7 DDL and Schema Objects
- Exam Objectives
- Categorize the Main Database Objects
- Object Types
- Naming Schema Objects
- Object Namespaces
- List the Data Types That Are Available for Columns
- Create a Simple Table
- Creating Tables with Column Specifications
- Creating Tables from Subqueries
- Altering Table Definitions after Creation
- Dropping and Truncating Tables
- Create and Use Temporary Tables
- Indexes
- Why Indexes Are Needed?
- Types of Index
- Creating and Using Indexes
- Modifying and Dropping Indexes
- Constraints
- The Types of Constraint
- Defining Constraints
- Constraint State
- Constraint Checking
- Views
- Why Use Views at All?
- Simple and Complex Views
- CREATE VIEW, ALTER VIEW, and DROP VIEW
- Synonyms
- Sequences
- Creating Sequences
- Using Sequences
- Two-Minute Drill
- Categorize the Main Database Objects
- List the Data Types That Are Available for Columns
- Create a Simple Table
- Create and Use Temporary Tables
- Constraints
- Indexes
- Views
- Synonyms
- Sequences
- Self Test
- Self Test Answers
-
CHAPTER 8 DML and Concurrency
- Exam Objectives
- Data Manipulation Language (DML) Statements
- INSERT
- UPDATE
- DELETE
- TRUNCATE
- MERGE
- DML Statement Failures
- Control Transactions
- Database Transactions
- Executing SQL Statements
- Transaction Control: COMMIT, ROLLBACK, SAVEPOINT, SELECT FOR UPDATE
- Identify and Administer PL/SQL Objects
- Stored and Anonymous PL/SQL
- PL/SQL Objects
- Monitor and Resolve Locking Conflicts
- Shared and Exclusive Locks
- The Enqueue Mechanism
- Lock Contention
- Deadlocks
- Overview of Undo
- Transactions and Undo Data
- Managing Undo
- Error Conditions Related to Undo
- Parameters for Undo Management, and Retention Guarantee
- Sizing and Monitoring the Undo Tablespace
- Creating and Managing Undo Tablespaces
- Two-Minute Drill
- Describe Each Data Manipulation Language (DML) Statement
- Control Transactions
- Manage Data Using DML
- Identify and Administer PL/SQL Objects
- Monitor and Resolve Locking Conflicts
- Overview of Undo
- Transactions and Undo Data
- Managing Undo
- Self Test
- Self Test Answers
-
CHAPTER 9 Retrieving, Restricting, and Sorting Data Using SQL
- Exam Objectives
- List the Capabilities of SQL SELECT Statements
- Introducing the SQL SELECT Statement
- The DESCRIBE Table Command
- Capabilities of the SELECT Statement
- Data Normalization
- Create the Demonstration Schemas
- The HR and WEBSTORE Schemas
- Demonstration Schema Creation
- Execute a Basic SELECT Statement
- Syntax of the Primitive SELECT Statement
- Rules Are Meant to Be Followed
- SQL Expressions and Operators
- NULL Is Nothing
- Limit the Rows Retrieved by a Query
- The WHERE Clause
- Comparison Operators
- Boolean Operators
- Precedence Rules
- Sort the Rows Retrieved by a Query
- The ORDER BY Clause
- Ampersand Substitution
- Substitution Variables
- Define and Verify
- Two-Minute Drill
- List the Capabilities of SQL SELECT Statements
- Execute a Basic SELECT Statement
- Limit the Rows Retrieved by a Query
- Sort the Rows Retrieved by a Query
- Ampersand Substitution
- Self Test
- Self Test Answers
-
CHAPTER 10 Single-Row and Conversion Functions
- Exam Objectives
- Describe and Use Character, Number, and Date Functions in SQL
- Defining a Function
- Types of Functions
- Using Case Conversion Functions
- Using Character Manipulations Functions
- Using Numeric Functions
- Working with Dates
- Describe Various Types of Conversion Functions Available in SQL
- Conversion Functions
- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
- Using the Conversion Functions
- Apply Conditional Expressions in a SELECT Statement
- Nested Functions
- Conditional Functions
- Two-Minute Drill
- Describe Various Types of Functions Available in SQL
- Use Character, Number, and Date Functions in SELECT Statements
- Describe Various Types of Conversion Functions Available in SQL
- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
- Apply Conditional Expressions in a SELECT Statement
- Self Test
- Self Test Answers
-
CHAPTER 11 Group Functions
- Exam Objectives
- The Group Functions
- Definition of Group Functions
- Using Group Functions
- Group Data Using the GROUP BY Clause
- Creating Groups of Data
- The GROUP BY Clause
- Grouping by Multiple Columns
- Nested Group Functions
- Include or Exclude Grouped Rows Using the HAVING Clause
- Restricting Group Results
- The HAVING Clause
- Two-Minute Drill
- Describe the Group Functions
- Identify the Available Group Functions
- Group Data Using the GROUP BY Clause
- Include or Exclude Grouped Rows Using the HAVING Clause
- Self Test
- Self Test Answers
-
CHAPTER 12 SQL Joins
- Exam Objectives
- Write SELECT Statements to Access Data from More Than One Table
- Using Equijoins and Nonequijoins Types of Joins
- Joining Tables Using SQL:1999 Syntax
- Qualifying Ambiguous Column Names
- The NATURAL JOIN Clause
- The Natural JOIN USING Clause
- The Natural JOIN ON Clause
- N-Way Joins and Additional Join Conditions
- Nonequijoins
- Join a Table to Itself Using a Self-Join
- Joining a Table to Itself Using the JOIN ON Clause
- View Data That Does Not Meet a Join Condition by Using Outer Joins
- Inner Versus Outer Joins
- Left Outer Joins
- Right Outer Joins
- Full Outer Joins
- Generate a Cartesian Product of Two or More Tables
- Creating Cartesian Products Using Cross Joins
- Two-Minute Drill
- Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
- Join a Table to Itself Using a Self-Join
- View Data That Does Not Meet a Join Condition Using Outer Joins
- Generate a Cartesian Product of Two or More Tables
- Self Test
- Self Test Answers
-
CHAPTER 13 Subqueries and Set Operators
- Exam Objectives
- Define Subqueries
- Describe the Types of Problems That the Subqueries Can Solve
- Use of a Subquery Result Set for Comparison Purposes
- Generate a Table from Which to SELECT
- Generate Values for Projection
- Generate Rows to Be Passed to a DML Statement
- List the Types of Subqueries
- Single- and Multiple-Row Subqueries
- Correlated Subqueries
- Write Single-Row and Multiple-Row Subqueries
- Describe the Set Operators
- Sets and Venn Diagrams
- Set Operator General Principles
- Use a Set Operator to Combine Multiple Queries into a Single Query
- The UNION ALL Operator
- The UNION Operator
- The INTERSECT Operator
- The MINUS Operator
- More Complex Examples
- Control the Order of Rows Returned
- Two-Minute Drill
- Define Subqueries
- Describe the Types of Problems That the Subqueries Can Solve
- List the Types of Subqueries
- Write Single-Row and Multiple-Row Subqueries
- Describe the Set Operators
- Use a Set Operator to Combine Multiple Queries into a Single Query
- Control the Order of Rows Returned
- Self Test
- Self Test Answers
-
CHAPTER 7 DDL and Schema Objects
-
PART III Advanced Database Administration
-
CHAPTER 14 Configuring the Database for Backup and Recovery
- Exam Objectives
- Backup and Recovery Issues
- Categories of Failures
- Statement Failure
- User Process Failure
- Network Failure
- User Errors
- Media Failure
- Instance Failure
- Instance Recovery
- The Mechanics of Instance Recovery
- The Impossibility of Database Corruption
- Tuning Instance Recovery
- The MTTR Advisor and Checkpoint Auto-Tuning
- Checkpointing
- Preparing the Database for Recoverability
- Protecting the Controlfile
- Protecting the Online Redo Log Files
- Archivelog Mode and the Archiver Process
- Protecting the Archive Redo Log Files
- The Flash Recovery Area
- Recovery Files
- Configure the Flash Recovery Area
- Flash Recovery Area Space Usage
- Two-Minute Drill
- Identify the Types of Failure That Can Occur in an Oracle Database
- Describe Ways to Tune Instance Recovery
- Identify the Importance of Checkpoints, Redo Log Files, and Archived Log Files
- Configure ARCHIVELOG Mode
- Configure Multiple Archive Log File Destinations to Increase Availability
- Overview of the Flash Recovery Area
- Configure the Flash Recovery Area
- Use the Flash Recovery Area
- Self Test
- Self Test Answers
-
CHAPTER 15 Back Up with RMAN
- Exam Objectives
- Backup Concepts and Terminology
- Using the RMAN BACKUP Command to Create Backups
- Server-Managed Consistent Backups
- Server-Managed Open Backups
- Incremental Backups
- Image Copies
- Protect Your Backups
- Parallelizing Backup Operations
- Encrypting Backups
- Configuring RMAN Defaults
- Managing and Monitoring RMAN Backups
- The LIST, REPORT, and DELETE Commands
- Archival Backups
- The Dynamic Performance Views
- Crosschecking Backups
- Two-Minute Drill
- Create Consistent Database Backups
- Back Up Your Database Without Shutting It Down
- Create Incremental Backups
- Automate Database Backups
- Manage Backups, View Backup Reports, and Monitor the Flash Recovery Area
- Define, Apply, and Use a Retention Policy
- Create Image File Backups
- Create a Whole Database Backup
- Enable Fast Incremental Backup
- Create Duplex Backups and Back Up Backup Sets
- Create an Archival Backup for Long-Term Retention
- Create a Multisection, Compressed, and Encrypted Backup
- Report On and Maintain Backups
- Configure Backup Settings
- Allocate Channels to Use in Backing Up
- Configure Backup Optimization
- Self Test
- Self Test Answers
-
CHAPTER 16 Restore and Recover with RMAN
- Exam Objectives
- The Data Recovery Advisor
- The Health Monitor and the ADR
- The Capabilities and Limitations of the DRA
- Using the Data Recovery Advisor
- Database Restore and Recovery
- Complete Recovery from Data File Loss Using RMAN
- Recovery of Datafiles in Noarchivelog Mode
- Recovery of a Noncritical File in Archivelog Mode
- Recovering from Loss of a Critical Datafile
- Incomplete Recovery
- Autobackup and Restore of the Controlfile
- Using Image Copies for Recovery
- Block Recovery
- Detection of Corrupt Blocks
- Block Media Recovery
- The BLOCK RECOVER Command
- Two-Minute Drill
- Describe the Data Recovery Advisor
- Use the Data Recovery Advisor to Perform Recovery (Controlfile, Redo Log File, and Datafile)
- Perform Complete Recovery from a Critical or Noncritical Data File Loss Using RMAN
- Perform Incomplete Recovery Using RMAN
- Recover Using Incrementally Updated Backups
- Switch to Image Copies for Fast Recovery
- Recover Using a Backup Control File
- Perform Block Media Recovery
- Self Test
- Self Test Answers
-
CHAPTER 17 Advanced RMAN Facilities
- Exam Objectives
- The Recovery Catalog
- The Need for a Recovery Catalog
- Creating and Connecting to the Catalog
- The Virtual Private Catalog
- Protecting and Rebuilding the Catalog
- Stored Scripts
- Using RMAN to Create Databases
- Tablespace Point-in-Time Recovery (TSPITR)
- The TSPITR Methodology
- Perform Automated TSPITR
- RMAN Performance and Monitoring
- Monitoring RMAN Sessions and Jobs
- Tuning RMAN
- Tuning the BACKUP Command
- Configure RMAN for Asynchronous I/O
- Two-Minute Drill
- Identify Situations That Require an RMAN Recovery Catalog
- Create and Configure a Recovery Catalog
- Synchronize the Recovery Catalog
- Create and Use RMAN Stored Scripts
- Back Up the Recovery Catalog
- Create and Use a Virtual Private Catalog
- Create a Duplicate Database
- Use a Duplicate Database
- Restore a Database onto a New Host
- Perform Disaster Recovery
- Identify the Situations That Require TSPITR
- Perform Automated TSPITR
- Monitor RMAN Sessions and Jobs
- Tune RMAN
- Configure RMAN for Asynchronous I/O
- Self Test
- Self Test Answers
-
CHAPTER 18 User-Managed Backup, Restore, and Recovery
- Exam Objectives
- Backup and Recovery in One Page
- User-Managed Database Backup
- Backup in Noarchivelog Mode
- Backup in Archivelog Mode
- Backup of the Password and Parameter Files
- Media Failure That Does Not Affect Datafiles
- Recovery from Loss of a Multiplexed Controlfile
- Recovery from Loss of a Multiplexed Online Redo Log File
- Recovery from Loss of a Tempfile
- Recovery from Loss of Datafiles
- Recovery of Datafiles in Noarchivelog Mode
- Recovery of a Noncritical Datafile in Archivelog Mode
- Recovering a Critical Datafile in Archivelog Mode
- User-Managed Incomplete Recovery
- Two-Minute Drill
- Recover from a Lost TEMP File
- Recover from a Lost Redo Log Group
- Recover from the Loss of a Password File
- Perform User-Managed Complete Database Recovery
- Perform User-Managed Incomplete Database Recovery
- Perform User-Managed Backups
- Identify the Need for Backup Mode
- Back Up and Recover a Controlfile
- Self Test
- Self Test Answers
-
CHAPTER 19 Flashback
- Exam Objectives
- The Different Flashback Technologies
- Flashback Database
- Flashback Query, Transaction, and Table
- Flashback Drop
- Flashback Data Archive
- When to Use Flashback Technology
- Flashback Database
- Flashback Database Architecture
- Configuring Flashback Database
- Monitoring Flashback Database
- Using Flashback Database
- Limiting the Amount of Flashback Data Generated
- Flashback Drop
- The Implementation of Flashback Drop
- Using Flashback Drop
- Managing the Recycle Bin
- Flashback Query
- Basic Flashback Query
- Flashback Table Query
- Flashback Versions Query
- Flashback Transaction Query
- Flashback and Undo Data
- The Flashback Data Archive
- Two-Minute Drill
- Restore Dropped Tables from the Recycle Bin
- Perform Flashback Query
- Use Flashback Transaction
- Perform Flashback Table Operations
- Configure and Monitor Flashback Database and Perform Flashback Database Operations
- Set Up and Use a Flashback Data Archive
- Self Test
- Self Test Answers
-
CHAPTER 20 Automatic Storage Management
- Exam Objectives
- The Purpose of a Logical Volume Manager
- RAID Levels
- Volume Sizes
- Choice of RAID Level
- ASM Compared with Third-Party LVMs
- The ASM Architecture
- The Cluster Synchronization Service
- The ASM Disks and Disk Groups
- The ASM Instance
- The RDBMS Instance
- The ASM Files
- Creating Raw Devices
- Creating, Starting, and Stopping an ASM Instance
- Creating ASM Disk Groups
- Creating and Using ASM Files
- ASM and RMAN
- The ASMCMD Utility
- Two-Minute Drill
- Describe Automatic Storage Management (ASM)
- Set Up Initialization Parameter Files for ASM and Database Instances
- Start Up and Shut Down ASM Instances
- Administer ASM Disk Groups
- Self Test
- Self Test Answers
-
CHAPTER 21 The Resource Manager
- Exam Objectives
- The Need for Resource Management
- The Resource Manager Architecture
- Consumer Groups
- Resource Manager Plans
- Resource Manager Configuration Tools
- Managing Users and Consumer Groups
- Resource Manager 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
- Automatic Consumer Group Switching
- Adaptive Consumer Group Mapping
- Two-Minute Drill
- Understand the Database Resource Manager
- Create and Use Database Resource Manager Components
- Self Test
- Self Test Answers
-
CHAPTER 22 The Scheduler
- Exam Objectives
- The Scheduler Architecture
- Scheduler Objects
- Jobs
- Programs
- Schedules
- Job Classes
- Windows
- Privileges
- Creating and Scheduling Jobs
- A Self-Contained Job
- Using Programs and Schedules
- Event-Driven Jobs
- Job Chains
- Lightweight Jobs
- Using Classes, Windows, and the Resource Manager
- Using Job Classes
- Using Windows
- Two-Minute Drill
- Create a Job, Program, and Schedule
- Use a Time-Based or Event-Based Schedule for Executing Scheduler Jobs
- Create Lightweight Jobs
- Use Job Chains to Perform a Series of Related Tasks
- Create Windows and Job Classes
- Use Advanced Scheduler Concepts to Prioritize Jobs
- Self Test
- Self Test Answers
-
CHAPTER 23 Moving and Reorganizing Data
- Exam Objectives
- SQL*Loader
- External Tables
- Directories
- Using External Tables
- Data Pump
- Data Pump Architecture
- Directories and File Locations
- Direct Path or External Table Path?
- Using Data Pump Export and Import
- Capabilities
- Using Data Pump with the Command-Line Utilities
- Using Data Pump with Database Control
- Tablespace Export and Import
- Resumable Space Allocation
- Segment Reorganization
- Row Chaining and Migration
- Segment Shrink
- Two-Minute Drill
- Describe and Use Methods to Move Data (Directory Objects, SQL*Loader, External Tables)
- Explain the General Architecture of Oracle Data Pump
- Use Data Pump Export and Import to Move Data Between Oracle Databases
- Describe the Concepts of Transportable Tablespaces and Databases
- Manage Resumable Space Allocation
- Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality
- Self Test
- Self Test Answers
-
CHAPTER 24 The AWR and the Alert System
- Exam Objectives
- The Automatic Workload Repository
- Gathering AWR Statistics
- Managing the AWR
- Statistics, Metrics, and Baselines
- The DBMS_WORKLOAD_REPOSITORY Package
- The Database Advisory Framework
- The Automatic Database Diagnostic Monitor
- The Advisors
- Automatic Maintenance Jobs
- Using the Server-Generated Alert System
- Alert Condition Monitoring and Notifications
- Setting Thresholds
- The Notification System
- Two-Minute Drill
- Use and Manage the Automatic Workload Repository
- Use the Advisory Framework
- Manage Alerts and Thresholds
- Self Test
- Self Test Answers
-
CHAPTER 25 Performance Tuning
- Exam Objectives
- Managing Memory
- PGA Memory Management
- SGA Memory Management
- Automatic Memory Management
- The Memory Advisors
- The SQL Tuning Advisor
- The Capabilities of the SQL Tuning Advisor
- Using the SQL Tuning Advisor with Enterprise Manager
- The SQL Tuning Advisor API: the DBMS_SQLTUNE Package
- The SQL Access Advisor
- Using the SQL Access Advisor with Database Control
- Using the SQL Access Advisor with DBMS_ADVISOR
- Identifying and Fixing Invalid and Unusable Objects
- Invalid Objects
- Unusable Indexes
- Database Replay
- Database Replay Workload Capture
- Database Replay Workload Preprocessing
- Launch the Replay
- Database Replay Analysis and Reporting
- Two-Minute Drill
- Use Automatic Memory Management
- Use Memory Advisors
- Troubleshoot Invalid and Unusable Objects
- Implement Automatic Memory Management
- Manually Configure SGA Parameters
- Configure Automatic PGA Memory Management
- Use the SQL Tuning Advisor
- Use the SQL Access Advisor to Tune a Workload
- Understand Database Replay
- Self Test
- Self Test Answers
-
CHAPTER 26 Globalization
- Exam Objectives
- Globalization Requirements and Capabilities
- Character Sets
- Language Support
- Territory Support
- Other NLS Settings
- Using Globalization Support Features
- Choosing a Character Set
- Changing Character Sets
- Globalization Within the Database
- Globalization at the Instance Level
- Client-Side Environment Settings
- Session-Level Globalization Settings
- Statement Globalization Settings
- Languages and Time Zones
- Linguistic Sorting and Selection
- The Locale Builder
- Using Time Zones
- Two-Minute Drill
- Customize Language-Dependent Behavior for the Database and Individual Sessions
- Work with Database and NLS Character Sets
- Self Test
- Self Test Answers
-
CHAPTER 27 The Intelligent Infrastructure
- Exam Objectives
- The Enterprise Manager Support Workbench
- The Automatic Diagnostic Repository (ADR)
- Problems and Incidents
- The ADR Command-Line Interface (ADRCI)
- The Support Workbench
- Patches
- Types of Patch
- Integration with MetaLink and the Patch Advisor
- Applying Patches
- Two-Minute Drill
- Use the Enterprise Manager Support Workbench
- Manage Patches
- Set Up the Automatic Diagnostic Repository
- Self Test
- Self Test Answers
-
CHAPTER 14 Configuring the Database for Backup and Recovery
- APPENDIX About the Download
- Glossary
- Index
Product information
- Title: OCA/OCP Oracle Database 11g All-in-One Exam Guide
- Author(s):
- Release date: September 2009
- Publisher(s): Oracle Press
- ISBN: 9780071629218
You might also like
book
OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050)
A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle …
book
Oracle Database 11g New Features
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11 g Realize …
book
Oracle Database 11g & MySQL 5.6 Developer Handbook
Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using …
book
Oracle 11g R1/R2 Real Application Clusters Essentials
In this book you’ll find a practical tutorial on configuring, installing, and designing Oracle 11g Real …