Postprocessing with TKPROF
After the trace file has been created, you can process it using TKPROF, which takes the trace file as input and generates multiple output files. These include:
A log file containing the formatted information from the PLAN_TABLE, and statistics about the processing of each SQL statement.
A SQL script containing the processed SQL statements. This file can be used to replay the statements after making changes to the database.
A SQL script that inserts into a table information about each statement. This table can then be used to generate your own statistics and reports.
Actually, by default, TKPROF uses a plan table, with the name PROF$PLAN_TABLE. You can override this default by specifying any table with the same structure as the PLAN_TABLE. Full syntax for running TKPROF can be found in Oracle Corporation’s guide, Oracle8 Server Tuning.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
