老外编写的一个工具,貌似现在用处不大了,随着每个人工作经验的增长,都会形成自己的一套知识库,一套脚本.在此分享下.找个老的,有想要研究的拿去.
SQL> @osmi.sql
OraPub Online Institute - What any-where any-device any-time training should be!
OraPub System Monitor - Interactive Analysis Menu
(c)1998-2015 OraPub, Inc. - Free use, just keep company and author name
-- Object Growth Analysis
obcrobj Create object growth objects
ogbigld Load selected objects into Object Growth tables (will prompt)
ogobjset Set object(s) obj growth specifics
ogdoit Load growth management data for scheduled objects
ogwhich ID object owner and name in dba_objects and o$dba_objects
ogobjlst List objects in Object Growth schedule
-- Users
cu Create an Oracle user (
)
users Summary info about Oracle users
tp[8,9] Top Oracle users/processes (will be prompted)
-- Configuration and Size
rbs Rollback configuration details
tss Tablespace space details
dfl Database file listing
tsmap Tablespace map detail (
)
stu Segment types and size per user summary
idx Index columns (
)
-- Fragmentation
fgtbl Table frag (
)
fgidx Index frag (
)
tbfsum Table block frag summary (
)
istat Index statistics (
)
-- Data Selectivity
ds[7] Data selectivity for a col(s) (
)
dsn Data selectivity for a numeric col(s) (
)
-- Instance Parameters
ip Instance parameters (
)
ipx Instance parameters (hidden also) (
)
ipcbc Instance params realted to the cache buffer chain latches
-- SGA Size and Activity
sga System global area summary
spspinfo Shared pool sub-pool information
chr SGA cache hit ratios (some of them)
clone Show clone buffers counts
lc Library cache details
dboc v$db_object_cache (
)
mts Multi-threaded activity details
-- Redo Logs
rlog Redo log activity (v$log)
rdohist Redo log switching history (v$loghist)
-- Realtime Session Sampler Tool
rss Realtime Session Sampler
. (
)
-- Instance Statistics
sessinfo[9] Oracle session details / ID (prompted...)
sesstat V$SESSTAT details (
)
sysstat V$SYSSTAT details (
)
-- SQL Text
sqls1[8,9] List "top" SQL statements (
)
sqlgettext List SQL statement text
sqlelget Get individual SQL elapsed times (
)
sqlelget11 Get individual SQL elapsed times (
)
simsql1 List similar SQL (
)
simsql2 Shows all SQL that start with... (<'text of similar SQL'>)
.
-- IO
dfio Oracle datafile I/O details
iosum Oracle IO summary since instance startup
iosumx Oracle IO summary for interval between runs, DELTA
-- Latching/Mutex: Serialization Control
latch[8] Latching statistics
latchx Latching statistics w/deltas
latchclass Latch class assignment (must be run as sys)
latchchild Gather child latch activity (
)
-- Oracle Time Based Analysis: TT:Total Time, RT:Response Time
ttpctx TT Profile : instance perspective with out categories (like swpctx.sql)
rtpctx RT Profile : instance perspective with out categories (like swpctx.sql)
rtc RT Profile : system perspective using Oracle categories
rtsysx[8] RT Profile : system perspective DELTA (
<# sim SQL chars>)
rtsess[9] RT Profile : session perspective (9:
,10+:
)
-- Oracle Wait Event Analysis
swpct SW system event percentage summary
swpctx[11] SW system event percentage summary DELTA
swpctidle Idle only SW system event percentage summary
swpctxidle Idle only SW system event percentage summary DELTA
swswc SW session wait level w/counts
swswp SW session wait level w/paramters
swsessid SW session event level for given SID (
)
swsid SW session wait level for given SID (
)