RE: Insert Rate/Second

--- Bruce McCartney
<bruce.mccartney@xxxxxxxxxxxxxxxxx> wrote:

> Mohammed,
> Good question.  I can't remember the specifics,
> other that it made it work
> :) 
> I think it had something to do with a delay in stats
> appearing due to some
> timeout in smon; 
Yes, that makes sense now that I've looked at some
Metalink notes.  

dbms_stats.FLUSH_DATABASE_MONITORING_INFO() will also
flush the info immediately.

> Let me know if you think
> something is wrong...
No, seems to work very well in fact.

Thanks

--
mohammed


                
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: