Re: Percentage of execution for single statements

Hi

Thanks for the answers... however I still need help.

I did some tracing while updating
records in a single table (1000 to 3000 ).

1. In the view $session_longops, I retrieved ELAPSED_SECONDS values that do not correspond to reality (order of 400 M) Mabe the information is not accurate for small a amount of records to update.
2. In the view v$transaction, I did not find any direct relationship between the amount of records that are updated and the different values that shoud be of interest for me (USED_UREC, PHY_IO, CR_GET ...)

Any hints/suggestions are welcome
Fabrizio

qcom_at_attbi.com (MS) wrote in message news:<a2b6d46b.0205290926.5a3ec2fc_at_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 Mon Jun 03 2002 - 10:42:23 CDT