by: cc:
[EMAIL PROTECTED] Subject: RE: StoredProc SQL statistics
ity.com
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:
Can you tell me the URL for the Tim Gorman website, and Steve Adams
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
Surf to http://www.google.com
Search
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
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
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$ ...
I don't
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