http://www.evdbt.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Jesse, Rich
> Sent: Tuesday, June 10, 2003 4:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: StoredProc SQL statistics
>
>
> Su
uad/Tech Inc, Sussex, WI USA
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: StoredProc SQL statistics
>
>
>
> Mr Shakir:
>
>
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: StoredProc SQL statistics
It is nice to have good tools to find what and how want quickly.
I simply use statspack to find out my most time consuming SQL. To me
SQL is SQL. Whether I execute it using SQL prompt, or it comes from one
of my PL/SQL procedures.
What I look for it is, how many time I am executing each sql, how
The information you need is all in the extended (10046 level 8) SQL trace
file. You just have to know how to determine all the recursive SQL
parent-child relationships. Tkprof and TFA don't even try. This is one of
the problems we wrote our Hotsos Profiler to solve.
DBMS_PROFILER will help if your
>Hi People,
>Is there any way to find the statistics(like tkprof
>
>gives) of SQL's within storedproc , when storedrpoc
>is
>called.
>
>Basically I want to find culprit SQL within
>StoredProc.
>
>
>Any help is appreciated
>Regards
>Sam
>
x$kglrd, x$kglcursor, sys.obj$, x$kgldp and sys.dependency$
DBMS_PROFILER
Kind Regards,
Hatzistavrou Yannis
Database Administrator
SchlumbergerSema
Phone ext. 478
Email: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 8:55 AM
To: Multiple recipients of list ORACLE-L
Hi People,
Is there any way to find the statistics(like t
Hi People,
Is there any way to find the statistics(like tkprof
gives) of SQL's within storedproc , when storedrpoc is
called.
Basically I want to find culprit SQL within
StoredProc.
Any help is appreciated
Regards
Sam
__
Do you Yahoo!?
Yahoo! Calendar - Free onl