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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Debes, Norbert (Autor)
Autor Corporativo: SpringerLink (Online service)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress : Imprint: Apress, 2009.
Edición:1st ed. 2009.
Temas:
Database management.
Microprogramming .
Database Management.
Control Structures and Microprogramming.
Acceso en línea:Texto Completo
Tabla de Contenidos:
  • 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.

Ejemplares similares