ISBN 0-9745993-6-0 ISBN 13 978-0974599366 Library of Congress Number: 2004096475 296 pages: Perfect bind - 9x7 Publication Date: December 2004 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 Reader Comments Table of Contents   Errata           Get the Easy Oracle Pack Six books for $59.95 - A $118.00 value Easy Oracle Jumpstart $27.95 Easy Oracle PHP $27.95 Oracle DBA Made Simple (eBook) $19.95 Easy Oracle SQL $16.95 Oracle 10g DBA Reference Poster $8.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.   * 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. Book 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