Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> FYI : DBMS_STATS.FLUSH_SCHEMA_MONITORING_INFO not available
doc error ? (9.2)
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats2 .htm#1012858
but FLUSH_SCHEMA_MONITORING_INFO doesn't exist (9202) .
Someone on metalink's noticed it (forum thread ) but it doesn't seem to be a bug yet;
FLUSH_DATABASE_MONITORING_INFO seems to work just fine. - at least my USER_TAB_MODIFICATIONS has been updated.
Is 10 mins the default for the flush from the SGA to the dictionary if you don't flush yourself ?
HTH
Telemachus.
Received on Mon Aug 18 2003 - 08:40:24 CDT