OraPub System Monitor (OSM) Toolkit
Get Complete OSM Toolkit (free)

ashclp.sql
ashclpct.sql
ashp.sql
ashpctcpu.sql
ashpcte.sql
ashpctecl.sql
ashpctes.sql
ashpcts.sql
ashrt.sql
ashrt_old.sql
ashsp.sql
ashspct.sql
ashsqlcl.sql
ashsqle.sql
ashsqlpctcl.sql
ashsqlpctcpu.sql
ashsqlpcte.sql
ashsqlpcts.sql
ashsqlpctt.sql
ashsqls.sql
avgexplore.sql
bc.sql
bc7.sql
bcmap.sql
bcmap7.sql
bcobjfb.sql
chr.sql
clone.sql
cr_rtsp.sql
cu.sql
cycledb6
cycledb9
dboc.sql
delete.me
dev_list.txt
dfio.sql
dfl.sql
diag.sql
ds.sql
ds7.sql
dsn.sql
eval1.sql
event_type.sql
event_type_nc.sql
fgidx.sql
fgtbl.sql
hashchk.sql
idx.sql
iosum.sql
iosum9.sql
iosum9x.sql
iosumx.sql
ip.sql
ipcbc.sql
ipx.sql
irtviews.sql
istat.sql
latch.sql
latch8.sql
latch_old.sql
latchchild.sql
latchclass.sql
latchx.sql
lc.sql
lock.sql
loghist8.sql
lruno.sql
mkodo.sql
mkodo_ouch.sql
mts.sql
mysess.sql
objfb.sql
objloc.sql
ogbigld.sql
ogcrobj.sql
ogdoit.sql
ogobjlst.sql
ogobjset.sql
oracpu.sql
oracputext.sql
oracpux.sql
oracpux1.sql
oracpux2.sql
oscpux.sql
oscpux1.sql
oscpux10.sql
oscpux2.sql
oscpux210.sql
osmclear.sql
osmi.sql
osmprep.sql
osmtitle.sql
osmtitlel.sql
osmtitlell.sql
osmtitlem.sql
osmtitles.sql
rbs.sql
rdohist.sql
readme.txt
rlog.sql
rtc.sql
rtcx.sql
rtio.sql
rtow.sql
rtpctx.sql
rtsess.sql
rtsess9.sql
rtsessx.sql
rtsum.sql
rtsys.sql
rtsysx.sql
rtsysx8.sql
sessinfo.sql
sessinfo9.sql
sesstat.sql
sga.sql
simsql1.sql
simsql2.sql
snap_stats.sql
spspinfo.sql
sqls1.sql
sqls18.sql
sqls19.sql
sqls2.sql
sqls3.sql
sqls4.sql
stu.sql
supers.sql
swenq.sql
swenqc.sql
swenqnew.sql
swenqx.sql
swhist.sql
swhist.sql.sav
swhistx.sql
swhistx.sql.sav
swpct.sql
swpctidle.sql
swpctx.sql
swpctxidle.sql
swsessid.sql
swsid.sql
swsw.sql
swswc.sql
swswp.sql
swsys.sql
sysstat.sql
tbfsum.sql
tcsizing.sql
tcstats.sql
test.sql
timechk.sql
topcpu
topdml.sql
tp.sql
tp9.sql
tsmap.sql
tss.sql
undo.sql
users.sql
-- ********************************************************************
-- * Copyright Notice  : (c)1998-2010,2011 OraPub, Inc.
-- * Filename          : osmi.sql
-- * Author            : Craig Shallahamer
-- * Original          : 24-SEP-98
-- * Last Update       : 06-Jan-2012
-- * Description       : OSM-Interactive menu
-- * Usage             : start osmi.sql
-- ********************************************************************

