Re: Interesting SQL that displays time taken to do row count?

On Fri, 30 Sep 2005 16:36:30 +1000, Snewber <snew_at_snew.com> wrote:

>Does anyone know how to improve the above query, or write a new query in
>one SQL statement, so that you can get the followin

You should stop wasting your time on getting out any results which are already maintained in the v$ tables, and can be produced by tracing a session. You would better try to learn how Oracle works.

--
Sybrand Bakker, Senior Oracle DBA