Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_stats automatic collection in 10g
>From the 9.2 DBA Administrators Guide, Ch 15, Managing Tables
>> Monitoring tracks the approximate number of INSERT, UPDATE, and DELETE operations for the table since the last time statistics were gathered. Information about how many rows are affected is maintained in the SGA, until periodically (about every three hours) SMON incorporates the data into the data dictionary. This data dictionary information is made visible through the DBA_TAB_MODIFICATIONS,ALL_TAB_MODIFICATIONS, or USER_TAB_MODIFICATIONS views.
<<
You do not mention gathering statistics and how long is "a bit". (1/8 of a byte 8-D )
HTH -- Mark D Powell -- Received on Thu May 11 2006 - 15:36:45 CDT