Secrets of the Oracle Database

Part 1. Initialization Parameters

1. Partially Documented Parameters
Norbert Debes

2. Hidden Initialization Parameters
Norbert Debes

Part 2. Data Dictionary Base Tables

3. Introduction to Data Dictionary Base Tables
Norbert Debes

4. IND$, V$OBJECT_USAGE, and Index Monitoring
Norbert Debes

Part 3. Events

5. Event 10027 and Deadlock Diagnosis
Norbert Debes

6. Event 10046 and Extended SQL Trace
Norbert Debes

7. Event 10053 and the Cost Based Optimizer
Norbert Debes

8. Event 10079 and Oracle Net Packet Contents
Norbert Debes

Part 4. X$ Fixed Tables

9. Introduction to X$ Fixed Tables
Norbert Debes

10. X$BH and Latch Contention
Norbert Debes

11. X$KSLED and Enhanced Session Wait Data
Norbert Debes

12. X$KFFXP and ASM Metadata
Norbert Debes

Part 5. SQL Statements

13. Alter Session/System Set Events
Norbert Debes

14. Alter Session Set Current_Schema
Norbert Debes

15. Alter User Identified By Values
Norbert Debes

16. Select For Update Skip Locked
Norbert Debes

Part 6. Supplied PL/SQL Packages

17. DBMS_Backup_Restore
Norbert Debes

18. DBMS_IJOB
Norbert Debes

19. DBMS_Scheduler
Norbert Debes

20. DBMS_System
Norbert Debes

21. DBMS_Utility
Norbert Debes

Part 7. Application Development

22. Perl DBI and DBD::Oracle
Norbert Debes

23. Application Instrumentation and End-to-End Tracing
Norbert Debes

Part 8. Performance

24. Extended SQL Trace File Format Reference
Norbert Debes

25. Statspack
Norbert Debes

26. Integrating Extended SQL Trace and AWR
Norbert Debes

27. ESQLTRCPROF Extended SQL Trace Profiler
Norbert Debes

28. The MERITS Performance Optimization Method
Norbert Debes

Part 9. Oracle Net

29. TNS Listener IP Address Binding and IP=FIRST
Norbert Debes

30. TNS Listener TCP/IP Valid Node Checking
Norbert Debes

31. Local Naming Parameter ENABLE=BROKEN
Norbert Debes

32. Default Host Name in Oracle Net Configurations
Norbert Debes

Part 10. Real Application Clusters

33. Session Disconnection, Load Rebalancing, and TAF
Norbert Debes

34. Removing the RAC Option Without Reinstalling
Norbert Debes

Part 11. Utilities

35. OERR
Norbert Debes

36. Recovery Manager Pipe Interface
Norbert Debes

37. ORADEBUG SQL*Plus Command
Norbert Debes

Keywords: Computer Science, Data Structures, Cryptology and Information Theory