Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

ISBN:
0-9744355-3-8
ISBN 13
978-0974435534
Library of Congress Number: 2003096523
336 pages:
Perfect bind 9x6
PD 404
Shelving: Database/Oracle Oracle In-Focus Series
# 14

  OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques


By Christopher T. Foot    Retail Price $27.95 / £17.95 
Order now and get immediate online access to the code depot! Only $19.95  
(30% off)
     
Key Features About the Authors Table of Contents
Index Reader Comments Errata
     
Get the Easy Oracle Pack
Five books for $59.95 - A $110.00 value
Easy Oracle Jumpstart $27.95
Easy Oracle PHP $27.95
Oracle DBA Made Simple (eBook) $19.95
Easy Oracle SQL $16.95
Easy Oracle PL/SQL Programming $16.95


Written by one of the world's most widely-read Oracle instructors, this book utilizes Chris Foot's substantial knowledge of Oracle DBA training to create this unique guide to teaching Oracle DBA certification. This book is for Oracle OCP DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam.

The book also contains a wealth of general information on administering Oracle database environments and is an excellent resource for day-to-day database administrators.

 

Key Features

* Provides the OCP certification instructor with detailed learning content.

* Guides the OCP instructor through the important OCP test areas.

* Contains valuable tips and techniques for making students succeed in passing their OCP exam.

* Focuses on the important OCP conceptual areas.

* Provides practical and applied teaching techniques for OCP instructors.

* Includes expert advice on performance and tuning, backup and recovery, Oracle internals and general database administration guidelines.

* Provides dozens of hints and tips that aren't covered by other Oracle books currently on the market including these topics:

- The pros and cons of the most commonly used Oracle platforms including UNIX, LINUX and Windows.

- Database design review meetings – The key to successful application development projects.

- Dozens of best practices that are guaranteed to increase the quality of day-to-day support activities and reduce the amount of time spent administering Oracle databases

About the Author:

Chris Foot

  Christopher T. Foot is an Oracle certified senior-level instructor, technical sales specialist and database architect for Contemporary Technology.

Chris has fifteen years' experience with database Technologies and is a regular speaker at the International Oracle Users Group and Oracle Open World conferences Contemporary Technologies Inc. is a leading provider of Oracle products and services.

 

Table of Contents:
Chapter 1 - Getting Started
Why Database Administration?
Oracle Database Administration Responsibilities
Oracle Classroom Education
Oracle9i Curriculum Changes
Oracle9i Oracle Certifications
            Oracle Certified Database Associate (OCA)
            Oracle Certified Database Professional (OCP)
            Oracle Certified Master Database Administrator (OCM)
Oracle9i DBA OCP Upgrade Path
Other Recommend Classes
Preparing for the Oracle Certified Professional Exams
Taking the Certification Exams
Finding Information Quickly – The Key to Success
Reference Manuals
Oracle Internal Resources
External Resources
Book Recommendations
 
Chapter 2 - Oracle Database Architectures
Oracle on Microsoft Windows Platforms
Oracle on LINUX Platforms
Oracle on Unix Platforms 
Database Architecture Comparison Worksheet
Venturing into the Great Unknown – New Database Architectures


Chapter 3 - Oracle Database Design Review Meetings
Initial Overview of Proposed System
Logical Data Model Review
Designing for Performance
Setting up a Successful Test System in Oracle
Monitoring Performance During Testing
Performance Design Reviews
Preparation for Production Turnover
            Post Production Turnover
