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

Format:

Book

Author/Creator:

Sims, April C.

Series:

From technologies to solutions

Language:

English

Subjects (All):

Oracle (Computer file).

Database management.

SQL*PLUS (Computer program language).

Relational databases.

Physical Description:

1 online resource (348 p.)

Edition:

1st edition

Place of Publication:

Birmingham, U.K. : Packt Pub., 2010.

Language Note:

English

System Details:

text file

Biography/History:

Sims April: April Sims is currently the Database Administrator at Southern Utah University and an Oracle Certified Professional: 8i, 9i, and 10g with a master's degree in Business Administration from the University of Texas at Dallas. Involved as a volunteer with the Independent Oracle Users Group for over 7 years, April is currently a Contributing Editor for the IOUG "SELECT" Journal. April is an annual presenter at Oracle OpenWorld, IOUG COLLABORATE, and numerous regional Oracle-related conferences.

Summary:

A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook

Contents:

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

Notes:

Includes index.

ISBN:

9786612557460

9781282557468

1282557467

9781849680011

1849680019

OCLC:

796383967