Oracle Utilities Pocket Reference: A Quick Reference for DBAs and Developers

by Sanjay Mishra

Overview

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day.As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Reference supplies--the syntax and options for whatever utility a DBA needs to perform a given task.Some of the utilities documented in this guide include:

• SQL*Loader, for loading data
• expdp and exp for exporting data to another database
• oradebug for use in troubleshooting
• loadjava and dropjava for loading and unloading Java programs

Packed with information in an easy-to-read format, this valuable resource is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the Oracle Utilities Pocket Reference close at hand.Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "pocket reference" books.

Product Details

ISBN-13:	9780596553050
Publisher:	O'Reilly Media, Incorporated
Publication date:	11/11/2004
Series:	Pocket Reference (O'Reilly)
Sold by:	Barnes & Noble
Format:	eBook
Pages:	128
File size:	1 MB

About the Author

Sanjay Mishra has more than 12 years of experience working with Oracle systems. His key areas of interest include database architecture, database administration, performance management, scalability, software development and data modelling for mission-critical and decision support applications. He holds a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the co-author of the books Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly Media, Inc.). Sanjay has published several technical papers in Oracle Magazine and SELECT Journal, and has presented many technical papers at various regional, national and international conferences.

Table of Contents

	Introduction	1
	The Utilities	4
	csscan	7
	dbfsize	13
	dbhome	14
	dbshut	15
	dbstart	16
	dbv	17
	dropjava	22
	emctl	24
	exp	25
	expdp	33
	imp	39
	impdp	44
	isqlplusctl	48
	loadjava	49
	lsnrctl	55
	maxmem	58
	nid	58
	oerr	63
	oradebug	64
	orakill	69
	orapwd	70
	relink	71
	sqlldr	72
	sqlplus	100
	tkprof	102
	tnsping	106
	trcroute	107
	tstshm	108
	wrap	109
	Index	113