Re: Procedural Code Profiling

--- "korry.douglas" <korry.douglas@enterprisedb.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
----------------------------------------------------------