Re: Re: question on tkprof

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:chao_ping_at_163.com
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: chao_ping_at_vip.163.com

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: ListGuru_at_fatcity.com (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).