Re: Query Timings

You need to set SQL_TRACE=true for that session or globally in the init.ora. For the session, use the command ALTER SESSION SET SQL_TRACE=true. You must also have TIMED_STATISTICS=true in the init.ora. Then, when you run a query, it will generate a trace file in the user_dump_dest directory. This is a raw trace file. You will then need to use tkprof to format the trace file. In 7.1, look at the Application Developer's Documentation. In 7.2, take a look at the Server Tuning Doc.

Raju Patel
Senior Database Consultant
Elite Systems Integrators
rpatel_at_hooked.net

Jerry Bull <gbbull_at_denitqm.mnet.uswest.com> wrote:
>We are doing some performance tuning of some SQL statements in a
>package. We would like to access the timing and other information
>about these statements, such as CPU time, Disk and Buffered I/O, etc.
>Is there an easy way to access this information both before and
>after an individual SQL statement.
>
>Thanks.
>
>Jerry.
>
>---------------------------------------------------------------------
>Jerry Bull, Sr. MTS voice: (303) 624-3073
>U S WEST Information Technologies fax: (303) 624-8462
>931 14th Street, Suite 920 email: gbbull_at_uswest.com
>Denver, CO 80202
>---------------------------------------------------------------------
Received on Fri Jan 05 1996 - 00:00:00 CET