how can I find out how long a query runs

[tamilselvan]

No need to look at v$table.

set time on
set timing on
Set autot trace statis
and run your sql statement.

You will see the elpased time.

Tamil