Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

ISBN
0-9727513-5-1
ISBN 13
978-0972751353
Library of Congress Number: 2003105335
260 pages:
Perfect Bind 9x7
PD 603
Shelving: Databases/Oracle Oracle In-Focus Series # 6

  Oracle Utilities
Using Hidden Programs, Import/Export, SQL Loader, Oradebug, Dbverify, Tkprof and More

by Dave Moore     

Retail Price $27.95 /  £17.95 

  Only $19.95   
(30% off)
     
Key Features About the Author Table of Contents
Index Reader Comments Errata
     
Get the Oracle Tuning Library
Save $100 - All four books for only $118.95 
Oracle Tuning: The Definitive Reference 3rd Edition $69.95
Advanced Oracle SQL Tuning: The Definitive Reference $59.95
Oracle Performance Troubleshooting 2nd Ed $34.95
Oracle Tuning Powerscripts $37.95


Written by one of the world's most widely-read DBAs and architect of the famous DBXray(tm) product by BMC Software, Dave Moore targets his substantial knowledge of Oracle internals at the Oracle supplied utilities. Intended for Senior Oracle professionals, these powerful utilities are hidden deep inside Oracle and Dave Moore can show you how to unleash the hidden power of these Oracle utilities.

Targeted at seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases, this book provides help on how to use the utilities provided with the Oracle database.  Explained are secrets for database migration with export/import and SQL*Loader utilities as well as OS utilities such as dbverify, orastack, and orakill.  Tuning utilities including tkprof and dbms_debug are described in detail in addition to monitoring utilities including dbms_alert and dbms_xplan. Also covered in the book are network and developer utilities.

Deep inside the operating system executables there are many utilities are at the fingertips of Oracle professionals, but until now, there has been no advice on how to use these utilities. From tnsping.exe to dbv.exe to wrap.exe, Dave Moore describes each utility and has working examples in the online code depot. Your time savings from a single script is worth the price of this great book.

This book is not for beginners. Targeted at senior Oracle DBAs and developers, this book should only be purchased by seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases.

 

 
Key Features

* Shows numerous undocumented utilities for Oracle experts.

* Provides advanced Oracle DBA utilities tricks.

* Explains secrets for database migration with export/import and SQL Loader utilities.

* Explores OS utilities such as dbverify, orastack and maxmem.

* Presents tuning utilities including tkprof and dbms_profiler.

* Explains monitoring utilities including dbms_alert, dbverify, dbms_xplan.

* Discusses utilities for developers including wrap, sqlj, dbms_debug and loadjava.

* Describes Network utilities including tnsping, trcroute and tnslsnr.

About the Author:

Dave Moore

  Dave Moore is a product architect at BMC Software, a leading supplier of database software tools. As the inventor of BMC's DBXray product, he has developed many products that assist Oracle DBAs and Developers. He has experience as a developer specializing in Oracle, Java and PL/SQL. He has presented at Oracle OpenWorld and is a frequent contributor to Oracle Professional and DBAZine.com.

Table of Contents:
 

Preface

 

Chapter 1

 

Scripts Used in this Book

Environment Setup and Configuration

Database and Platforms

Java

JDBC Driver

 

Chapter 2

 

Oracle Utilities Defined

Definition of a Utility

What is a Hidden Utility?

Utility Locations

Methods of Discovery

Package Discovery

Binary Discovery

Other Things worth Discovering

Package Utilities

Table 2.1- The supplied Oracle packages.

UNIX Utilities and Shell Scripts

Windows Executables

Table 2.3 - Utilities that are only present on the Windows platform.

Summary

 

Chapter 3

 

Utilities for General Administration

Terminating Threads with orakill

Tips for using orakill

Viewing Errors with the oerr Utility

How oerr Works

oerr on Windows

Creating Custom Message Files

oerr Alternatives

Memory Utilities

Utilities for Starting and Stopping Databases

Auto Start on HP-UX and Solaris

