| |
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910821146003321 |
|
|
Autore |
Sims April C |
|
|
Titolo |
Oracle database 11g-underground advice for database administrators : a real-world DBA survival guide for Oracle 11g database implementations / / April C. Sims |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Birmingham, U.K., : Packt Pub., 2010 |
|
|
|
|
|
|
|
ISBN |
|
1-282-55746-7 |
9786612557460 |
1-84968-001-9 |
|
|
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (348 p.) |
|
|
|
|
|
|
Collana |
|
From technologies to solutions |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Database management |
SQL*PLUS (Computer program language) |
Relational databases |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
| |