OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration SERIES: Oracle In-Focus series

Christopher T. Foot

  • 出版商: Rampant Tech Press
  • 出版日期: 2004-04-01
  • 定價: $960
  • 售價: 2.1$199
  • 語言: 英文
  • 頁數: 336
  • 裝訂: Paperback
  • ISBN: 0974435538
  • ISBN-13: 9780974435534
  • 相關分類: OracleOracle 認證資料庫
  • 立即出貨(限量) (庫存=2)

買這商品的人也買了...

商品描述

Description:

Written by one the world's top 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.

 

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

商品描述(中文翻譯)

描述:
這本書是由世界頂尖的Oracle教師之一Chris Foot所撰寫,利用他在Oracle DBA培訓方面的豐富知識,創作了這本獨特的Oracle DBA認證教學指南。這本書適用於希望確保學生成功通過Oracle OCP認證考試的Oracle OCP DBA教師。該書還包含了大量關於管理Oracle數據庫環境的一般信息,是日常數據庫管理員的優秀資源。

目錄:
第1章 - 入門
為什麼要進行數據庫管理?
Oracle數據庫管理職責
Oracle課堂教育
Oracle9i課程變更
Oracle9i Oracle認證
Oracle認證數據庫管理員(OCA)
Oracle認證專業數據庫管理員(OCP)
Oracle認證高級數據庫管理員(OCM)
Oracle9i DBA OCP升級路徑
其他推薦課程
為Oracle認證專業考試做準備
參加認證考試
快速尋找信息-成功的關鍵
參考手冊
Oracle內部資源
外部資源
書籍推薦

第2章 - Oracle數據庫架構
Microsoft Windows平台上的Oracle
LINUX平台上的Oracle
Unix平台上的Oracle
數據庫架構比較工作表
進入未知領域-新的數據庫架構

第3章 - Oracle數據庫設計審查會議
提案系統的初步概述
邏輯數據模型審查
為性能設計
在Oracle中建立成功的測試系統
在測試期間監控性能
性能設計審查
準備生產交接
生產交接後
Oracle數據庫設計審查會議-結論

第4章 - Oracle數據庫管理
Oracle軟件安裝
遷移到新的Oracle版本
UNIX和LINUX的信號量和共享內存
重新連接Oracle8i和Oracle9i產品
Windows服務
Oracle實例管理
Oracle9i持久初始化參數文件
遠程啟動/關閉
多個緩衝池
在Oracle8和Oracle8i中指定默認、保留和循環緩衝池
在Oracle9i中指定默認、保留和循環緩衝池
大型緩衝池
Java緩衝池
重做日誌緩衝區性能
緩衝區性能對良好的Oracle性能至關重要
DBWR_IO_SLAVES vs DB_WRITER_PROCESSES

第5章 - Oracle數據庫對象
你正在使用哪個數據庫?
GLOGIN.SQL和LOGIN.SQL
選擇數據庫塊大小
在服務器之間複製數據庫
Oracle表空間
臨時表空間
創建臨時表空間vs創建臨時表空間
部分...