Difference: SQLTraceAnalysis (6 vs. 7)

Revision 72006-06-05 - LucaCanali

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

SQL Trace Access and Analysis: OraSRP

Line: 9 to 9
 It allows to
  • publish trace files for access via a web browsers
  • process sql trace files produced with DBMS_MONITOR (or event 10046)
Changed:
<
<
  • the analysis of the trace files is more advanced than tkprof (see also http://www.hotsos.com and their P5 profiler)
>
>
  • 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)
Line: 19 to 19
 
    • 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:
Added:
>
>
 nophup orasrp -d /ORA/dbs00/oracle/admin/DBNAME/udump --htpasswd --port 2502 --pattern=luca &
Added:
>
>
 
    • 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';
Changed:
<
<
  • activate the trace. Example: exec dbms_monitor.SESSION_TRACE_ENABLE; (or user event 10046)
>
>
  • 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:

Line: 51 to 53
 

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"
Changed:
<
<
META FILEATTACHMENT attr="" comment="ORASRP, SQL trace analyzer, binary version" 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 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"
 
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