Auto Start on AIX

Starting and Stopping on Windows

oraenv and coraenv Utilities

Using orapwd to Connect Remotely as SYSDBA

Summary

 

Chapter 4

 

Data Copy Utilities

Export

Export Modes

Export Options       

Parameter Files

Exporting Data Subsets

Maximizing Export Performance

Import

Import Options

Maximizing Import Performance

The SQL*Plus copy Utility

SQL*Loader

The Control File

The Log File

SQL*Loader Options

Maximizing SQL*Loader Performance

External Tables in 9i

Summary

 

Chapter 5

 

Monitoring and Tuning

The dbms_alert Utility

How It Works

The dbms_alert_info Table

dbms_alert Methods

Practical Uses for dbms_alert

The utl_smtp Utility

The OEMCTL Utility

OMS Event Handlers

Modifying the Event Handler

The dbms_xplan Utility

The dbv  Utility (Database Verify)

dbv  Command Line Options

Executing dbv and Interpreting the Output

Executing dbv against a Particular Segment

Automating dbv

Alternative Block Checking Mechanisms

Handling Corruption

The dbms_repair Utility

Configuring the Environment

Finding Corrupt Blocks

Repairing Corrupt Blocks

Rebuilding Freelists

Summary

Chapter 6

 

Tracing Utilities

Formatting Trace Files with tkprof

Why, When tkprof?

Analyzing tkprof  Results

tkprof  Command Line Options

Best Practices for Using tkprof

Simple Tracing With autotrace

Low Level Tracing With oradebug

ORADEBUG Session Trace

ORADEBUG Dumps

The Oracle Trace Utility

Starting Oracle Trace

Stopping Oracle Trace

Reporting Tracing Results

Loading Trace Data into the Database

Deleting Trace Data

Trace Analyzer

How it Works

Executing Trace Analyzer

Better than tkprof?

Summary

 

Chapter 7

 

Networking Utilities

Managing Listeners with lsnrctl

Testing Connectivity

Tracing Listener Connections

Tracking Network Paths and Performance

Summary

 

Chapter 8

 

Utilities for Oracle Developers

PL/SQL Wrap Utility for Encryption

Best Practices for Using Wrap

The dbms_profiler Utility

Installation

Starting a Profiling Session

Stopping a Profiling Session

Working with Captured Profiler Data

Useful Scripts

Best Practices for Using dbms_profiler  Everywhere

The dbms_debug Utility

Initializing a Debug Session

Setting a Breakpoint

Synchronizing

Viewing and Modifying Variables

The SQLJ Utility

Conclusion

Loading and Dropping Java Objects

Loading PL/SQL Server Pages

Executing the PSP from SQL*Plus

Executing the PSP through the Browser

Loadpsp Command Line Options

Summary

 
 
Index Topics:

$

$ORACLE_HOME   

 

@

@PRIOR_VERSION

 

A

Alert.java

allsql.sql

alter system kill session

ANALYZE

ANALYZE TABLE

autotrace   

awk   

 

B

bindsize   

 

C

cdf

check_object

collect.dat

CONNECT INTERNAL

ConnectionTest.java

controlfile.sql

copycommit

coraenv

corrupt_count

CurrentSessions.java

 

D

db_block_checking

dba_objects

dbhome

dbms_alert

dbms_alert_info

dbms_debug   

dbms_profiler  

dbms_repair      

dbms_xplan   

dbshut  

dbstart   

dbstop

dbv.cmd

dbv.ksh

dbverify

dcf

dircmp

dropjava

dump_orphan_keys

 

E

EXCLUSIVE

execnt

execpu

execu

exedsk

exeela

exemis

exeqry

exerow

exp  

exp_full_database

Explain Plan       

export utility      

 

F

facility.lis

fchcnt

fchcpu

fchcu

fchdsk

fchela

fchqry

fchrow

fdf_file

fix_corrupt_blocks

fix_count

fromuser

 

G

get_value

give_raise

 

