Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Percentage of execution for single statements

Re: Percentage of execution for single statements

From: MS <qcom_at_attbi.com>
Date: 29 May 2002 10:26:29 -0700
Message-ID: <a2b6d46b.0205290926.5a3ec2fc@posting.google.com>


You won't get percentage of execution, but you would get information about the number of records processed and things of that nature from v$transaction.

-Madhu S
Fabrizio_Semadeni_at_yahoo.com (Fabrizio) wrote in message news:<c71992f2.0205290127.45e96b20_at_posting.google.com>...
> Hi
>
> I'm working in a NT environment, with a Java Application
> that communicates with an Oracle 8i database via JDBC (java 1.3.1).
>
> I need to know the percentage of execution of single statements
> that take a long time to execute (e.g. update of a large amount of rows).
> The goal is to inform the user, so that he does not think the
> application as hung up.
>
> Is there any information that could be retrieved from a system table
> about the percentage of execution of statements?
>
>
> Thanks in advance for help/hints
>
> Fabrizio
Received on Wed May 29 2002 - 12:26:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US