Difference: SQLTraceAnalysis (8 vs. 9)

Revision 92006-07-26 - LucaCanali

Line: 1 to 1
 
META TOPICPARENT name="DbaArea"
Changed:
<
<

SQL Trace Access and Analysis: OraSRP

>
>

SQL Trace Access and Analysis: OraSRP

  This page shortly describes a package to deploy and analyze SQL trace files for DBAs and developers. This package is a valid alternative to the simpler approach: sql trace + tkprof + mail results.
Changed:
<
<

Package overview

Orasrp, a freeware package written in python (by Egor Starostin). It allows to
>
>

Package overview

Orasrp, a freeware package written in python (by Egor Starostin) with following goals:
 
  • publish trace files for access via a web browsers
Changed:
<
<
  • process sql trace files produced with DBMS_MONITOR (or event 10046)
  • the analysis of the trace files is more advanced than tkprof
>
>
  • process sql trace files (see event 10046 and/or DBMS_MONITOR for more info on how to activate sql tracing)
  • advanced analysis of sql trace files (more advanced than tkprof, for example)
 
Changed:
<
<

Sample Orasrp setup

  1. Download the software (see below for binary and python source versions)
  2. unzip under $HOME/scripts/orasrp
  3. export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$HOME/scripts/orasrp; export PATH=$PATH:$HOME/scripts/orasrp
  4. (optional) create password-authenticated user
>
>

Sample Orasrp setup

  1. Download the software (see below for binary and python source versions)
  2. unzip under $HOME/scripts/orasrp
  3. export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$HOME/scripts/orasrp; export PATH=$PATH:$HOME/scripts/orasrp
  4. (optional) create password-authenticated user
 
    • cd to the UDUMP directory. Example: cd /ORA/dbs00/oracle/admin/DBNAME/udump
    • create user (optional) . Example: htpasswd -c .htpasswd luca
    • run orasrp listening on a chosen port. optionally define a keyword on the trace files. Example:
nohup orasrp -d $PWD --port 2502 --pattern=luca    &
Changed:
<
<
    • Note: on RAC orasrp should be run on multiple nodes
    • Note: different port numbers can be used to run orasrp simultaneously for different users.
    • Note: add --htpasswd to the command line enforce user/pass authentication

Instructions to get started:

>
>
  • Note: on RAC orasrp should be run on multiple nodes
    Note: different port numbers can be used to run orasrp simultaneously for different users.
    Note: add --htpasswd to the command line enforce user/pass authentication

Instructions to get started:

 
  • the session parameter tracefile_identifier is needed to add the pattern defined above to the trace files. Example: alter session set tracefile_identifier='luca';
Changed:
<
<
  • activate the trace. Example: exec dbms_monitor.SESSION_TRACE_ENABLE;
  • open the browser to http://webserver:port (2502 in the example above). For rac multiple sessions are needed, one for each node.
>
>
  • activate sql tracing trace. Example: exec dbms_monitor.SESSION_TRACE_ENABLE;
  • point a browser to htp://webserver:port (2502 in the example above). For rac multiple sessions are needed, one for each node.
 
Changed:
<
<

More Oracle tools in this wiki:

>
>

Download from these links:

 
Changed:
<
<
Links to Oracle tools:
  • RlWrap - sqlplus with command line and history, for Linux
>
>

More Oracle tools in this wiki:

Links to other Oracle tools:

  • RlWrap - sqlplus with command line and history, for Linux
 
  • SQLTraceAnalysis - Orasrp, SQL trace formatter, alternative to tkprof
  • SQLpython - sqlplus-like command line with focus on customizations, in python

Other links:

Changed:
<
<
>
>
 
Deleted:
<
<
 
Changed:
<
<
META FILEATTACHMENT attr="" comment="ORASRP, SQL trace analyzer, python source" date="1146669266" name="orasrp-src.zip" path="orasrp-src.zip" size="30807" user="canali" version="1.1"
META FILEATTACHMENT attr="" comment="ORASRP, SQL trace analyzer, binary version for Linux" date="1146669282" name="orasrp-linux.zip" path="orasrp-linux.zip" size="1248960" user="canali" version="1.1"
META FILEATTACHMENT attr="" comment="ORASRP, SQL trace analyzer, binary version for Windows" date="1149498944" name="orasrp-windows.zip" path="orasrp-windows.zip" size="1550857" user="canali" version="1.1"
>
>
META FILEATTACHMENT attr="" autoattached="1" comment="ORASRP, SQL trace analyzer, binary version for Windows" date="1149498945" name="orasrp-windows.zip" path="orasrp-windows.zip" size="1550857" user="canali" version="1.1"
META FILEATTACHMENT attr="" autoattached="1" comment="ORASRP, SQL trace analyzer, binary version for Linux" date="1146669282" name="orasrp-linux.zip" path="orasrp-linux.zip" size="1248960" user="canali" version="1.1"
META FILEATTACHMENT attr="" autoattached="1" comment="ORASRP, SQL trace analyzer, python source" date="1146669266" name="orasrp-src.zip" path="orasrp-src.zip" size="30807" user="canali" version="1.1"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback