Re: Record row count and execution time into table?

Snewber wrote:
> Thanks for the link.
>
> My real question is what is the easiest way to find out how long it
> takes to count the rows in each table as well.

Is that really your real question? I'm trying to understand what purpose   a query like yours serves.

you also forgot the columns for number of concurrent users, load on server and all the other variables.

> So, the output would look like this:
>
> OWNER TABLE_NAME NUM_ROWS SECONDS
> -------- ----------------- -------- -------
> OWNERX ACS_APPL_SERIES1 314 0.02
> OWNERX ACS_APPL_SERIES2 314 1.21
> OWNERX ACS_GEN 1 0.01
>

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com