Re: Procedural Code Profiling

--- "korry.douglas" <korry(dot)douglas(at)enterprisedb(dot)com> wrote:

> execution count (number of times each statement is executed)
> total execution time (how long did we spend executing each
> statement?)
> longest execution time (how long did the slowest iteration
> take?)
> number of scans (total number of sequential and indexed scans)
> blocks fetched (for each statement)
> blocks hit (blocks found in buffer pool) (for each statement)
> tuples returned (for each statement)
> tuples fetched (for each statement)
> tuples inserted (for each statement)
> tuples updated (for each statement)
> tuples deleted (for each statement)
>

Sweet. This is exactly what I was looking for.

Thanks,

LewisC

-----------------------------------------------------------
Lewis R Cunningham

An Expert's Guide to Oracle Technology
http://blogs.ittoolbox.com/oracle/guide/

LewisC's Random Thoughts
http://lewiscsrandomthoughts.blogspot.com/

EnterpriseDB: The Definitive Reference
http://tinyurl.com/39246e
----------------------------------------------------------