Re: count(*) to get timing on tuned SQL

From: Isaac Blank <izblank_at_yahoo.com>
Date: Mon, 21 Jul 2003 15:55:24 GMT
Message-ID: <M1USa.225$O5.21137654@newssvr14.news.prodigy.com>

Here's an example of what I usually collect in my GUI-based tool in addition to execution time:

physical reads
physical writes
table scans (short tables)
table scans (long tables)
table scan rows gotten
table scan blocks gotten
table fetch by rowid

sorts (memory)
sorts (disk)
sorts (rows)

session logical reads
CPU used by this session

"rohit" <rohitk1973_at_yahoo.com> wrote in message news:74353ecc.0307210717.3a60429f_at_posting.google.com...
> Thanks Turk.
>
> Issac:
> I can follow your solution, but I am not sure what you mean by
> "statistics on PL/SQL block", do you mean time the block by setting
> timing on?
>
Received on Mon Jul 21 2003 - 10:55:24 CDT