Re: Duration of request

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 15 May 2001 23:07:45 -0700
Message-ID: <3B021931.3B28C2B8@exesolutions.com>

Jack wrote:

> Hi
> Is there a way in Oracle 8i (tuners, history, analyzer) of finding out the
> duration of individual SQL statements running on a system?
>
> Thanks

If run from SQL*Plus just type the following at the beginning of your session.

SET TIMING ON Daniel A. Morgan Received on Wed May 16 2001 - 01:07:45 CDT

This message: [ Message body ]
Next message: Ashlar: "Medical Databases?"
Previous message: Jack: "Duration of request"
In reply to: Jack: "Duration of request"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US