Oracle Database Script

http://www.evdbt.com/   

Evergreen Database Technologies, Inc.

Expert Oracle Consulting Services

Downloadable Library

of scripts and other tools

Feel free to download as you wish. No warranty is implied or provided -- use at your own risk!

Please provide credit for authorship if you find these materials useful or if you pass them to others.

Unless otherwise noted, all materials here are written by Tim Gorman.

Content last updated: 20-February 2005

General SQL*Plus scripts:

audit_ddl	dba_column_usage	enqwaits	exchpart
extmap	filestat	gen_analyze_dd	gen_csv
gen_pin	gen_rebuild_idx	gen_recompile	gen_validate
i	infinite_dual	latches	latchfree
locks	logswitch	mts	nondefparm
parm	prevent1555	privs	ptx
px	rman_chk_catalog	rman_chk_nocatalog	rman_chk_test
schema_show_space	sesstime	sesstime80	shrink_files
show_space	sort_use	spc	sqldups
sysevent	systime	systime80	sw
top_stmt2	trclvl12	tracetrg	unload
unparm	usage	usageOPS7	user_source
w	wts

SQL*Plus scripts related to STATSPACK:

spcheck	sphistory	spparms	sppurpkg
sptrends	spviews80	sp_avg_redo_write_time	sp_buffer_busy_waits
sp_delta_views	sp_evtrends	sp_gc_waits	sp_oica
sp_parm_changes	sp_row_lock_waits	sp_shutdown	sp_systime

UNIX shell scripts for Oracle DBAs:

chk_db_up	chk_df	chk_idx_rebuild	chk_obj_recompile
chk_oerr	chk_spc	clonedb	fileprobe
iostat	oramem	oraprobe	oratop
sp_vmstat	tnsprobe	traceon/traceoff	wakepmon

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-84327/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-84327/