Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> FYI : DBMS_STATS.FLUSH_SCHEMA_MONITORING_INFO not available

FYI : DBMS_STATS.FLUSH_SCHEMA_MONITORING_INFO not available

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 18 Aug 2003 14:40:24 +0100
Message-ID: <cH40b.27992$pK2.43755@news.indigo.ie>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US