Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 23rd, 2017, 7:00am
News: Welcome to Pete Finnigan's Oracle security forum
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Internals
(Moderator: Pete Finnigan)
   Event 10046 trace report makers
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Event 10046 trace report makers  (Read 6169 times)
Marcel-Jan
PeteFinnigan.com Junior Member
**






   
View Profile | WWW |

Gender: male
Posts: 83
Event 10046 trace report makers
« on: Feb 14th, 2006, 11:01am »
Quote | Modify

Hi everybody,
 
If you, like me, use event 10046 tracing often for performance analysis, you need some kind of tool to translate the trace file to response time information. There are a couple of tools to do the trick:

  • Oracle's standard trace tool tkprof
  • Oracle Metalink's Trace Analyzer (Note 224270.1)
  • Hotsos Profiler (www.hotsos.com)

 
Tkprof's report however is a little limitted. Trace Analyzers report is very nice, but it doesn't handle recursive SQL (SQL in PL/SQL) well. Hotsos Profiler is a commercial product. You need to upload your trace file to their website and if you bought a license, it will produce the report for you. I can say from experience that it is a very complete and nice HTML report.  
 
I while ago I discovered OraSRP. OraSRP is an open source tool that produces HTML reports of your traces, similar to those of Hotsos Profiler. I've tried it, already for a while. The only thing I've noticed, is that it has some problems concerning trace files larger than about 20 Mb. But even then you get most of the information in your HTML report. You can download OraSRP from http://oracledba.ru/orasrp.
 
From a security perspective it is noteworthy that starts its own HTTP server on your workstation to produce the HTML reports. So perhaps it's wise to stop this process as soon as you have the report in your hands.
IP Logged
marian
PeteFinnigan.com Newbie
*



I love YaBB 1G - SP1!

   
View Profile |

Posts: 2
Re: Event 10046 trace report makers
« Reply #1 on: Mar 29th, 2006, 10:07am »
Quote | Modify

Hello Marcel-Jan,
 
I tried download orasrp from http://oracledba.ru/orasrp, but on page is stated
"Due to personal obligations, OraSRP project is closed. " (probably Egor Starostin was bought by Hotsos Sad( )
Could anybody send me last binary version of orasrp tool (windows), because I can't find it anywhere.
 
Thank you.
 
Marian
marian.bednar@gmail.com
IP Logged
Marcel-Jan
PeteFinnigan.com Junior Member
**






   
View Profile | WWW |

Gender: male
Posts: 83
Re: Event 10046 trace report makers
« Reply #2 on: May 16th, 2006, 11:41am »
Quote | Modify

Sorry for the late response.  
 
I also wonder what happened to the OraSRP project. But I happened to find a Linux edition of OraSRP (including sourcecode) just today.
 
Have a look.
https://twiki.cern.ch/twiki/bin/view/PSSGroup/SQLTraceAnalysis.
IP Logged
marian
PeteFinnigan.com Newbie
*



I love YaBB 1G - SP1!

   
View Profile |

Posts: 2
Re: Event 10046 trace report makers
« Reply #3 on: Jul 7th, 2006, 10:40am »
Quote | Modify

Marcel-Jan,
 
thank you very much.
 
Marian
IP Logged
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board