Oracle Database Design Review Meetings - Conclusion


 
Chapter 4 - Oracle Database Administration
Oracle Software Installation
Migrating to new Oracle releases
UNIX and LINUX Semaphores and Shared Memory
Relinking Oracle8i and Oracle9i Products
Windows Services
Oracle Instance Administration
Oracle9i Persistent Initialization Parameter Files
Remote Startup/Shutdown
Multiple Buffer Pools
Specifying Default, Keep and Recycle Bufferpools in Oracle8 and Oracle8i
Specifying Default, Keep and Recycle Bufferpools in Oracle9i
Large Pool
Java Pool
Redo log Buffer Performance
Buffer Performance is critical to Good Oracle Performance
DBWR_IO_SLAVES vs DB_WRITER_PROCESSES
 
 
Chapter 5 – Oracle Database Objects
What Database Are You Working In?
GLOGIN.SQL and LOGIN.SQL
Choosing a Database Block Size
Copying Databases Between Servers
Oracle Tablespaces
Temporary Tablespaces
Create Tablespace Temporary vs. Create Temporary Tablespace
Partitioning   
Oracle 8 - Range Partitioning
Index Partitioning
Equi-Partitioned Objects
Local Indexes
Global Indexes
Oracle8i – Hash and Range/Hash Composite Partitioning
Oracle9i – List and Range/List Composite Partitioning
Which Partitioning Technique Do I Choose?
Oracle9i Tablespace Changes
Locally Managed System Tablespaces
Rollback Segments
When is the System Rollback Segment Used?
Why is Oracle Recommending Minextents of 20 for Rollback Segments?
Rollback Segments and Transaction Processing Workloads
Batch and On-line Processing
Rollback Segments and Users – Who’s Using What?
Oracle9i - Database Managed Undo Segments
Redo Logs
Checkpoint Not Complete
Resizing Redo Logs
Oracle Tables and Indexes
Space Utilization for Parallel Table Creates
Index-only Tables
Single Table Hash Clusters
Oracle9i External Tables
ALTER TABLE MOVE Statement
ALTER COLUMN RENAME Statement
On-line Table Reorganizations
PCTFREE and PCTUSED
Caching Tables
Clustering Data in Tables
Merging Tables to Increase Query Performance
How Many Indexes Can I Build?
Parameters that Impact Index Usage
Index-Only Access
Index Rebuilds
Index Coalesce vs Index Rebuild
Function-Based Indexes
Bitmap Indexes
Concurrency and Bitmap Indexes
When to Use Bitmap Indexes
Optimizer and Bitmap Indexes
Bitmap vs B-Tree
Indexing Hints Tips and Tricks
Index Monitoring
 
 

 

Chapter 6 - Oracle Backup and Recovery
It’s the Little Things That Bite You
Keep Your Skills Sharp

RELAX and Plan Your Attack
Don’t Be Afraid to Ask Others
Instance Recovery and the Oracle Synchronization Process
Uncommitted Data on the Data Files
Committed Data Not On the Data Files
The Synchronization Process
Roll Forward Phase
Roll Backward Phase
Exports and Recovery
V$RECOVERFILE
Watch the NOLOGGING Option
Striped File Systems
Data Files and Redo Logs
Redo Log and Control File Multiplexing
OCOPY for NT
Hot Backup Scripts for NT
Hot Backup Scripts for UNIX
Oracle9i – Lazy Checkpointer
Recovery Manager
Recovery Catalog
Recovery Manager Backup Types
Parallel Backup and Recovery
Multiplexed Backup Sets
Backup/Recovery Reports
Database Recovery
RMAN Examples
DB_VERIFY
 
 
 
