Re: check how many rows processed of a sql statement

David,

You want to TRACE your SQL Statement and then run those results through TKPROF. This will give you the info. you desire.

John

David Shi wrote in message <6nrnj5$s6j$0_at_204.179.92.135>...
>Thanks Tom, I was actually wondering whether it is possible to check before
a
>long-running sql statement get finished, that how many rows has been
processed,
>which gives me an idea about how far is the job. Is this possible?
>
>David
>
>On Mon, 06 Jul 1998 14:09:16 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:
>
>>A copy of this was sent to dshi_at_magpage.com (David Shi)
>>(if that email address didn't require changing)
>>On 6 Jul 1998 01:07:27 GMT, you wrote:
>>
>>>Is there a way to check how many rows processed of a sql statement?
Thanks.
>>>
>>>David
>>
>>depends on the language.
>>
>>In C and Pro*C sqlca.sqlerrd[2] has it.
>>
>>In PL/SQL with 'static' sql, sql%rowcount after an insert/update/delete
has it.
>>
>>In PL/SQL with 'dynamic' sql, dbms_sql.execute returns it as a value...
>>
>>
>>
>>Thomas Kyte
>>tkyte_at_us.oracle.com
>>Oracle Government
>>Herndon VA
>>
>>http://govt.us.oracle.com/ -- downloadable utilities
>>
>>--------------------------------------------------------------------------
--
>>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>>
>>Anti-Anti Spam Msg: if you want an answer emailed to you,
>>you have to make it easy to get email to you. Any bounced
>>email will be treated the same way i treat SPAM-- I delete it.
>
Received on Mon Jul 06 1998 - 13:10:12 CDT