Re: Count Dataset by Insert

Bernd Joeckel wrote in message <36370D27.20CE_at_pcm.bosch.de>...
>I want to count the dataset during SQL- Insert statement.
>There had to be a possibility to do this at once ??

Not exactly sure what you want to do. If you want to run a large insert job and monitor the process to see how many rows have been inserted thus far, look at the V$SESSTAT table. It contains session statistics. Look up the stats for the session doing the insert. I'm sure there's something there that can be used as an indication of the progress of the insert. Maybe you can use the stat containing the number of bytes transmitted from the client to the server and divide that by the average rowsize of the inserted rows. That should give a rough indication.

regards,
Billy Received on Thu Oct 29 1998 - 01:38:28 CST