Re: Measuring SQL execution time ?

Hi,

The SQL trace facility generates trace files per session that report CPU consumed for execution and fetch time. The tkprof utility formats the output of the trace.

Under Oracle 7.2 the DBA can turn trace on for a selected session. Under 7.0 each session must turn on trace himself. Under 7.1 who knows?

The trace facility requires TIMED_STATISTICS = TRUE in your init.ora for complete information.

You'll have to find a way to simulate a load. We use PreView, which is powerful, precise, and major maintenance/learning curve problem.

Jim
==

ceham_at_w3eax.umd.edu (Maurice De Vidts NE3S) wrote:
>Hi,
>
>I am interested in timing some SQL calls for a hardware comparison,
>and I am aware of the timing function in SQL. The problem is
>this is actual clocked time, from start to finish. It includes
>time the CPU may have used to do other things and serve other users.
>
>Is there any other way to measure CPU cycle associated with this call >?
>
>
>I am also wondering if there is an easy way to simulate a large user load
>and make timing measurements "under load".
>
>Any pointers, and sugestions will be appreciated !
>
>Maurice De Vidts
>ceham_at_w3eax.umd.edu

Jim

-- 

=============================

Jim Peterson
TDS Computing Services
Madison, WI USA
james.peterson_at_teldta.com