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-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 6:29 PMTo: Multiple recipients of list ORACLE-LSubject: Re: question on tkprof 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
Re: question on tkprof
As a test I took a *trc file generated on a V7.3.4.5 DB and copied it to a system where I have a "dataless" 9i copy of the same DB. I used TKPROF from 9i & got all the wait statistics reported along with the relevant EXPLAIN PLAN! HTH & YMMV HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
Re: Re: question on tkprof
Three options: * use the "Hotsos Profiler" trace analysis tool from http://www.hotsos.com * use the "itrprof" trace analysis tool from http://www.ubtools.com * copy a TKPROF executable from an Oracle9i release and run (through SQL*Net!) against your earlier database. Not guaranteed to work, of course, but it could be worth a try... ** if you are on UNIX and are comfortable with the "make" utility, copy the "s0kvpf.o" object file from the "$ORACLE_HOME/rdbms/lib" on an Oracle9i software distribution and copy it to your own target RDBMS version's "$ORACLE_HOME/rdbms/lib" (making sure to save the existing file first, of course). Then, attempt to relink the TKPROF executable using "make -f ins_rdbms.mk itkprof" from the "OH/rdbms/lib" directory... Cary Millsap and Jeff Holt (of www.hotsos.com) have found lots of anomalies in Oracle ".trc" files, so they have compensated for these in their tool and Cary is about to publish a book that explains many of them. Gazi Unal-Bilism of www.ubtools.com has had his itrprof tool available as a service from the web and has been including WAIT information in his analysis for quite a while... Of course, the third option is entirely at your own risk. Whether that is attractive to you or not makes for an interesting discussion on its own! :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 7:14 AM > 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). > -- Please see the official ORACLE-L FAQ: http://
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:[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).
Re: question on tkprof
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
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
