Query the following statement in any instance to get the path of files from which the TKPROF is created.Oracle Trace Analyzer is TKPROF on SteroidsThose TKPROF numbers appear quite different translation it you do not like the numbers produced by TKPROF, just use a different version of TKPROF. Once the concurrent program is completed successfully, copy the Request id and paste it in the following query: 4. Run the concurrent program. Open Your Concurrent Program and check on Enable Trace.
Statspack type of information) as well as all the details found on TKPROF including a very nice explain plan. The HTML report contains information about the Oracle instance (i.e. Why is Trace Analyzer better than TKPROF?Trace Analyzer is a utility that reads a raw SQL Trace generated by standard SQL Trace or by EVENT 10046 (Level 4, 8 or 12), and generates a comprehensive HTML report with performance related details.
Trace Analyzer is intalled. Please check tacpkg.lis for any errors.That's it. Enter value for temporary_tablespace: TEMPTACPKG complete.
Provides the hottest blocks, optimizer statistics for indexes and tables and other information not available through TKPROF. Provides the actual values of the bind variables in SQL. This generates the Trace Analyzer HTML report into your local client directory using SPOOL SQL> xe_ora_832.trcTrace Analyzer Report "trcanlzr_832_1.html" has been created in C:/ORACLEXE/APP/.report "trcanlzr_832_1.html" has been copied into local directoryDisconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - ProduC:/oraclexe/app/oracle/product/10.2.0/server/trca>And here is the Trace Analyzer HTML report.Why is Trace Analyzer better than TKPROF?Trace Analyzer is better than TKPROF because It: Now, execute the trcanlzr.sql script passing the trace file name as the parameter.
Moreover, TKPROF executes more quickly than Trace Analyzer, but that's because Trace Analyzer does more analysis than TKPROF. Generates an HTML report that is more readable and extensive than the text output generated by TKPROF.However, unlike TKPROF, Trace Analyzer requires objects in the database and that means more configuration work on each database that needs the utility installed. Provides more detailed wait event information.
0 kommentar(er)
