Secrets of the Oracle Database

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.

Initialization Parameters.- Partially Documented Parameters.- Hidden Initialization Parameters.- Data Dictionary Base Tables.- to Data Dictionary Base Tables.- IND$, V$OBJECT_USAGE, and Index Monitoring.- Events.- 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.- X$ Fixed Tables.- to X$ Fixed Tables.- X$BH and Latch Contention.- X$KSLED and Enhanced Session Wait Data.- X$KFFXP and ASM Metadata.- SQL Statements.- Alter Session/System Set Events.- Alter Session Set Current_Schema.- Alter User Identified By Values.- Select For Update Skip Locked.- Supplied PL/SQL Packages.- DBMS_Backup_Restore.- DBMS_IJOB.- DBMS_Scheduler.- DBMS_System.- DBMS_Utility.- Application Development.- Perl DBI and DBD::Oracle.- Application Instrumentation and End-to-End Tracing.- Performance.- Extended SQL Trace File Format Reference.- Statspack.- Integrating Extended SQL Trace and AWR.- ESQLTRCPROF Extended SQL Trace Profiler.- The MERITS Performance Optimization Method.- Oracle Net.- 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.- Real Application Clusters.- Session Disconnection, Load Rebalancing, and TAF.- Removing the RAC Option Without Reinstalling.- Utilities.- OERR.- Recovery Manager Pipe Interface.- ORADEBUG SQL*Plus Command.