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 h
: 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
, 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
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 ORACLE-
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 tutorials:
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-
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
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: Wed
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
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
>
> Th
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
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
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 l
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 chec
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
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 100
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 dat
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
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
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! Ta
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 P
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 offic
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
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 mis
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
http://ww
Multiple recipients of list 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 th
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
Lifeto
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"=:V
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: M
>
>ecom.com>cc:
>
>Sent by: Subject: RE: Tkprof.
>
>[EMAIL PROTECTED]
-1002
Rajesh Dayal
ecom.com>cc:
Sent by: Subject
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 Tkp
9 AM
> To: LazyDBA.com Discussion; VIVEK_SHARMA
> Subject: Re: tkprof Trace Output Evaluation
>
> I quickly looked at your query and one improvement you can make is to
> remove
> the
>
> "WHERE B.sol_id
> in (
> SELECT sol_id from SST WHERE set_id =
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: 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.
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):
Re
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 h
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
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
desp
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,
[EMAIL PROTECTED]
>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
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 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?
Pa
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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
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 V
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.
h
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 executi
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 !!
Be
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
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 ORACLE
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 of
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
> --- -- -- -- -- ---
52 matches
Mail list logo
