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-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)
     
Key Features About the Author 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


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.

 
Key Features

* 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

 

   

 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