RE: question on tkprof

Thank you very much Tim for your solution for the first question.  

Comming to second, that is not my problem. I was unable to load the data generated by tkprof when INSERT option is used into tkprof_table. Most of the PL/SQL blocks are rejected. I searched for the same in metalink, they are saying that is a bug, but it was closed saying that this is a problem with SQL*Plus. They are suggesting to run from server manager but it's also unable do it and gving the MGR-11401 error.  

regards
Banarasi Babu

-----Original Message-----
Sent: Tuesday, January 21, 2003 6:29 PM
To: Multiple recipients of list ORACLE-L

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 ----- 
To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com>  
Sent: Tuesday, January 21, 2003 4:34 AM

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: BanarasiBabu Tippa
  INET: btippa_at_ORsoftware-india.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).