ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle Database Script

Oracle Database Script

原创 Linux操作系统 作者:tolywang 时间:2005-04-14 00:00:00 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13174694