Poetry Madness
 
 

Recently Viewed clear list


Q&A | February 27, 2014

Rene Denfeld: IMG Powell’s Q&A: Rene Denfeld



Describe your latest book. The Enchanted is a story narrated by a man on death row. The novel was inspired by my work as a death penalty... Continue »
  1. $18.19 Sale Hardcover add to wish list

    The Enchanted

    Rene Denfeld 9780062285508

spacer
Qualifying orders ship free.
$59.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Database- Design

More copies of this ISBN

Secrets of the Oracle Database

by

Secrets of the Oracle Database Cover

 

Synopses & Reviews

Publisher Comments:

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 Oracle9i Database through Oracle Database 11g, 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 in your day-to-day work with Oracle.

What you'll learn Take advantage of Oracle's built-in Perl DBI distribution to write applications for monitoring, benchmarking, data extraction, and more. Interpret the undocumented, extended trace file format to pinpoint performance problems that TKPROF reports overlook and obscure. Get the most out of Statspack by using undocumented report formatting options, accessing its scarcely-documented repository, and integrating with SQL Trace. Take control of your instance through the ill-documented ORADEBUG command, enabling you to control processes, trace SQL statements, dump process state, monitor wait events and the call stack, and much more. Leverage undocumented features in Oracle's built-in scheduler to better automate your workload. Take full advantage of Transparent Application Failover and Cluster Database Services in a Real Application Cluster environment.

Who is this book for?

Secrets of the Oracle Database is written for database administrators and developers well past the beginner level who desire to take full advantage of the power the Oracle platform has to offer. The book is by no means an introductory book. Readers should already be familiar and comfortable with SQL and PL/SQL, and should have a good grounding in Oracle database architecture.

Synopsis:

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 Partially Documented Parameters Hidden Initialization Parameters Introduction to Data Dictionary Base Tables IND$, V$OBJECT_USAGE, and Index Monitoring 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 Introduction to X$ Fixed Tables X$BH and Latch Contention X$KSLED and Enhanced Session Wait Data X$KFFXP and ASM Metadata ALTER SESSION/SYSTEM SET EVENTS ALTER SESSION SET CURRENT_SCHEMA ALTER USER IDENTIFIED BY VALUES SELECT FOR UPDATE SKIP LOCKED DBMS_BACKUP_RESTORE DBMS_IJOB DBMS_SCHEDULER DBMS_SYSTEM DBMS_UTILITY Perl DBI and DBD: : Oracle Application Instrumentation and End-to-End Tracing Extended SQL Trace File Format Reference Statspack Integrating Extended SQL Trace and AWR ESQLTRCPROF Extended SQL Trace Profiler The MERITS Performance Optimization Method 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 Session Disconnection, Load Rebalancing, and TAF Removing the RAC Option Without Reinstalling OERR Recovery Manager Pipe Interface ORADEBUG SQL*Plus Command

Synopsis:

Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. It plays to the almost universal desire of Oracle database administrators and developers to give themselves an a oeedgea, to learn some technique to make their job easier, and to make themselves look experienced in seasoned in the eyes of their colleagues.

Most books of the a oetips and tricksa style are written on demanding, publisher-driven schedules and do little more than regurgitate techniques that one can easily find in vendor documentation. Norbert Debesa (TM) book is different. It is the culmination of many years of experience a many as an Oracle insider a over which the author collected, researched, tested, and refined his knowledge of under- and undocumented Oracle features. This book was many years a not mere months a in the making.

What author Norbert Debes brings to light is much more than a collection of gee-whiz gimmicks. Instead, Norbert shines the light of day on features of solid value, that knowledgeable Oracle Database professionals can apply to reliably and repeatedly solve performance problems, master and automate difficult administrative tasks, and troubleshoot hard problems. What Norbert writes is accurate, well-tested, well-proven by clear examples. The result is a book that holds its value that will leave readers feeling good about spending their money.

Product Details

ISBN:
9781430219521
Author:
Debes, Norbert
Publisher:
Apress
Foreword by:
Harrison, Guy
Foreword:
Harrison, Guy
Author:
Debes, Nobert
Subject:
Software Development & Engineering - General
Subject:
Database Management - Oracle
Subject:
Database design
Copyright:
Edition Description:
New
Series:
Expert's Voice in Oracle
Publication Date:
20090631
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
515
Dimensions:
9.28x7.02x1.08 in. 1.44 lbs.

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Secrets of the Oracle Database New Trade Paper
0 stars - 0 reviews
$59.99 In Stock
Product details 515 pages Apress - English 9781430219521 Reviews:
"Synopsis" by , 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 Partially Documented Parameters Hidden Initialization Parameters Introduction to Data Dictionary Base Tables IND$, V$OBJECT_USAGE, and Index Monitoring 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 Introduction to X$ Fixed Tables X$BH and Latch Contention X$KSLED and Enhanced Session Wait Data X$KFFXP and ASM Metadata ALTER SESSION/SYSTEM SET EVENTS ALTER SESSION SET CURRENT_SCHEMA ALTER USER IDENTIFIED BY VALUES SELECT FOR UPDATE SKIP LOCKED DBMS_BACKUP_RESTORE DBMS_IJOB DBMS_SCHEDULER DBMS_SYSTEM DBMS_UTILITY Perl DBI and DBD: : Oracle Application Instrumentation and End-to-End Tracing Extended SQL Trace File Format Reference Statspack Integrating Extended SQL Trace and AWR ESQLTRCPROF Extended SQL Trace Profiler The MERITS Performance Optimization Method 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 Session Disconnection, Load Rebalancing, and TAF Removing the RAC Option Without Reinstalling OERR Recovery Manager Pipe Interface ORADEBUG SQL*Plus Command

"Synopsis" by , Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. It plays to the almost universal desire of Oracle database administrators and developers to give themselves an a oeedgea, to learn some technique to make their job easier, and to make themselves look experienced in seasoned in the eyes of their colleagues.

Most books of the a oetips and tricksa style are written on demanding, publisher-driven schedules and do little more than regurgitate techniques that one can easily find in vendor documentation. Norbert Debesa (TM) book is different. It is the culmination of many years of experience a many as an Oracle insider a over which the author collected, researched, tested, and refined his knowledge of under- and undocumented Oracle features. This book was many years a not mere months a in the making.

What author Norbert Debes brings to light is much more than a collection of gee-whiz gimmicks. Instead, Norbert shines the light of day on features of solid value, that knowledgeable Oracle Database professionals can apply to reliably and repeatedly solve performance problems, master and automate difficult administrative tasks, and troubleshoot hard problems. What Norbert writes is accurate, well-tested, well-proven by clear examples. The result is a book that holds its value that will leave readers feeling good about spending their money.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.