Re: Performance estimation

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 6 Oct 2000 15:09:31 +0100
Message-ID: <8rkmev$rbv$1@soap.pipex.net>

I was not clear enough. I didn't mean that it did give performance statistics, as you say and my original post said the standard tuning tools are what do that. It does however give you an estimated completion time for the work a session is currently doing.

Niall
<kal121_at_my-deja.com> wrote in message news:8rgf9r$sa1$1_at_nnrp1.deja.com...
> In article <8rft5l$b27$1_at_soap.pipex.net>,
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
> > However it appears that what I wrote was incorrect as of 8i. The new
dynamic
> > performance view v$session_longops appears to do exactly this.
>
> This view is used in conjunction with the dbms_application_info package
> for tracking long running jobs. It does not give you query performance
> statistics.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 06 2000 - 09:09:31 CDT