An index of my TPT scripts

Tanel Poder

2011/03/24

A lot of people have asked me whether there’s some sort of index or “table of contents” of my TPT scripts (there’s over 1000 in my TPT script repo right now).

I have planned to create such index for years, but never got to it. I probably never will :) So a good way to extract the descriptions of some scripts is to just grep for Purpose: in the scripts directory:

grep -i Purpose: ash/*.sql awr/*.sql *.sql | awk -F: '{ printf("%20s %-50s\n", $1, $3) }'

Here’s the output (currently only 10% of the scripts out of about 1000 have a purpose declared):

$ grep -i Purpose: ash/*.sql awr/*.sql *.sql | awk -F: '{ printf("%20s %-50s\n", $1, $3) }' 

ash/ash_wait_chains.sql      Display ASH wait chains (multi-session wait signature, a session
      ash/ashtop.sql      Display top ASH time (count of ASH samples) grouped by your
     ash/asqlmon.sql      Report SQL-monitoring-style drill-down into where in an execution plan the execution time is spent
ash/bash_wait_chains.sql      Display ASH wait chains (multi-session wait signature, a session
     ash/bashtop.sql      Display top ASH time (count of ASH samples) grouped by your
  ash/daplanline.sql      Report response time consumption data from DBA_HIST_ACTIVE_SESS_HISTORY
ash/dash_wait_chains.sql      Display ASH wait chains (multi-session wait signature, a session
     ash/dashtop.sql      Display top ASH time (count of ASH samples) grouped by your
    ash/dasqlmon.sql      Report SQL-monitoring-style drill-down into where in an execution plan the execution time is spent
 ash/devent_hist.sql      Display wait event duration histogram from DBA_HIST_ACTIVE_SESS_HISTORY
ash/rowsource_events.sql      Display top ASH time (count of ASH samples) grouped by 
          ashtop.sql      Display top ASH time (count of ASH samples) grouped by your
            bhla.sql      Report which blocks are in buffer cache, protected by a cache
         bufprof.sql      Display buffer gets done by a session and their reason
            calc.sql      Basic calculator and dec/hex converter       
          cancel.sql      Generates commands for canceling selected sessions
        channels.sql      Report KSR channel message counts by channel endpoints
       channels2.sql      Report KSR channel message counts by channel endpoints
       channels3.sql      Report KSR channel message counts by channel endpoints
        curheaps.sql      Show main cursor data block heap sizes and their contents
             dba.sql      Convert Data Block Address (a 6 byte hex number) to file#, block#
             ddl.sql      Extracts DDL statements for specified objects
              df.sql      Show Oracle tablespace free space in Unix df style
             dfm.sql      Show Oracle tablespace free space in Unix df style
        diag_sid.sql      Display current Session Wait info            
        diag_sid.sql      An easy to use Oracle session-level performance snapshot utility
           disco.sql      Generates commands for disconnecting selected sessions
            fcha.sql      Find in which heap (UGA, PGA or Shared Pool) a memory address resides
     getplusparm.sql      get sqlplus parameter value (such linesize, pagesize, sqlcode,
         getprev.sql      Get previously executed SQL ID, child number and other details into sqlplus variables for further use
            grpn.sql      Quick group by query for aggregating Numeric columns
            hash.sql      Show the hash value, SQL_ID and child number of previously
           hinth.sql      Display the areas / features in Oracle kernel that a hint affects
               i.sql      the Who am I script (also sets terminal title)
             i2h.sql      Advanced Oracle Troubleshooting Seminar demo script
             imu.sql      Display In-Memory Undo (IMU) buffer usage    
            init.sql      Initializes sqlplus variables for 156 character terminal width and other settings.
       kglbroken.sql                                                   
       kglbroken.sql      Report broken kgl locks for an object this can be used for 
            kill.sql      Generates commands for killing selected sessions
           killi.sql      Generates commands for killing selected sessions
              la.sql      Show which latch occupies a given memory address and its stats
     lastchanged.sql      Detect when a datablock in table was last changed
       latchprof.sql      Perform high-frequency sampling on V$LATCHHOLDER
   latchprof_old.sql      Perform high-frequency sampling on V$LATCHHOLDER
      latchprofx.sql      Perform high-frequency sampling on V$LATCHHOLDER
              lh.sql      Show latch holding SIDs and latch details from V$LATCHHOLDER
             lhp.sql      Perform high-frequency sampling on V$LATCHHOLDER
            lhpx.sql      Perform high-frequency sampling on V$LATCHHOLDER
     lotshparses.sql      Generate Lots of hard parses and shared pool activity 
    lotshparses2.sql      Generate Lots of hard parses and shared pool activity 
    lotshparses3.sql      Generate Lots of hard parses and shared pool activity 
        lotslios.sql      Generate Lots of Logical IOs for testing purposes
        lotspios.sql      Generate Lots of Physical IOs for testing purposes
     lotssparses.sql      Generate Lots of soft parses and library cache/mutex activity 
    lotssparses2.sql      Generate Lots of soft parses and library cache/mutex activity 
      measure_io.sql      Measure IO reasons and "sizes" from v$iostat_function_detail
       mutexprof.sql      Display KGX mutex sleep history from v$mutex_sleep_history
       nonshared.sql      Print reasons for non-shared child cursors from v$sql_shared_cursor
      nonshared2.sql      Show the reasons why more child cursors were created instead of
nonsharedsum_html.sql      Print reasons for non-shared child cursors from v$sql_shared_cursor
      ostackprof.sql      Take target process stack samples and show an execution profile
            pmem.sql      Show process memory usage breakdown - lookup by process SPID
     pmem_detail.sql      Show process memory usage breakdown details - lookup by process SPID
        prefetch.sql      Show KCB layer prefetch                      
          pvalid.sql      Show valid parameter values from V$PARAMETER_VALID_VALUES
              px.sql      Report Pararallel Execution SQL globally in a RAC instance
        rowcache.sql      Show parent rowcache entries mathcing an object name
              rs.sql      Display available Redo Strands               
               s.sql      Display current Session Wait and SQL_ID info (10g+)
          sample.sql      Sample any V$ view or X$ table and display aggregated results
      sampleaddr.sql      High-frequency sampling of contents of a SGA memory address
             ses.sql      Display Session statistics for given sessions, filter by
            ses2.sql      Display Session statistics for given sessions, filter by
        sgastatx.sql      Show shared pool stats by sub-pool from X$KSMSS
            smem.sql      Show process memory usage breakdown - lookup by session ID
     smem_detail.sql      Show process memory usage breakdown details - lookup by session ID
         snapper.sql      An easy to use Oracle session-level performance measurement tool
        snapper3.sql      An easy to use Oracle session-level performance measurement tool
      snapper_v1.sql      An easy to use Oracle session-level performance snapshot utility
      snapper_v2.sql      An easy to use Oracle session-level performance snapshot utility
           sqlfh.sql      Display the full SQL Feature Hieararchy from v$sql_feature
        sqlflame.sql      Demo script for displaying execution plan profile as a flame chart
          sqlidx.sql      A temporary script/hack to display exadata-specific metrics along normal SQL stuff from V$SQL
          sqlmon.sql      Spool a SQL Monitoring report to a local HTML file and open it
 sqlmon_restarts.sql      List UPDATE/DELETE statements that have experienced restarts due to write consistency from V$SQL_PLAN_MONITOR
         sqlmoni.sql      Spool a SQL Monitoring report to a local HTML file and open it
            stat.sql      Execute SQL statement in script argument and report basic
              sw.sql      Display current Session Wait info            
             sw2.sql      Display current Session Wait info            
             swg.sql      Display given Session Wait info grouped by state and event
             swo.sql      Display current Session Wait info            
          topsql.sql      Show TOP SQL ordered by user-provided criteria
            usql.sql      Show another session's SQL directly from library cache
           usqlx.sql      Show another session's SQL directly from library cache
        waitprof.sql      Sample V$SESSION_WAIT at high frequency and show resulting 
            wrka.sql      List SQL workarea memory usage details at session/workarea level.
         wrkasum.sql      Show a summary of SQL workareas grouped by operation type (SORT, HASH, etc)
              xb.sql      Explain a SQL statements execution plan with execution 
             xbi.sql      Explain a SQL statements execution plan with execution 
            xde2.sql      Describe X$ tables, column offsets and report indexed fixed table
              xm.sql      Explain a SQL statements execution plan directly from library cache
             xma.sql      Explain a SQL statements execution plan directly from library cache
            xmai.sql      Explain a SQL statements execution plan with execution 
             xms.sql      Explain your last SQL statements execution plan with execution 
            xmsh.sql      Explain a SQL statements execution plan with execution 
            xmsi.sql      Explain a SQL statements execution plan with execution             

NB! Check out my 2018/2019 online training classes: Advanced Oracle SQL Tuning training, Advanced Oracle Troubleshooting training and the new Practical Linux Performance & Application Troubleshooting training!