Timed Statistics

[paandi]

Hi,

In one of my sessions i had issued the following statment to find out the elapsed time

SQL> set timing on;

SQL> select tname from tab;

After listing the table names, the following line is displayed
real : 491

Iam not getting the Elapsed: 00:00:03.45 message at all. Why is this so?. What does real mean?. How do i rectify this?

Thanks in Advance.

[jovery]

The display given when you issue SET TIMING ON is platform specific, judging by the output you are getting I would say your on Windoz.

The value presented is in milliseconds so in your example the result took 0.491 seconds

HTH