Secrets of the Oracle Database
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 administra...
Κύριος συγγραφέας: | |
---|---|
Συγγραφή απο Οργανισμό/Αρχή: | |
Μορφή: | Ηλεκτρονική πηγή Ηλ. βιβλίο |
Γλώσσα: | English |
Έκδοση: |
Berkeley, CA :
Apress,
2009.
|
Θέματα: | |
Διαθέσιμο Online: | Full Text via HEAL-Link |
Πίνακας περιεχομένων:
- 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.