H

Hidden utility

 

I

import utility  

init.ora  

 

K

kill

 

L

loadjava

loadpsp  

Logontrigger.sql

lsnrctl

M

max_users

maxmem

mod_plsql

My_trace_file.sql

 

O

oemctl utility     

oerr utility

oerr.bat

oerr.java

omsconfig.properties

oracle

Oracle Trace

oracle_trace_collection_path

oracle_trace_enable

oraclec

oracled

oraclee

oraclesm

oradebug       

oradebug unlimit

oradim  

oraenv

oraenv_ask

orakill

orapwd

orastack   

oratab

ORCL92_ora_3064.trc

otcrep

otrace_format_file

otrace_input_file

otrace_stop_file

otrccl

otrccol

otrccref

otrcfmt

otrcref

otrcrep  

otrcsyn.sql

owa_util

P

ping      

plsql_profiler_data

process.dat

profiler_line_source.sql

profiler_runs.sql

profiler_top10_lines.sql

profload.sql  

prscnt

prscpu

prscu

prsdsk

prsela

prsmis

 

R

rebuild_freelists

RECORDLENGTH

reg_id

regid.dat

resumable_name  

resumable_timeout  

 

S

serial#  

set_value

SHARED

shutmode

shuttype

sid   

sort_area_size

spid

SQL*Loader  

SQL*Net    

SQL*Plus

COPY

sqlj.exe

sqlldr

sqlplus

start_profiler

start_trace.sql

starttype

startup

statspack

sys.dbms_profiler_lib

SYSDBA  

SYSOPER

 

T

TechNet

tkprof  

tkprof.sql

tnslsnr.exe

tnsnames.ora  

tnsping   

TOID

traceroute

tracert

transport_tablespace   

trc_directory

trc_file

TRCA$

trcanlzr

trcasst   

trcroute  

 

U

UNIX Commands

kill –9

ps

unrecoverable

user_dump_dest   

Users_Trace_Files.sql

usrpwd

Util_Sessions.sqlj

Utility

Utility Locations

utl_smtp

 

V

v$datafile

v$datafile.db_block_size

v$parameter

v$process

v$session  

v$session_wait

v$sql_plan

v$sql_plan_statistics

v$sql_plan_statistics_all

 

W

waitany  

waitone  

wrap   

 
Reader Comments:

Carol from Westport, CT says:

This book has provided invaluable help in giving clear, comprehensive advise for using the utilities of the Oracle database efficiently. I am indebted to Mr. Moore for his clear writing and practical, step-by-step directions. He has really found a niche that needed to be filled and did it in a most professional way. I would recommend this book to all those who work with this system and who are just feeling their way through some very complicated procedures. Take my word- this book will pay for itself many times over.

Christopher from Blackhawk, CA says:
This book is another in the series of technical volumes published by "Rampant Techpress," published by Don Burleson. The purpose of this book by Dave Moore is to explain to the reader the use of the various Oracle utilities. Some of these utilities are well-known, such as Tkprof; others are far more obscure-such as the Dbms_Profiler utility, or the PL/SQL Wrap Utility.

Mr. Moore succinctly illustrates how to use each utility. For example, in the section Dbms_Repair, he takes the reader through the following steps: Configuring the environment; Finding corrupt blocks; Repairing corrupt blocks, Rebuilding Freelists. Each topic includes a discussion of the purpose, as well as an example of how to accomplish the action.

One particularly interesting section is the discussion entitled "Dbms_Alert Utility." Mr. More gives a brief background on this tool, explains how it works, provides a sample Java program, provides a sample trigger test script, then shows a sample run display. Finally, he also illustrates the use of an associated database table.

As Mr. Moore explains in the Introduction, this is a PRACTICAL book-not just some theoretical treatise on approaches to performance tuning. He concisely explains the utilities that are available, with plenty of examples. I found the book easy to read, and the examples very clear.

Errata:

The premier Oracle utilities book.

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks