John: 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 ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 4:23 AM > Prakash, > > My understanding is that the updation of counts for MONITORed tables is done > without using latching, so that normal DML is not held up by some additional > latches. This will explain the small difference that you are seeing, i.e. > the counting of some INSERTs were missed due to race conditions that could > have otherwise been prevented by latches. > > Am I as clear as mud or what! > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > The manuals for Oracle are here: http://tahiti.oracle.com > The manual for Life is here: http://www.gospelcom.net > > ** The opinions and statements above are entirely my own and not those of my > employer or clients ** > > > > -----Original Message----- > > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 12:33 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Dba_tab_modifications question > > > > > > Hey Prakash, > > > > I never knew about that dictionary table, so I looked it up > > and found... > > > > These views describe tables that have been modified since the > > last time > > table statistics were gathered on them. The views are > > populated only for > > tables with the MONITORING attribute. They are not populated > > immediately, > > but after a time lapse (usually 3 hours). > > > > Perhaps that explains the diff. Check it out. > > > > Chris > > > > -----Original Message----- > > Sent: Wednesday, May 15, 2002 1:03 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hello, > > > > Oracle 8.1.6 on HP-UX 11.0 > > > > WFM_ADMIN@VGRAFO> select num_rows,last_analyzed,monitoring > > from user_tables > > where table_name = 'NOTES_LOG'; > > > > NUM_ROWS LAST_ANAL MON > > ------------------- ---------------- ------- > > 1585697 14-MAY-02 YES > > > > Last night, Informatica inserted rows into this table. > > > > 1 select inserts,updates,deletes from dba_tab_modifications > > 2* where table_name = 'NOTES_LOG' > > WFM_ADMIN@VGRAFO> / > > > > INSERTS UPDATES DELETES > > -------------- -------------- --------------- > > 6509 0 0 > > > > WFM_ADMIN@VGRAFO> select count(*) from notes_log; > > > > COUNT(*) > > ---------- > > 1592488 > > > > The difference between yesterday's and today's count is 6791 > > which does not > > match the number in dba_tab_modifications. > > > > Does this mean that I cannot rely on dba_tab_modifications? > > > > > > TIA > > Prakash > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: BALA,PRAKASH (Non-HP-USA,ex1) > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Grabowy, Chris > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
