Re: status when running an long run insert query

Why not log onto another SQL*Plus session and do a count(*) of some of the tables in question?

Mark

fluo_at_stirlingdouglas.com (frank12345) wrote in message news:<5025b594.0106271554.386becec_at_posting.google.com>...
> "Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:<3B38CB77.60A0EA0D_at_attws.com>...
> > frank12345 wrote:
> >
> > > Hi Guys,
> > >
> > > Could you guys give me some hints for following question?
> > > How to check how many rows have been processed while running a long
> > > run insert query?
> > > I want to monitor the increasing row number.
> > >
> > > Thank you in advance.
> > >
> > > Frank
> >
> > In a cursor loop or just one big INSERT statement?
> >
> > Daniel A. Morgan
>
> Sorry to confuse your guys.
>
> It is NOT an insert query running many times.
>
> It only one INSERT statement with a bunch of out and inner join for
> data warehouse program. It usually runs about 8 hours. I need some way
> to monitor the progress for executing this kind of query.
>
> Frank
Received on Thu Jun 28 2001 - 05:19:52 CDT