中文名: Oracle Database的奧秘
原名: Secrets of the Oracle Database
作者: Norbert Debes
圖書分類: 軟件
資源格式: PDF
版本: 文字版
出版社: Apress
書號: ISBN: 9781430219521
發行時間: 2009年06月03日
地區: 美國
語言: 英文
簡介:

內容簡介
Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.
Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.
作者簡介
Norbert Debes has more than 13 years experience as an Oracle database administrator. He holds a master’s degree in computer science from the University of Erlangen, Germany, and is an Oracle8, Oracle8i, and Oracle9i certified professional Oracle database administrator. For over 6 years, he held different positions and technical roles at Oracle Germany. He was a team leader in Oracle Support Services, and a technical account manager in Strategic Alliances. In his last role at Oracle, Norbert was responsible for promoting Real Application Clusters on a technical level. During his tenure, he contributed to the Oracle9i SQL Reference, the Real Application Clusters manual set, and to various Real Application Clusters training materials.
Right from the beginning of his quest in the Oracle database management system, Norbert always wanted to know exactly how things worked. He would not be satisfied with superficial explanations, but demanded evidence. His passion to dig deeper served him well in acquiring extensive knowledge of the Oracle database, and occasionally makes him a restless researcher who often ends up working from dusk until dawn when captured by “the flow.”
In his spare time, Norbert likes to hike, snowboard, play basketball, and read nonfiction on topics such as the emotional brain. Furthermore, he is a passionate analog and digital photographer. Having been intrigued by the vibrancy of stereoscopic (i.e., three-dimensional) capture for 20 years, he rejoices in his recent acquisition of a stereo camera.
內容截圖

目錄:
Partially Documented Parameters
Hidden Initialization Parameters
Introduction to Data Dictionary Base Tables
IND$, V$OBJECT_USAGE, and Index Monitoring
Event 10027 and Deadlock Diagnosis
Event 10046 and Extended SQL Trace
Event 10053 and the Cost Based Optimizer
Event 10079 and Oracle Net Packet Contents
Introduction to X$ Fixed Tables
X$BH and Latch Contention
X$KSLED and Enhanced Session Wait Data
X$KFFXP and ASM Metadata
ALTER SESSION/SYSTEM SET EVENTS
ALTER SESSION SET CURRENT_SCHEMA
ALTER USER IDENTIFIED BY VALUES
SELECT FOR UPDATE SKIP LOCKED
DBMS_BACKUP_RESTORE
DBMS_IJOB
DBMS_SCHEDULER
DBMS_SYSTEM
DBMS_UTILITY
Perl DBI and DBD::Oracle
Application Instrumentation and End-to-End Tracing
Extended SQL Trace File Format Reference
Statspack
Integrating Extended SQL Trace and AWR
ESQLTRCPROF Extended SQL Trace Profiler
The MERITS Performance Optimization Method
TNS Listener IP Address Binding and IP=FIRST
TNS Listener TCP/IP Valid Node Checking
Local Naming Parameter ENABLE=BROKEN
Default Host Name in Oracle Net Configurations
Session Disconnection, Load Rebalancing, and TAF
Removing the RAC Option Without Reinstalling
OERR
Recovery Manager Pipe Interface
ORADEBUG SQL*Plus Command