Re: TKPROF and Trace Files
From: Dave Mausner <dlm_at_dlogics.dlogics.com>
Date: Fri, 09 Jul 1993 10:51:54
Message-ID: <930709105154_at_dlpc030.dlogics.com>
Date: Fri, 09 Jul 1993 10:51:54
Message-ID: <930709105154_at_dlpc030.dlogics.com>
In article <C9u8y3.I1B_at_dcs.ed.ac.uk> pgk_at_dcs.ed.ac.uk (Paul Knights) writes:
> In the resultant files, however, the values in the "cpu" and "elap" fields
> never get above zero for any of the "parse", "execute" or "Fetch" steps.
>
You must set the init.ora parameter as follows and restart Oracle:
TIMED_STATISTICS = TRUE
-- Dave Mausner / Sr Consultant / Datalogics division of Frame Technology Inc 441 W Huron / Chicago IL 60610 / +1-312-266-4450 / "Just show me the code"Received on Fri Jul 09 1993 - 10:51:54 CEST