First page Back Continue Last page Summary Graphics
TKPROF and trace
Trace resource consumtion of SQL scripts with TKPROF
Together with EXPLAIN PLAN a good overview of the load may be aquired
For detailed information see database.804/a58246/strace.htm
Check ora.ini on Oracle server:
- TIMED_STATISTICS to true
- MAX_DUMP_FILE_SIZE
- USER_DUMP_DEST
Notes: