|
|
|
ISBN
0-9745993-6-0
ISBN 13
978-0974599366 |
Library of Congress
Number: 2004096475 |
296 pages:
Perfect bind - 9x7 |
PD 1204 |
|
Shelving: Databases/Oracle |
Easy Oracle Series # 1 |
|
|
Easy Oracle Automation
Oracle10g
Automatic Storage, Memory and
Diagnostic Features
Dr.
Arun Kumar R.
Retail Price $27.95
/ £17.95
| Order now and
get immediate online access to the
code depot! |
Only $19.95
(30% off) |
 |
Get the Easy Oracle Pack
Six books
for $59.95 - A $118.00 value |
|
|
|
|
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
a
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. Dr. Kumar is an Oracle10 Certified Technician, a
Senior Member of IEEE, and holder of two Oracle Masters
Certifications. |
Reviews:
Don M. - Berryville, Mass:
Dr. Kumar's book is amazing!! The examples and the way it's
written, truly compliment the Oracle documentation. All of our
Oracle DBA's at work use this book as a valued reference. Easy
Oracle Automation : Oracle10g Automatic Storage, Memory and
Diagnostic Features (Easy Oracle Series) is a must read!!
Database Trends and Applications:
"Easy Oracle Automation" from Rampant TechPress is aimed at
novice-to-intermediate users who want to get their feet wet with
Oracle
Database 10g. Written by Dr. Arun Kumar R., associate editor for
the
IOUG's SELECT Journal and columnist for Database Trends and
Applications
magazine, this book explains how even people unfamiliar with
Oracle
technology can easily install and configure Oracle Database 10g
for
automatic database administration. In less than a day, the
reader can have
a complete ready-to-use Oracle database with essential features.
For practicing Oracle professionals, this book has a special
"for gurus"
section at the end of each chapter where the author explains the
new
Oracle10g v$ views and exposes the internal mechanisms behind
these
automatic tuning and configuration tools. While this book is not
a
replacement for any Oracle manual, it provides enough
information to get
started on Oracle Database 10g without skimming through a
handful of
related manuals. This book has a concise coverage of Oracle
Database 10g
new automation features, Automatic Workload Repository (AWR),
Automatic
Database Diagnostic Monitor (ADDM), Automatic Memory Management,
Automatic
Storage Management (ASM), SQL Advisors, and database monitoring
utilities.
An active member of IEEE, Dr. Kumar R. was chosen for the
prestigious
"IEEE Young Engineer of the Year" by TSPE and IEEE in February
2005.
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 |
|
|
Errata:
Index is off by eight pages, please subtract 8 from the page number to get the
correct location.
Index Topics:
$_adv_rationale
$_adv_sqla_fake_reg
A
Active Session History
ADDM
advisor_name
Alert History
alert_que
all_external_locations
all_external_tables
allocation unit
ASH
ASM
ASM architecture
asm_diskgroups
asm_diskstring
asm_power_limit
ASMM
ASSM
auto_task_consumer_group
auto_task_job_class
Automated Space Management
Automatic Database Diagnostic Monitor
Automatic Segment Space Managed
Automatic Shared Memory Management
Automatic SQL Tuning
Automatic Statistics Collection and Retention
Automatic Storage Management
Automatic Workload Repository
AWR
AWR snapshots
B
BFT
BigFile Tablespaces
btime_limit
Buffer Cache Advisor
C
cancel_tuning_task
CFS
Cluster File System
consecutive_occurrences
control_files
create_baseline
critical_operator
critical_value
Custom Workload
D
Data Dictionary Cache
Data Pump
Data Pump API
Database Buffer Cache
Database Configuration Assistant
Database Upgrade Assistant
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_block_size
db_cache_size
db_create_file_dest
db_create_online_log_dest_n
db_file_name_convert
db_keep_size
db_nk_cache_size
db_recovery_file_dest
db_recycle_cache_size
db_unique_name
dba_advisor_findings
dba_advisor_log
dba_advisor_rationale
dba_advisor_recommendations
dba_advisor_tasks
dba_alert_history
dba_data_files
dba_external_tables
dba_feature_usage_statistics
dba_high_water_mark_statistics
dba_hist_active_sess_history
dba_hist_baseline
dba_hist_bg_event_summary
dba_hist_buffer_pool_ statistics
dba_hist_buffer_pool_stat
dba_hist_buffer_pool_statistics
dba_hist_class_cache_transfer
dba_hist_cr_block_server
dba_hist_current_block_server
dba_hist_database_instance
dba_hist_datafile
dba_hist_db_cache_advice
dba_hist_dlm_misc
dba_hist_enqueue_stat
dba_hist_event_name
dba_hist_event_summary
dba_hist_filemetric_history
dba_hist_filestatxs
dba_hist_instance_recovery
dba_hist_java_pool_advice
dba_hist_latch
dba_hist_latch_children
dba_hist_latch_misses_summary
dba_hist_latch_name
dba_hist_latch_parent
dba_hist_librarycache
dba_hist_log
dba_hist_metric_name
dba_hist_mttr_target_advice
dba_hist_optimizer_env
dba_hist_osstat
dba_hist_osstat_name
dba_hist_parameter
dba_hist_parameter_name
dba_hist_pga_target_advice
dba_hist_pgastat
dba_hist_resource_limit
dba_hist_rowcache_summary
dba_hist_seg_stat
dba_hist_seg_stat_obj
dba_hist_service_name
dba_hist_service_stat
dba_hist_service_wait_class
dba_hist_sessmetric_history
dba_hist_sga
dba_hist_sgastat
dba_hist_shared_pool_advice
dba_hist_snap_error
dba_hist_snapshot
dba_hist_sql_plan
dba_hist_sql_summary
dba_hist_sql_workarea_hstgrm
|
dba_hist_sqlbind
dba_hist_sqlplan
dba_hist_sqlstat
dba_hist_sqltext
dba_hist_stat_name
dba_hist_sys_time_model
dba_hist_sysmetric_history
dba_hist_sysmetric_summary
dba_hist_sysstat
dba_hist_systat
dba_hist_system_event
dba_hist_tablespace_stat
dba_hist_tbspc_space_usage
dba_hist_tempfile
dba_hist_tempstatxs
dba_hist_thread
dba_hist_undostat
dba_hist_waitclassmet_history
dba_hist_waitstat
dba_hist_wr_control
dba_outstanding_alerts
dba_sql_profiles
dba_sqlset
dba_sqlset_binds
dba_sqlset_references
dba_sqlset_statements
dba_sqltune_binds
dba_sqltune_plans
dba_sqltune_statistics
dba_tablespace_groups
dba_tablespaces
dba_thresholds
dba_transaction_query
DBCA
dbms_advisor
dbms_aq
dbms_aqadm
dbms_aqelm
dbms_jobs
dbms_rowid
dbms_scheduler
dbms_server_alert
dbms_sqltune
dbms_workload_repository
DBUA
Direct Path API
DPAPI
dpexp
dpimp
DROP DATABASE
drop_tuning_task
E
EGA
emca
emctl
enable_db_access
Enterprise Grid Alliance
F
fast_start_mttr_target
Flash Recovery Area
Flashback query
Flashback Table
Flashback Transaction Query
Flashback Versions Query
G
gather_stats_job
GDK
Global Database Name
Globalization Development Kit
Grid computing
Grid SDK
GridControl
I
init.ora
initInstanceName.ora
instance_name
instance_type
interrupt_tuning_task
J
Java Pool
java_pool_size
L
Large Pool
large_pool_size
LGWR
Library Cache Advisor
log_archive_dest
log_archive_dest_n
log_archive_format
log_buffer
Logical Volume Managers
M
maintenance_ window_group
max_rollback_segment
Memory Monitor
Memory Monitor Light
metrics_id
MMNL
MMON
modify_snapshot_settings
O
object_name
object_type
observation_period
ODM
OEM
OMF
open_cursors
Oracle Data Mining
Oracle Enterprise Manager
Oracle Managed Files
Oracle Streams
Oracle System Identifier
Oracle Universal Installer
oraInst.sh
oraparam.ini
OUI
P
PGA
PGA Advisor
prerequisite.xml
prerequisite_results.xml
Private SQL Area
Program Global Area
R
Real Application Clusters
Redo Log Buffer
report_tuning_task_function
reset_tuning_task
root.sh
row_locking
Rule-based Optimizer |
S
Segment Advisor
serializable
set_sqlwkld_parameter
set_task_parameter
SGA
SGA Advisor
sga_max_size
sga_target
Shared Pool
shared_pool_size
SQL Access Advisor
SQL Cache
SQL Query Optimizer
SQL Trace
SQL Tuning Advisor
SQL Tuning Set
SQLAccess Advisor
standby_archive_dest
statistical_level
statistics_level
stats$bg_event_ summary
stats$bg_event_summary
stats$buffer_pool_ statistics
stats$buffer_pool_statistics
stats$filestatxs
stats$latch
stats$latch_children
stats$librarycache
stats$rowcache_ summary
stats$rowcache_summary
stats$sgastat
stats$sql_summary
stats$sysstat
stats$system_event
stats$waitstat
STATSPACK
Streams pool
streams_pool_size
Stripe and Mirror Everywhere
Symmetric MultiProcessor
SYSAUX tablespace
System Global Area
T
target_objects
Temporary Tablespace Groups
time_limit
time_window
timed_statistics
transaction_auditing
U
Undo Advisor
undo_retention
undo_suppress_errors
user_advisor_actions
user_advisor_recommendations
user_advisor_sqla_wk_stmts
user_external_locations
user_external_tables
V
v$active_sess_hist
v$active_session_history
v$asm_alias
v$asm_client
v$asm_disk
v$asm_diskgroup
v$asm_file
v$asm_operation
v$asm_template
v$database
v$event_histogram
v$event_name
v$osstat
v$parameter
v$segment_statistics
v$session
v$session_longops
v$session_wait
v$session_wait_history
v$sessstat
v$sesstat
v$sql
v$sqlarea
v$sqlbinds
v$sys_time_model
v$sysaux_occupants
v$sysmetric
v$sysmetric_history
v$sysstat
v$tablespace
v$transportable_platform
v$undostat
v$waitclassmetric_history
W
warning_operator
warning_value
wksys.move_wk
Workload Repository
wrh$_active_session_history
wrh$_active_session_history_bl
wrh$_bg_event_ summary
wrh$_bg_event_summary
wrh$_buffer_pool_ statistics
wrh$_buffer_pool_statistics
wrh$_class_cache_transfer
wrh$_class_cache_transfer_bl
wrh$_cr_block_sender
wrh$_current_block_server
wrh$_datafile
wrh$_db_cache_advice
wrh$_db_cache_advice_bl
wrh$_dlm_misc
wrh$_dlm_misc_bl
wrh$_enqueue_stat
wrh$_event_name
wrh$_filemetric_history
wrh$_filestatxs
wrh$_filestatxs_bl
wrh$_instance_recovery
wrh$_java_pool_advice
wrh$_latch
wrh$_latch_bl
wrh$_latch_children
wrh$_latch_children_bl
wrh$_latch_misses_summary
wrh$_latch_misses_summary_bl
wrh$_latch_name
wrh$_latch_parent
wrh$_latch_parent_bl
wrh$_librarycache
wrh$_log |
wrh$_metric_name
wrh$_mttr_target_advice
wrh$_optimizer_env
wrh$_osstat
wrh$_osstat_bl
wrh$_osstat_name
wrh$_parameter
wrh$_parameter_bl
wrh$_parameter_name
wrh$_pga_target_advice
wrh$_pgastat
wrh$_resource_limit
wrh$_rowcache_ summary
wrh$_rowcache_summary
wrh$_rowcache_summary_bl
wrh$_seg_stat
wrh$_seg_stat_bl
wrh$_seg_stat_obj
wrh$_service_name
wrh$_service_stat
wrh$_service_stat_bl
wrh$_service_wait_class
wrh$_service_wait_class_bl
wrh$_sessmetric_history
wrh$_sga
wrh$_sgastat
wrh$_sgastat_bl
wrh$_shared_pool_advice
wrh$_sql_plan
wrh$_sql_summary
wrh$_sql_workarea_histogram
wrh$_sqlbind
wrh$_sqlbind_bl
wrh$_sqlstat
wrh$_sqlstat_bl
wrh$_sqltext
wrh$_stat_name
wrh$_sys_time_model
wrh$_sys_time_model_bl
wrh$_sysmetric_history
wrh$_sysmetric_summary
wrh$_sysstat
wrh$_sysstat_bl
wrh$_system_event
wrh$_system_event_bl
wrh$_tablespace_space_usage
wrh$_tablespace_stat
wrh$_tablespace_stat_bl
wrh$_tempfile
wrh$_tempstatxs
wrh$_thread
wrh$_undostat
wrh$_waitclassmetric_history
wrh$_waitstat
wrh$_waitstat_bl
wrh$active_session_history
wri$_adv_actions
wri$_adv_def_parameters
wri$_adv_definitions
wri$_adv_directives
wri$_adv_findings
wri$_adv_journal
wri$_adv_message_groups
wri$_adv_objects
wri$_adv_parameters
wri$_adv_rec_actions
wri$_adv_recommendations
wri$_adv_sqla_map
wri$_adv_sqla_stmts
wri$_adv_sqla_tmp
wri$_adv_sqlt_binds
wri$_adv_sqlt_plans
wri$_adv_sqlt_rtn_plan
wri$_adv_sqlt_statistics
wri$_adv_sqlw_colvol
wri$_adv_sqlw_stmts
wri$_adv_sqlw_sum
wri$_adv_sqlw_tables
wri$_adv_sqlw_tabvol
wri$_adv_tasks
wri$_adv_usage
wri$_aggregation_enabled
wri$_alert_history
wri$_alert_outstanding
wri$_alert_threshold
wri$_alert_threshold_log
wri$_dbu_feature_metadata
wri$_dbu_feature_usage
wri$_dbu_high_water_mark
wri$_dbu_hwm_metadata
wri$_dbu_usage_sample
wri$_optstat_aux_history
wri$_optstat_histgrm_history
wri$_optstat_histhead_history
wri$_optstat_ind_history
wri$_optstat_opr
wri$_optstat_tab_history
wri$_sch_control
wri$_sch_votes
wri$_sqlset_binds
wri$_sqlset_definitions
wri$_sqlset_references
wri$_sqlset_statements
wri$_tracing_enabled
wrm$_baseline
wrm$_database_instance
wrm$_snap_error
wrm$_snapshot
wrm$_wr_control
wrm$snapshot |
Oracle10g automation
for Oracle 10g
Oracle automatic
SQL tuning
Oracle 10g ASM, ADDM
, AWR, ASSM.
Oracle10g Automatic storage management book
oracle
automatic database management
Oracle
automatic performance diagnosis
automatic performance tuning
|
