Re: New SqlPlus type utility available for download

[Quoted] Daniel Morgan <dmorgan_at_exesolutions.com> writes:
> Now that you bring it up there has been a long standing
> problem with SQL*Plus ... in fact so long standing that
> I've gotten tired of mentioning it. What is wrong with
> providing useful timing information when someone does SET
> TIMING ON?
By 'useful' do you mean including statement parsing timing? Or is there an issue with the documentation or output messages?

> I've yet to meet anyone that can accurately interpret the
> results (well perhaps excepting Tom Kyte and we haven't
> met).

[Quoted] Solaris (and Windows since about 8.0 or 8.1) give a single elapsed time from end to end:

    SQL> set timing on
    SQL> execute dbms_lock.sleep(5);

    PL/SQL procedure successfully completed.

[Quoted]     Elapsed: 00:00:05.33
    SQL> The string is hours:minutes:seconds, with seconds being shown to two decimal places. The extra 0.33 of a second in this example is the overhead of SQL*Plus, the network and the server (I'd just started the database).

The output is port specific, depending on the low level timing functions available. By now (meaning now that UNIX libraries and ports have settled down), most UNIXes should have the same output as Solaris. I don't know what message is printed on platforms I don't have much contact with e.g z/OS.

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.