Secrets of the Oracle Database (Expert's Voice in Oracle)

Secrets of the Oracle Database (Expert's Voice in Oracle)

Language: English

Pages: 450

ISBN: 1430219521

Format: PDF / Kindle (mobi) / ePub


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 Oracle Database 9 through Oracle Database 11, 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 on your day-to-day work with Oracle.

Table of Contents

  1. Partially Documented Parameters
  2. Hidden Initialization Parameters
  3. Introduction to Data Dictionary Base Tables
  4. IND$, V$OBJECT_USAGE, and Index Monitoring
  5. Event 10027 and Deadlock Diagnosis
  6. Event 10046 and Extended SQL Trace
  7. Event 10053 and the Cost Based Optimizer
  8. Event 10079 and Oracle Net Packet Contents
  9. Introduction to X$ Fixed Tables
  10. X$BH and Latch Contention
  11. X$KSLED and Enhanced Session Wait Data
  12. X$KFFXP and ASM Metadata
  13. ALTER SESSION/SYSTEM SET EVENTS
  14. ALTER SESSION SET CURRENT_SCHEMA
  15. ALTER USER IDENTIFIED BY VALUES
  16. SELECT FOR UPDATE SKIP LOCKED
  17. DBMS_BACKUP_RESTORE
  18. DBMS_IJOB
  19. DBMS_SCHEDULER
  20. DBMS_SYSTEM
  21. DBMS_UTILITY
  22. Perl DBI and DBD::Oracle
  23. Application Instrumentation and End-to-End Tracing
  24. Extended SQL Trace File Format Reference
  25. Statspack
  26. Integrating Extended SQL Trace and AWR
  27. ESQLTRCPROF Extended SQL Trace Profiler
  28. The MERITS Performance Optimization Method
  29. TNS Listener IP Address Binding and IP=FIRST
  30. TNS Listener TCP/IP Valid Node Checking
  31. Local Naming Parameter ENABLE=BROKEN
  32. Default Host Name in Oracle Net Configurations
  33. Session Disconnection, Load Rebalancing, and TAF
  34. Removing the RAC Option Without Reinstalling
  35. OERR
  36. Recovery Manager Pipe Interface
  37. ORADEBUG SQL*Plus Command

Mastering Cloud Computing: Foundations and Applications Programming

Google Secrets

Introduction to the Design and Analysis of Algorithms (2nd Edition)

Python Machine Learning

Computer Networking: A Top-Down Approach (5th Edition)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

or operators may be audited to the UNIX operating system’s syslog daemon log files owned by the UNIX user root. This prevents privileged database users from removing audit records that contain a log of their activities. The default setting is to audit CONNECT, STARTUP, and SHUTDOWN with SYSDBA or SYSOPER privileges to files owned by the ORACLE software owner, while not auditing SQL, PL/SQL statements, and other actions with these privileges or other privileges, such as the role DBA, at all. In

ARRAY1_DISK2, ARRAY2_DISK1, and ARRAY2_DISK2 to create three more files. On UNIX, the dd command is available to accomplish the same task as asmtool -create. Following is an example for creating a file with a size of 512 MB: $ dd if=/dev/zero bs=1048576 count=512 of=ARRAY1_DISK1 The above dd command reads 512 blocks with a size of 1 MB each from the device special file /dev/zero. Since reading from /dev/zero returns nothing but binary zeros, the resulting file is zeroed out as required by ASM.

. . . . . . . . . . . . . . . . . . . . . . . 165 Recovery Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Disaster Recovery Case Study with Tivoli Data Protection for Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 Source Code Depot . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172 ■CHAPTER 18 DBMS_IJOB . . . . . . . . . . . . . . . . . . . . . . .

EVENTS 'immediate trace name systemstate level 10'; Session altered. The header of a system state dump looks as follows: SYSTEM STATE -----------System global information: processes: base 6ED426BC, size 50, cleanup 6ED47FF4 allocation: free sessions 6ED60D60, free calls 00000000 control alloc errors: 0 (process), 0 (session), 0 (call) PMON latch cleanup depth: 0 seconds since PMON's last scan for dead processes: 21 system statistics: 166 logons cumulative 18 logons current 1082648 opened cursors

. . . . . . . . . . . . . . . . . . . 442 Source Code Depot . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 443 ■CHAPTER 34 Removing the RAC Option Without Reinstalling . . . . . . . . 445 Linking ORACLE Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 445 Case Study . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 447 Simulating Voting Disk Failure . . . . . . . . . . . . .

Download sample

Download