Content: Oracle Database 11g Underground Advice for Database Administrators; Oracle Database 11g-Underground Advice for Database Administrators; Credits; About the author; About the reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. When to Step Away from the Keyboard; Protecting and defending; Choosing your tools; Graphic-based, command-line Oracle tools and usage; Staying away from dinosaurs; Insisting on help; What does a DBA do all day? Prioritizing tasks-daily, weekly, monthly, quarterly, or yearly; ; Daily; Weekly; Monthly; Quarterly; Yearly; SLAs: Why isn't the database down anymore?; Avoiding major blunders; Summary; 2. Maintaining Oracle Standards; Adapting to constant change; ; Database concepts; Multiple ORACLE_HOME(s); Keeping the environment clean; Oracle's Optimal Flexible Architecture (OFA); 11g differences in the OFA standard; XWINDOWS and GUI displays; Automating day-to-day tasks; DBMS_SCHEDULER; OS cron utility executing a scheduled task on a Unix server; OEM Console plus the Intelligent Agent. 11g Diagnosability FrameworkAdvisors and checkers; Missing temp file resolution; Environmental variables and scripting; Guidelines for scripting; Separating the configuration file; Host commands relative location; Separating the variable part of the script into its own configuration file; Don't hardcode values; reference a configuration file and password file at runtime; Putting variables at the top of the script with curly braces; Moving functions to a centralized file to be reused; Validating the use of the script; Using SQL to generate code; Helpful Unix commands. Reducing operating system differences with common toolsConfiguration management, release management, and change control; Configuration management; Using OCM in disconnected mode with masking; Mass deployment utility; Release management; DBA issues with patching; Applying a patch without integrating MOS with OCM; Using the new patch plan functionality with OCM installed and uploaded to MOS; Change control; Where, when, and who to call for help; My Oracle Support; Documentation library; Summary; 3. Tracking the Bits and Bytes; Dump block; Demonstration of data travel path. Location of trace filesRunning dump block SQL statements; Identifying files and blocks; ; ; Legend for Trace Files:; Tracking the SCN through trace files; Single Row Insert; Commit of a single row insert; Single row update and corresponding undo block; Commit of a single row update; Oracle's RDBMS Log Miner utility; Turn on archivelog mode; Add supplemental logging; Identification key logging; Table-level supplemental logging; Flash(back) Recovery Area (FRA); Automatic Undo Management (AUM); Identifying data in undo segments by flashing back to timestamp; When to use Log Miner.
Abstract: A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook