Re: display speed of queries?
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 28 Feb 2005 16:13:53 +0100
Message-ID: <cvvcb7$32j$1_at_news6.zwoll1.ov.home.nl>
Date: Mon, 28 Feb 2005 16:13:53 +0100
Message-ID: <cvvcb7$32j$1_at_news6.zwoll1.ov.home.nl>
Ian wrote:
> Hi,
> Am relatively new to Oracle,
> Is there a way to display the speed of queries - how long it took?
> Useful for testing/comparing efficiency
> regards
> Ian
> estacey_at_chariot.net.ZZ
> change ZZ to au if you want to direct reply.
>
>
Don't cross-post to every oracle ng you found, please.
Assuming you use SQL*Plus, issue: set timing on
before you execute the query.
There are a lot of possibilities; documentation can be
found on http://docs.oracle.com
-- Regards, Frank van BortelReceived on Mon Feb 28 2005 - 16:13:53 CET