Chapter 7 – Tuning and Performance
Be careful with the ANALYZE command
Finding Problem Queries
Optimizer Plan Stability
Pinning Objects in the Shared Pool
PCTFREE and PCTUSED
Caching Tables
Clustering Data in Tables
Merging Tables to Increase Query Performance
Hints
Parallel Hints
Performance Testing
Parallel Query
Tuning Oracle on Windows
Tuning Pack
Direct Load Inserts
Parallel DML Processing
Materialized Views
Database Resource Management
STATSPACK
V$ TABLES vs Oracle BSTAT/ESTAT and STATSPACK
Segment-Level Performance Statistics Collection
Performance Tuning Intelligent Advisories
Optimizer Dynamic Sampling
Data Segment Compression
Using Explain Pan to Determine Access Paths
Explain Plan Output
SQL*PLUS AUTOTRACE
High Water Mark and Table Scans
 
 
Chapter 8  – Miscellaneous Oracle Information
The Foot Rule of Thumb
Monitor By Day So You Don’t Get Called at Night
Monitoring Space Utilization and Performance Statistics Historically
Latches and Enqueues
Deadlock Detection
Unindexed Foreign Keys and Locking Problems
Using PUPBLD
Copying databases between servers
Oracle9i - Resumable Space Allocation
Oracle9i – Flashback Query
Full Database Exports
Large Table Imports
Compressing Export Output Files in UNIX
Terminating Oracle Processes (Threads) in Windows Systems
Truncating vs Deleting
Copy Command in SQL*PLUS
Displaying Time in Milliseconds
!, $ and Host Command Differences
Learn Command Line BEFORE Using "Sissy GUI Tools" 
Don’t Write Scripts
Don’t’ Write Iterative SQL Statements – Generate SQL with SQL
Input Truncated to 9 Characters
 
 
Chapter 9  – Evaluating Third Party Products
Initial Analysis
Determine Impact to the Information Technology Support Infrastructure
Analysis Evaluation
Obtain Business Unit and IT Management Commitment
Create Evaluation Team
Locate Potential Vendors
Initial Elimination
Vendor Evaluation
Communicate Results
 
 
Chapter 10  – Ease of Administration
Good Documentation is Essential
Follow OFA Naming Conventions
Proceduralize Administrative Support for the Application Development Process
Proceduralize the Change Request Process
Oracle Authorization Request Form
Oracle Database Change Request Form
Oracle Migration to Production Request Form
Create and Standardize Monitoring and Administration Scripts
Repeatable Processes
Create Service Level Agreements
DBA Report Cards and the 360-Degree Review Process
Corrective Action Reports
 
 
Chapter 11 – Database Security
Protecting Data Requires More than just Protecting the Production Database
Identifying Granted Privileges
Accounts Created During Database Creation
Wrapping PL/SQL Programs
Using OPS$ Accounts
Using Security Profiles
SYS and SYSTEM Passwords
GRANT ANY OBJECT Privilege
Administrative User Auditing
Moving the AUD$ Tabl
 

Index:

A
audit_file_dest
audit_sys_operations
audit_trail  

B
BSTAT 
buffer_pool_keep
buffer_pool_name 

D
Data buffer cache
db_block_buffers
db_cache_size
db_create_file_dest
db_keep_cache_size
db_nk_cache_size 
db_recycle_cache_size 
db_verify  
d
b_writer_processes
dba_col_privs
dba_data_files
dba_role_privs 
dba_roles        
dba_sys_privs
dba_tab_privs
dba_tablespaces
dba_temp_file
dba_undo_extents
dba_users 
dbms_flashback
dbms_redefinition 
dbms_shared_pool.keep
dbms_stats  
DBWR  
dbwr_io_slaves 

E
ESTAT     

F
failed_login_attempts    
fast_smart_mttr_target   

I
initial  
initrans 

J
java_pool_size   

L
large_pool_size
LGWR
local
Log buffer
log_buffer
log_checkpoint_interval
log_checkpoint_timeout 

M
max_sga_size 
maxtrans 

O
optimizer_dynamic_ sampling
optimizer_index_caching
optimizer_index_cost_ adj
optimizer_mode 
ORA-27100
ORA-27102
ORA-27123
ORA-27125
ORA-7250
ORA-7251
ORA-7252 
ORA-7279       
ORA-7339       
oracle_loader 
oracle_priority
oracle_sid       

P

parallel_automatic_ tuning 
password_grace_time
password_life_time 
password_lock_time 
password_reuse_max 
password_reuse_time
password_verify_ function
-pfile
PFILE
pga_aggregate_target 
proxy_users

Q
queue_privs 

R
remote_os_authent 
role_role_privs
role_sys_privs  
role_tab_privs
Rollback/Undo segments

S
session_privs
session_roles
sga_max_size
shared_pool_size 
shmmax 
shmmin
shmmni 
shmseg
sort_area_retained_size
sort_area_size
spfile 
SPFILE
statistics_level

U
undo_management  
undo_retention
undo_tablespace
use_stored_outlines  

V
v$backup_device
v$datafile
v$log
v$log_history
v$object_usage
v$recoverfile
v$rollstat 
v$segment_statistics
v$segstat
v$segstat_name
v$shared_pool_advice
v$tempfile       

We also offer Oracle OCP books Oracle OCP test, Oracle OCP testing, Oracle OCP certification, Oracle OCP Exam, OCP, OCP Exam, OCP test, OCP certification, OCP questions, OCP exam questions, OCP test questions and OCP certification questions.

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks