Percentage of execution for single statements

From: Fabrizio <Fabrizio_Semadeni_at_yahoo.com>
Date: 29 May 2002 02:27:17 -0700
Message-ID: <c71992f2.0205290127.45e96b20@posting.google.com>

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 - 04:27:17 CDT