Normal view MARC view ISBD view

Secrets of the Oracle Database [electronic resource] /by Norbert Debes.

by Debes, Norbert [author.]; SpringerLink (Online service).
Material type: materialTypeLabelBookPublisher: Berkeley, CA : Apress, 2009.Description: 450 p. online resource.ISBN: 9781430219538.Subject(s): Computer science | Data structures (Computer science) | Computer Science | Data Structures, Cryptology and Information TheoryDDC classification: 005.74 Online resources: Click here to access online
Contents:
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.
In: Springer eBooksSummary: 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.
Tags from this library: No tags from this library for this title. Add tag(s)
Log in to add tags.
    average rating: 0.0 (0 votes)
Item type Current location Call number Status Date due Barcode
MAIN LIBRARY
QA76.9.D35 (Browse shelf) Available

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.

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.

There are no comments for this item.

Log in to your account to post a comment.
@ Jomo Kenyatta University Of Agriculture and Technology Library

Powered by Koha