Oracle database 11g-underground advice for database administrators : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims

• Autore: Sims April C
• Pubblicazione: Birmingham, U.K., : Packt Pub., 2010
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (348 p.)
• Disciplina: 005.7575
• Soggetto topico: Database management; SQL*PLUS (Computer program language); Relational databases
• Note generali: Includes index.
• Nota di contenuto: Cover; Copyright; Credits; About the author; About the reviewers; Table of Contents; Preface; Chapter 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; SLA's: Why isn't the database down anymore?; Avoiding major blunders; Summary; Chapter 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 Framework; Advisors and checkers; Missing temp file resolution; Environmental variables and scripting; Guidelines for scripting; Separating the configuration file; Separate 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; Validate the use of the script; Using SQL to generate code; Helpful Unix commands; Reducing operating system differences with common tools; Configuration 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 MOSChange control; Where, when, and who to call for help; My Oracle Support; Documentation library; Summary; Chapter 3: Tracking the Bits and Bytes; Dump block; Demonstration of data travel path; Location of trace files; Running dump block SQL statements; Identifying files and blocks; Tracking the SCN through trace files; 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; Identifying the data needed to restore; SCN, timestamp, or log sequence number; Pseudo column ORA_ROWSCN; Flashback Transaction Query and Backout; Enabling flashback logs; Flashback Table; Flashback Transaction Query with pseudo columns; Flashback Transaction Backout; Using strings to remove binary components; Summary; Chapter 4: Achieving Maximum Uptime; Maximum Availability Architecture (MAA); Downtime-planned or unplanned; MAA with commodity hardware: Case study ; Optimizing Oracle Database High Availability
• Sommario/riassunto: A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook
• Titolo autorizzato: Oracle database 11g-underground advice for database administrators
• ISBN: 1-282-55746-7; 9786612557460; 1-84968-001-9
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910821146003321
• Lo trovi qui: Univ. Federico II