 |
|
Easy Oracle Automation
Oracle10g
Automatic Storage, Memory and
Diagnostic Features
Dr.
Arun Kumar R.
ISBN 0-9745993-6-0
Library of Congress Number: 2004096475
240 pages - Perfect bind - 9x7
Publication Date - December 2004
Shelving: Database
Easy Oracle Series #1
Retail Price $27.95
/ £17.95
Order now and
get immediate online access to the
code depot!
Only $19.95
(30% off)
|
|
This indispensable book shows how a non-Oracle person can quickly
install and configure Oracle database 10g for automatic database
administration. In less than a day, you can have a complete
ready-to-use Oracle database.
Written by one of the world's leading Oracle technology experts,
Professor Kumar targets his insights into this highly pragmatic
book. This book explains how to use the powerful Oracle 10g
automatic features for simple database administration. It has
complete coverage for 10g Automatic Storage Management (ASM), 10g
Automatic Workload Repository (AWR), Automatic Database Diagnostic
Monitor (ADDM), Automatic SGA Management (ASM) and the SQL Tuning
Advisor.
For practicing Oracle professionals, this book has a special "for
gurus" section at the end of each chapter where Dr. Kumar explains
the new Oracle10g v$ views and exposes the internal mechanisms
behind these automatic tuning and configuration tools.
|
|
* Explains easy disk and file
management with the 10g Automatic Storage Management
* Shows how the 10g Automatic Workload Repository collects
important Oracle performance statistics
* Describes how the 10g Automatic Database Diagnostic Monitor
(ADDM) pinpoints performance problems and makes tuning
recommendations
* Illustrates how the Automatic SGA Management utility
automatically manages RAM memory regions
* Explains how the SQL Tuning Advisor analysis sub-optimal SQL
and recommends tuning changes
* Dives into the internals of the v$ views and exposes the
internal workings of the automation features |
About the Author:
Dr. Arun Kumar |
|
Dr. Arun Kumar
R. is an expert in architecting, implementing, and
trouble-shooting large-scale, highly complex systems using
Oracle technologies. Dr. Kumar has more than a decade of
experience in Oracle Database Administration including
multidimensional, decision support systems and ERP software.
Dr. Kumar has worked on a wide variety of projects and
environments ranging from client-server, E-Business to managed
services across multiple relational database systems in
telecommunications, retail and health care industries.
Arun
serves as the Associate Editor for the International Oracle
Users Group (IOUG) SELECT Journal and as the Chairman of the
Dallas Chapter of IEEE. He also serves as a Professor of
Database Technologies and E-Business at a renowned private
university. He has published several papers for many technical
journals in the US and Asia and spoken at Oracle technology
conferences and international seminars.
Arun has
Ph.D. in Business Administration, and M.S., majoring in
Computer Science. He is an alumni of Louisiana State
University and currently serves as a Systems Architect for
Enterprise Data Services at a major wireless carrier in
Dallas. |
Table of Contents:
Chapter 1 - Oracle Grid
Computing
Introduction
Benefits of Using Grid technology
Oracle and Grid Computing Initiatives
How Does Grid Infrastructure Work
Conclusion
Chapter 2
- Architecture Changes in a Nutshell
What’s new in the 10g
Architecture?
Summary of Performance Improvement Features
The Making of Oracle Database 10g
Changes to Memory Structures
Details of New Feature Upgrades
SYSAUX Tablespace
Automatic Storage Management
BigFile Tablespace
Rename Tablespace
Cross-Platform Transportable Tablespaces
Automated Memory Management Using AWR and
ADDM
Drop Database Command
Automated SQL Tuning Features
Data Pump Utilities
Backup and Recovery – Flashback, RMAN
Globalization Development
Changes to Oracle
Enterprise Manager
Conclusion
Chapter 3
- Installation and Database Creation
Setup Oracle Database 10g
Oracle Database 10g Prerequisites
A Word on Silent Installation
Installation of Oracle Software and Database
Database Configuration Assistant (DBCA
Overview of Database Upgrade Assistant
How to Set Up and Use OEM
Conclusion
Chapter 4
- Automatic Workload Repository and
Automatic Database Diagnostic Monitor
What is AWR?
Uses of AWR
Architecture of AWR
Active Session History
Statistics Collection Process
Server Generated Alerts
How are Alerts Recorded by AWR
Advisory Framework
ADDM Performance Monitoring
Using OEM to Track Problems Detected by ADDM
Guru Conversation for the
Senior DBA
How Does AWR Collect Data
Review of AWR Dynamic Performance Tables
How Does AWR Compare Against STATSPACK?
Inside the Automatic Workload Repository Tables
Inside the DBA_HIST Views
AWR Reporting
Creating
Custom AWR Reports
Exception Reporting with Enterprise Manager
Exception Reporting with the AWR
Correlation Analysis Reports with
AWR and ASH Views
AWR and ADDM in a Nutshell
Conclusion
Chapter 5
- Automatic Storage Management
Automatic Storage
Management (ASM)
ASM Concepts
ASM Architecture
ASM Instance Management
Initialization Parameters
for ASM Instance
Disk Recovery Time
Rebalance Operation
ASM Instance Operations
Starting
Up and Shutting Down of an ASM Instance
Discovering the Disks and Disk Groups
ASM Instance Configuration
Rules and Guidelines for ASM Instance Configuration
Mounting Disk Groups
Disk Group Templates
Disk Group Directories
Alias Filenames
Dropping a Disk Group
Internal Consistency of Disk Groups
File Types Supported by ASM
Dynamic Performance Views
on ASM
How Are ASM Files Used in the Database
Using ASM to Create a Database
New Tablespace Types
Automated Space Management
in Oracle10g
Oracle Segment Advisor
Automatic Undo Management
Redo Logfile Advisor
Guru Conversation for the
Senior DBA
Conclusion
|
Chapter 6 - Automatic System Resource
Management
Automatic Shared Memory
Management (ASMM)
Using Memory Advisor through OEM
Automated Maintenance Tasks
Guru Conversation for the
Senior DBA
AWR
in Memory Statistics
Active Session History
Conclusion
Chapter 7 - Application and SQL
Management
Introduction to Tuning
SQL Tuning Features
Automatic Workload Repository
Automatic Database Diagnostic
Monitor
SQL Query Optimizer
SQL Tuning Advisor
Using SQL Tuning Advisor
through OEM
SQL Access Advisor
SQL Tuning with SQL Access Advisor
Automated Task Scheduling
Using SQL Access Advisor through OEM
Flash Back Corrections
Flashback
Transaction Query
Flashback Table
Flashback Drop
Guru Conversation for the Senior DBA
Implementing
SQL Access Advisor Recommendations Manually
Conclusion
Chapter 8 - Automatic
Performance Monitoring – Utilities
Automated Performance
Monitoring – Utilities
Proactive Database Monitoring
Database Alerts
Alerts Management Using OEM
Reviewing Metrics and Thresholds
Alerts Notification and Setup
Responding to Alerts
Clearing of Alerts
Data Pump
Process Flow in Data Pump Implementation
Data Pump Jobs
External Tables
Conclusion
Book Conclusion |
|
|
