tag:blogger.com,1999:blog-2807785752181271137.post2077242217017469222..comments2024-03-06T12:33:57.350+01:00Comments on Damir Vadas, Oracle as I learned: Trace Analyzer "Directory alias does not exist in DBA_DIRECTORIES"Damir Vadashttp://www.blogger.com/profile/15963017378937428976noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2807785752181271137.post-62258866361804276322010-01-24T02:16:18.267+01:002010-01-24T02:16:18.267+01:00Hi,
in my first comment I meant for OraSRP that i...Hi,<br /><br />in my first comment I meant for OraSRP that is enough just to unpack it to work... I forgot that you were mentioning elimination of needs to connect to database server :/ (I have to read more carefully next time)<br /><br />Yes, you have to run OraSRP on server side and in that point trca beats, but with this little workaround from T.Kyte you can run it from client side also.<br /><br />My intention was just to point you to another free solution for profiling extended sql traces which is my favorite :)<br /><br />Kind regards,<br />MarkoMarko Sutichttp://msutic.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-51544137392399233832010-01-24T00:21:43.888+01:002010-01-24T00:21:43.888+01:00Marko,
Now you made me smile.
Your first post s...Marko,<br /><br />Now you made me smile. <br /><br />Your first post start with "Just unpack it and that's it"...<br />Good sales approach!<br />;-)<br />Regards,<br />DamirDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-18016902826354767792010-01-23T20:33:38.469+01:002010-01-23T20:33:38.469+01:00Hi Damir,
sorry but I forgot to mention that I us...Hi Damir,<br /><br />sorry but I forgot to mention that I use OraSRP with this simple solution from Tom Kyte (http://bit.ly/6IcBGT)<br /><br />I change it a little to work with OraSRP not tkprof.<br /><br />Regards,<br />MarkoMarko Sutichttp://msutic.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-62232363325466628092010-01-23T18:16:05.520+01:002010-01-23T18:16:05.520+01:00Marko,
Until now I was not aware for OraSROP-will ...Marko,<br />Until now I was not aware for OraSROP-will try after the weekend. TH for pointing out this fact.<br />However, seems to me that it cannot be run from client side (as trca) so developer are not able to run it without privilege to connect on server...this is where trca beats.<br />DamirDamir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2807785752181271137.post-52959807825741854622010-01-23T14:35:53.880+01:002010-01-23T14:35:53.880+01:00I don't like trace analyzer mostly because ins...I don't like trace analyzer mostly because installation procedure which is way to complicated if you compare it with another similar tools.<br /><br />Try OraSRP (http://www.oracledba.ru/orasrp/) as replacement for tkprof. It's the best free profiler for extended sql traces for me. <br /><br />Just unpack it and that's it...<br /><br />Regards,<br />MarkoMarko Sutichttp://msutic.blogspot.com/noreply@blogger.com