Tim Gorman,
hi, in oracle 9i there is waits=y to print the wait time in the
tkprofed file, but in 7-8i, tkprof does not support this option.
Is there any script that can generate the wait time from the 10046 trace file?
Thanks.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
======= 2003-01-21 04:58:00 ,you wrote£º=======
>First, always use the SORT= option to generate TKPROF output -- the utility is
>useless if you don't sort the output. For sorting, I have two suggestions:
>
> * sort by "logical reads" (i.e. SORT=EXEQRY,FCHQRY,EXECU,FCHCU)
> * sort by "elapsed time" (i.e. SORT=PRSELA,FCHELA,EXEELA)
>
>If elapsed time data is available (i.e. TIMED_STATISTICS=TRUE in database), then I
>prefer to use that. If not, then I use logical reads...
>
>Second, if you are sorting the TKPROF output, then use the PRINT= option to limit the
>amount of output. The idea here is that you only care about the "worst" couple of
>SQL statements. Using PRINT=10 means that your TKPROF output will be limited to only
>10 statements...
>
>So, comparing two files that have been sorted and have only 10 statements is pretty
>easy to do just by looking at it...
>
>---
>
>As far as any problems loading into "tkprof_table", I can only guess that the user
>which you are running EXPLAIN PLANs into (using the EXPLAIN= option) does not have
>permission or space-quota to create a small temporary table in which to place EXPLAIN
>PLAN output. Check the permissions of the user you are specifying; log into
>SQL*Plus using the same user and try to create a small dummy table...
> ----- Original Message -----
> From: BanarasiBabu Tippa
> To: Multiple recipients of list ORACLE-L
> Sent: Tuesday, January 21, 2003 4:34 AM
> Subject: question on tkprof
>
>
> Hi gurus
>
> Anyone knows about the comparision of tkprof output of the trace files generated by
>same application in diffrent times
> and anyone have solution to Problem with pl/sql in insert script loading into
>tkprof_table.
>
> Thanks in advance
>
> Banarasi
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
