Hi,
check out Mogens site, he has a PL/SQL tool for storing trace files
in a repository. Its called TraceFile Repository and was written by
Torben Holm and its free - have a look http://www.miracleas.dk/tools/Mir
TFR104.zip -t might be an alternative for you? - it has a web based
front end using
, having an opinion is an art !
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Tuesday, August 26, 2003 6:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
tkprof issues - was Performance Problem
Are
you sure that your swap space is sufficient
: Wednesday, August 27, 2003 9:05
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
tkprof issues - was Performance Problem
Swap is 16G, 1.2% used
RAM is 16G,
16 processors.
Raj
Rajendra dot
Title: Message
Are
you sure that your swap space is sufficient?
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Tuesday, August 26, 2003 5:59
PMTo: Multiple recipients of list
I use sys.dbms_system.set_ev( v_seid ,v_sernum ,10046,12 ,'') to start
tracing on 8.1.6 db . What should I do to stop tracing without exiting out
of session .
Thanks,
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 9:07
also how can we check if one particular session is being traced (10046 ) or
not . Basically I want to be sure that tracing is stopped for the session
and its not fillling up disk space .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
sys.dbms_system.set_ev( v_seid ,v_sernum ,10046, 0,'')
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 10:49 AM
I use sys.dbms_system.set_ev( v_seid ,v_sernum ,10046,12 ,'') to
sys.dbms_system.set_ev( v_seid, v_sernum, 10046, 0, '' )
^
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
-Original Message-
Repeat but changing the 12 to a zero should work.
You will find, however, that any cursor that has
not closed when you stop tracing will not dump
its 'STAT' lines (including execution plan) to the
trace file.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day
Thanks Jonathan,
what is meaning of recursive depth ? I see calls to cdef$, seq$
tables/views does it hint something . I though procedure is using some
sequence and these are internal calls to generate seq numbers . Is that rite
?
-ak
- Original Message -
To: Multiple recipients of
The examples you have given are SYS-recursive,
The call to cdef$ is Oracle looking for some information
about constraints (one possibility is that you keep breaking
a PK or UK constraint and Oracle has to keep looking up
the name of the constraint because it doesn't cache constraint
names).
The
An action with dep=n+1 (n=0) for cursor #k is the recursive child of the
next dep=n action for cursor #k that immediately follows in the trace data.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10
Thanks Jonathan for the information . Let me go through raw -trace file once
more to get info . Everytime I go through it I find something interesting .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 8:54 AM
The
Run tkprof with SYS = YES option and find recursive calls that contribute
to this time.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 2:29 PM
I am running tkprof on event 10046
Using sys=yes on the tkprof command line would be a good start.
That way you will see which statements are generating all the recursive
SQL.
Jared
AK [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/11/2003 11:29 AM
Please respond to ORACLE-L
To: Multiple recipients of
Any SQL within a pl/sql block is recursive SQL
(user recursive, rather than SYS recursive) so
this time could simply be the cost of running
your application code.
Unfortunately the tkprof output doesn't quote
the recursive depth of the SQL - however if
you identify possible suspects, you can
nope - its an oversight of oracle's. You can upgrade
to 9.2 (which I'd recommend because its so much
better) or it might even be in one of the 9.0 patches.
Using the 817 or 92 tkprof binary also seems to work
effectively.
hth
connor
--- Randy Pace [EMAIL PROTECTED] wrote: I have a
9.01
Oracle8i Server Tuning guide (part #A76992, available for free download from
http://docs.oracle.com), pages 6-22 through 6-30 for TKPROF output example
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 7:38 AM
Hi,
Can any
I have heard two different ones, no idea if either is correct :-)
trace kernel profiler
transient kernel profiler
John
[EMAIL PROTECTED] wrote:
What does it stand for? Tool Kit Profiler???
tia,
David Nemeth
__
Do You Yahoo!?
Yahoo! Tax Center
I thought it was Trace Kernel Profiler.
PB
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
Transient Kernel Profile.
- Kirti
-Original Message-
Sent: Wednesday, April 10, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
What does it stand for? Tool Kit Profiler???
Transient Kernel Profile.
- Kirti
-Original Message-
Sent: Wednesday, April 10, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
What does it stand for? Tool Kit Profiler???
tia,
David Nemeth
__
Do You Yahoo!?
Yahoo! Tax Center
Tool Kernel PROFiler
Anjo.
David Nemeth wrote:
What does it stand for? Tool Kit Profiler???
tia,
David Nemeth
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official
Anjo:
I always thought it Trace Kernel PROFile?
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Sent: Wednesday, April 10, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L
Tool Kernel PROFiler
Anjo.
David Nemeth wrote:
What does it stand for? Tool Kit
Do you have data in the tables that you are running the query againt?
You do have row count zero, so tkprof seems to count the rows but the
rows do not seem to be there or are not selected.
--- Baker, Barbara [EMAIL PROTECTED] wrote:
Oracle 7.3.4, OpenVMS 7.1
My tkprof report is missing
It usually means the cursor for that query
was not closed before the end of file (e.g.
SQL in pl/sql and you didn't do an exit
to get out of sql*plus) so Oracle never
got around to dumping the STAT lines.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
Set you 10046 trace at level 4 or 12, and then check the trace file.
Paul
-Original Message-
Sent: Friday, February 22, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L
Hi Listers,
I got the following statement in the tkprof output file :
update EMP set ENAME=:V001,EMPNO=:V002
Paul (or anyone) -
Is there a way to set the level within the session as:
alter session set sql_trace = true
Or do I have to start the session, start a SQLPLUS session, find the
session_id and run the procedure to set it on another session?
Dennis Williams
DBA
ORACLE-L
Subject: RE: Tkprof output
Paul (or anyone) -
Is there a way to set the level within the session as:
alter session set sql_trace = true
Or do I have to start the session, start a SQLPLUS session, find the
session_id and run the procedure to set
:
Sent by: Subject: RE: Tkprof.
[EMAIL PROTECTED]
om
:
Sent by: Subject: RE: Tkprof.
[EMAIL PROTECTED
Ayyappan --RTFM
--
On Mon, 04 Feb 2002 22:15:19
Rajesh Dayal wrote:
Just type tkprof on command line (DOS) or on shell prompt (UNIX),
You would find the help and all your doubts would be cleared.
HTH,
Rajesh
-Original Message-
Sent: Tuesday, February 05, 2002 9:15 AM
To: Multiple
Just type tkprof on command line (DOS) or on shell prompt (UNIX),
You would find the help and all your doubts would be cleared.
HTH,
Rajesh
-Original Message-
Sent: Tuesday, February 05, 2002 9:15 AM
To: Multiple recipients of list ORACLE-L
Hi all
I am having a doubt in how to use
in tkprof evaluation .
I have Generally Seen count-Execute EQUAL to count-Fetch , for Other
Traces
Thanks so much
-Original Message-
From: Bill Zakrzewski [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 1:59 AM
To: LazyDBA.com Discussion; VIVEK_SHARMA
Subject: Re
Title: RE: Tkprof output
A huge
thanks for all those who took the time out to respond to my problem. The query
ran to completion yesterday and (as I said to Lisa) I was later told that I was
not to worry as it was a one off migration (well that only wasted about 1- 2
hours of my time
Title: RE: Tkprof output
Lee,
This query seems suspect
UPDATE VM_LIVE.SINGLE_CUSTOMER_HISTORY SCH SET VISIBLE=1
WHERE
ACXIOM_CUSTOMER_KEY = :b1 AND VERSION_NO = :b2
because of this
call count cpu elapsed disk query current rows
Are you on 8i? Then you can use BULK binding which will definitely give you
some speed. IF you need example ... let me know.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
Title: RE: Tkprof output
Also note the
very high"query" number (i.e. buffers gotten for consistent read).
That could account for a lot of the i/o, which is the proximate cause of the
lng elapsed time. From the (to use one of Lisa's favorite terms) doco
(for 9i):
Read
Consist
Title: Message
Take a
look at using array fetches to retrieve rows more efficeintly. It appears
you are fetching 1 row at a time. Which can be grossly
inefficient.
Another helpful thing would to generate the TKPROF with Explan plans so
you can see the rows per step and the paths chosen.
Is your unix user id a member of the dba group? If not, that is your
problem. Have your dba grant read to world for that trace file, i.e.,
chmod 664 rapid_ora_14247.trc
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
Note that tkprof's execution plan shows execution plan against current
database connection to which tkprof is connected. So, execution plan in
trace file and execution plan in tkprof output may be different. And, I
guess, tkprof shows first execution plan. If your statement parsed more
than once,
On a development box, 'alter session' should not cause
too much harm. If you're concerned, write a package
as SYS which turns on tracing for the developers
session and just grant access on that...
You may want to look at _trace_files_public parameter
as well so they can see their trace files.
trace_on.sql
REM Script to turn TRACE MODE on for a selected SID.
set serveroutput ON size 2000;
set verify OFF;
DECLARE
r_sid NUMBER;
v_sid NUMBER;
v_serial NUMBER;
v_usernameVARCHAR(30);
v_status VARCHAR2(8);
v_server VARCHAR2(9);
p_server_pid
]
Subject: Re: tkprof and security?
Date: Wed, 09 May 2001 04:40:22 -0800
trace_on.sql
REM Script to turn TRACE MODE on for a selected SID.
set serveroutput ON size 2000;
set verify OFF;
DECLARE
r_sid NUMBER;
v_sid NUMBER;
v_serialNUMBER;
v_username VARCHAR
Rachel Carmichael wrote:
That's what I love about this list before I can answer, someone has
provided scripts to do things :)
Thanks Tim, I'm adding these to my scripts library
Rachel
Rachel,
Is that due to the speed of the list members, or the lag of the mail
server?
Paul
--
On Wed, 9 May 2001,Paul Drake scribbled on the wall in glitter crayon:
-Rachel Carmichael wrote:
-
- That's what I love about this list before I can answer, someone has
- provided scripts to do things :)
-
- Thanks Tim, I'm adding these to my scripts library
-
- Rachel
-
-
-Rachel,
-
-Is
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: tkprof and security?
Date: Wed, 09 May 2001 06:30:53 -0800
Rachel Carmichael wrote:
That's what I love about this list before I can answer, someone has
provided scripts to do things :)
Thanks Tim, I'm adding these to my
Hi,
I developed a web based tool which analyzing event
10046 traces. I'm currently looking for a java servlet
service provider.
this tool does:
- what tkprof does
Plus
- reports all execution plans for SQL statment(I
guess, tkprof reports first, but there is no guarantee
first and other
Hi Steve,
I've not checked recently, but Guy Harrison used to have one on his web site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Friday, 6 April 2001 1:52
To: Multiple recipients of list ORACLE-L
Hi,
When
Hi !
I have not seen any tool for formatting the wait event
stats. Steve Adams has some script in his book
(Oracle8i Internal Sevices page -16).
You can write a similar script and explore the trace
files.
=
Have a nice day !!
YES
THIS IS AN ORACLE FINANCIALS DATABASE - RULE BASED OPTIMIZER
-IM CURIOUS ABOUT THIS, BECAUSE I DOUBT THE EXPLAIN (Please NOO!!) - Has
anyone had rubbish back from EXPLAIN ?
SAM
-Original Message-
Sent: Thursday, February 08, 2001 12:17 PM
To: Multiple recipients of list
Hello,
Do you have timed_statistics = true in your init file ?
Regards
Henrik
Sam P. Roberts (ZADCO ITIS) wrote:
This is the output from tkprof
call count cpuelapsed disk querycurrent
rows
--- -- -- -- -- --
hello,
if EXPLAIN option is used, tkprof generates output
against current database statistics not against
statistics in raw file. this makes followings wrong:
- explain plan may be different than explain plan in
raw file since statistics may have changed after raw
file is generated.
- because
52 matches
Mail list logo