WARNING: This web is not used anymore. Please use PDBService.SQLTraceAnalysis instead!

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.

Package overview

Orasrp, a freeware package written in python (by Egor Starostin). It allows to
  • publish trace files for access via a web browsers
  • process sql trace files produced with DBMS_MONITOR (or event 10046)
  • the analysis of the trace files is more advanced than tkprof

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. Example: htpasswd -c .htpasswd luca
    • run orasrp listening on a chosen port. optionally define a keyword on the trace files. Example:
nophup orasrp -d /ORA/dbs00/oracle/admin/DBNAME/udump --htpasswd --port 2502 --pattern=luca    &
    • Note: on RAC orasrp should be run on multiple nodes
    • Note: different port numbers can be used to run orasrp simultaneously for different users.

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';
  • 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.

More Oracle tools in this wiki:

Links to 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:

Topic attachments
I Attachment History Action Size Date Who Comment
Compressed Zip archivezip orasrp-linux.zip r1 manage 1219.7 K 2006-05-03 - 17:14 LucaCanali ORASRP, SQL trace analyzer, binary version for Linux
Compressed Zip archivezip orasrp-src.zip r1 manage 30.1 K 2006-05-03 - 17:14 LucaCanali ORASRP, SQL trace analyzer, python source
Compressed Zip archivezip orasrp-windows.zip r1 manage 1514.5 K 2006-06-05 - 11:15 LucaCanali ORASRP, SQL trace analyzer, binary version for Windows
Edit | Attach | Watch | Print version | History: r10 < r9 < r8 < r7 < r6 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r7 - 2006-06-05 - LucaCanali
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback