Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dba_tab_modifications question

RE: Dba_tab_modifications question

From: Deshpande, Kirti <>
Date: Thu, 16 May 2002 07:38:30 -0800
Message-ID: <>

Precisely :)

-----Original Message-----

Sent: Thursday, May 16, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L

So DBA/ALL/USER_TAB_MODIFICATIONS cannot be used to determine an accurate count of how many records were updated, but it can used to determine if the table has been updated, and give you a general feel of how much has been updated.

AND is used by the GATHER STALE parameter in DBMS_STATS.GATHER_SCHEMA_STATS to determine which tables have been updated, and therefore may have stale statistics and need to have their stats refreshed.

With these features setup you can basically throw away your nightly "analyze everything" process and use a more intelligent approach. Very cool.

-----Original Message-----

Sent: Wednesday, May 15, 2002 9:28 PM
To: Multiple recipients of list ORACLE-L

True, there is such a latch (so, Gopal is right :) However, this latch is to protect the hash table structure where these modification counts are kept.
The updating of these counters is still done without acquiring any other latches (so, John is right :)
Also, a transaction can be rolled back, but the affected modification counts from this hash table can not be rolled back. So the modification counts can be different due to rolled back transactions and updating counters without latch protection (as John explained).

Cheers !

-----Original Message-----

Sent: Wednesday, May 15, 2002 6:18 PM
To: Multiple recipients of list ORACLE-L


Not being so choosy, MONITORING is subject to latching. There is a latch called 'hash table allocation/modification latch' which keeps the modification in the shared pool and SMON periodically flushes to the disk.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA

Please see the official ORACLE-L FAQ:
Author: Deshpande, Kirti

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Thu May 16 2002 - 10:38:30 CDT

Original text of this message