prompt OraPub System Monitor - Interactive Menu
prompt (c)1998-2012 OraPub, Inc. - Free use, just keep company and author name
prompt 
prompt obcrobj  Create object growth objects
prompt ogbigld  Load selected objects into Object Growth tables (will prompt)
prompt ogobjset Set object(s) obj growth specifics
prompt ogdoit   Load growth management data for scheduled objects
prompt ogwhich  ID object owner and name in dba_objects and o$dba_objects
prompt ogobjlst List objects in Object Growth schedule
prompt 
prompt cu       Create an Oracle user (‹uid› ‹pwd› ‹dft tbs› ‹dft tmp tbs› ‹prof›)
prompt users    Summary info about Oracle users
prompt tp[8,9]  Top Oracle users/processes (will be prompted)
prompt
prompt rbs      Rollback configuration details
prompt tss      Tablespace space details
prompt dfl      Database file listing
prompt tsmap    Tablespace map detail (‹tbs name›)
prompt stu      Segment types and size per user summary
prompt idx      Index columns (‹owner› ‹table›)
prompt
prompt istat    Index statistics (‹owner› ‹index›)
prompt fgtbl    Table frag (‹owner› ‹tblname›)
prompt fgidx    Index frag (‹owner› ‹INDEX name›)
prompt tbfsum   Table block frag summary (‹owner› ‹table› ‹min tbf›)
prompt ds[7]    Data selectivity for a col(s) (‹own› ‹tbl› ‹col(s)›)
prompt dsn      Data selectivity for a numeric col(s) (‹own› ‹tbl› ‹col(s)›)
prompt
prompt ip       Instance parameters (‹partial param value›)
prompt ipx      Instance parameters (hidden also) (‹partial param value›)
prompt ipcbc    Instance params realted to the cache buffer chain latches
prompt sga      System global area summary
prompt spspinfo Shared pool sub-pool information
prompt chr      SGA cache hit ratios (some of them)
prompt clone    Show clone buffers counts
prompt lc       Library cache details
prompt dboc     v$db_object_cache (‹min execs› ‹min size›)
prompt mts      Multi-threaded activity details
prompt sessinfo[9] Oracle session details / ID (prompted...)
prompt sesstat  V$SESSTAT details (‹sid› ‹partial name›)
prompt sysstat  V$SYSSTAT details (‹partial name›)
prompt rlog     Redo log activity (v$log)
prompt rdohist  Redo log switching history (v$loghist)
prompt
prompt sqls1[8,9] List "top" SQL statements (‹min pio› ‹min lio›)
prompt sqls2    List SQL statement in shared pool (‹sql stmt address›)
prompt sqls3    List SQL statement in shared pool (‹sql stmt hash value›)
prompt sqls4    List SQL statement in shared pool (‹sql stmt SQL ID›)
prompt simsql1  List similar SQL (‹first X chars to consider›)
prompt simsql2  Shows all SQL that start with... (‹'text of similar SQL'›)
prompt dfio     Oracle datafile I/O details
prompt iosum    Oracle IO summary since instance startup
prompt iosumx   Oracle IO summary for interval between runs, DELTA
prompt latch[8] Latching statistics
prompt latchx   Latching statistics w/deltas
prompt latchclass   Latch class assignment (must be run as sys)
prompt latchchild   Gather child latch activity (‹latch#› ‹sleep›)
prompt
prompt rtpctx       RT Profile : system perspective with out categories (like swpctx.sql)
prompt rtc          RT Profile : system perspective using Oracle categories
prompt rtsysx[8]    RT Profile : system perspective DELTA (‹interval (sec)›  ‹# sim SQL chars›)
prompt rtsess[9]    RT Profile : session perspective (9:‹sid›,10+:‹client ident›)
prompt
prompt oscpux       OS CPU consumption 
prompt oracpu       Oracle CPU breakdown (since startup)
prompt oracpux      Oracle CPU breakdown (delta)
prompt timechk x    Check Oracle's CPU consumption time (v$sysstat based) reporting (‹interval›)
prompt
prompt swpct    SW system event percentage summary
prompt swpctx   SW system event percentage summary DELTA
prompt swpctidle  Idle only SW system event percentage summary
prompt swpctxidle Idle only SW system event percentage summary DELTA
prompt swhist   SW histogram (‹partial event›)
prompt swhistx  SW histogram DELTA (‹partial event›)
prompt swswc    SW session wait level w/counts
prompt swswp    SW session wait level w/paramters
prompt swsessid SW session event level for given SID (‹sid›)
prompt swsid    SW session wait level for given SID (‹sid›)
prompt swsw     SW session wait level; all sessions!
prompt swenq    SW enqueue details
prompt swenqc   SW enqueue details by count
prompt swenqx   SW enqueue detail (‹p1›  ‹p2›)
prompt
prompt For all ASH reports, MIN is the number of past minutes to consider.
prompt
prompt ashrt         ASH system   response time anlaysis (‹min› ‹SQL_ID,%›)
prompt ashsqlpcte    ASH system   level Find SQL by event (‹min› ‹partial event›)
prompt ashsqlpctcpu  ASH system   level Find SQL by CPU consumption (‹min›)
prompt ashpcte       ASH system   level per event, wait pct (‹min›)
prompt ashpctes      ASH system   level per event, sid, wait pct (‹min› ‹partial event›)
prompt ashpcts       ASH system   level per sess, pct, last x min (‹min›)
prompt ashspct       ASH sess     level by event, wait pct (‹min› ‹SID› ‹SER›)
prompt ashclpct      ASH sess     level by event, wait pct (‹min› ‹client id› )
prompt ashsp         ASH sess     level w/params, last x min (‹min› ‹SID› ‹SER› ‹partial event›)
prompt ashclp        ASH sess     level w/params, last x min (‹min› ‹client id› ‹partial event›)
prompt ashsqlpctt    ASH system   level Find SQL by most wait time (‹min›)
prompt ashsqlpcts    ASH system   level Find SQL by session (‹min› ‹SID› ‹SER›)
prompt ashsqlpctcl   ASH system   level Find SQL by session (‹min› ‹client id›)
prompt ashsqle       ASH SQL STMT level event pct wait by SQL (‹min› ‹SQL ID›)
prompt ashsqls       ASH SQL STMT level for SID by event pct wait (‹min› ‹SID› ‹SER›)
prompt ashsqlcl      ASH SQL STMT level for SID by event pct wait (‹min› ‹client id›)
prompt
prompt objloc   Object location listing (‹owner› ‹partial name›)
prompt objfb    Object details for a given file and block (‹file#› ‹blk#›)
prompt bcobjfb  Object details for a ... in cache         (‹file#› ‹blk#›)
prompt
prompt mkodo      Create the odometer (odo) table and indexes.
prompt mkodo_ouch Same, but with a commit after each insert.
prompt
prompt cycledb6 Cycle the current db instance (O 6,7,8)
prompt cycledb9 Cycle the current db instance (O 9,10,11)
prompt
prompt osmprep  Prepare the OSM Interactive environment
prompt osmtitle Standard OSM Interactive title script
prompt osmclear Standard OSM Interactive end of script clear stuff
prompt
prompt OraPub System Monitor - Interactive Menu
prompt (c)1998-2010 OraPub, Inc. - Free use, just keep company and author name


Know what's important before it's too late!



OraPub's
Performance Training

is like no other...




More Class Pics...
Get student testimonials!



Craig Shallahamer's Blog