RE: Insert Rate/Second

• Bruce McCartney <bruce.mccartney_at_dbinfosystems.com> 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