Re: how to monitor the progress of inserts

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • Date: Tue, 01 Feb 2005 18:09:09 -0700

At 03:50 PM 2/1/2005, Mladen Gogala wrote:
> > As Niall demonstrated so beautifully, there are no relational rules when
> > it comes to v$ views (actually the x$ "tables" upon which the views are
> > built).
>Yes, but then this statistics is meaningless. What does it mean to have 
>1000 inserts without any consequence to the table?

You have to use the v$ views in the context they are meant for. This 
particular table is meant to help dbms_stats to decide whether the 
statistics are "stale" and should be refreshed. It is NOT an audit view. If 
you talk about useless views this is a truly useless view, even if it 
didn't suffer from the demonstrated shortcoming. What does it mean to have 
1000 inserts, even if those inserts actually made into the table?? 
Statistics could be "stale" if much less than 10% of the content has 
"changed" and for other tables nothing changes materially in the statistics 
even if you exchange 100% for new data. I would never base statistics 
gathering on the content of this view.
PS. there are people who are very knowledgeable about Oracle who consider 
the data in many of the "cherished" v$ views as useless, meaningless, even 

>I wouldn't generalize just like that. I don't find V$SESSION_LONGOPS very 
>period. It has never helped me with anything. It most certainly did not 
>help me
>to see how much is left of any large job. While V$ tables in general are 
>useful, this particular one is useless.

Obviously our mileages vary. I use it frequently to see the progress of 
full scans and even calculate the estimated finish time. I generally find 
it more precise than Microsoft's progress bar. And as I said. if the 
progress is not linear but slows down ( who cares if it speeds up :-) ) 
then that is a good piece of information as well to go and find the cause 
for the slowdown.


Wolfgang Breitling
Centrex Consulting Corporation 


Other related posts: