Vai al contenuto principale della pagina
Autore: | Sims April C |
Titolo: | Oracle database 11g-underground advice for database administrators [[electronic resource] ] : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims |
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.: | 9910784914703321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |