Home » SQL & PL/SQL » SQL & PL/SQL » difference between sql_trace and dbms_profiler
difference between sql_trace and dbms_profiler [message #186277] Mon, 07 August 2006 05:00
Messages: 7
Registered: August 2006
Location: banglore
Junior Member

What is the main difference between the data collected by
sqltrace and dbms_profiler package.

i know that if we make sql_trace=true than trace file will be generated and if we start profiling the session using dbms_profiler.start_profiler than data will be gathered into tables.

i want to know that is there any difference between information gathered by both utilities

Thanks in advance
Previous Topic: External tables with System tablespace performance issue
Next Topic: Column heading query
Goto Forum:

Current Time: Thu Oct 27 02:38:49 CDT 2016

Total time taken to generate the page: 0.10582 seconds