Chris, this table was modified around 3am and I checked this view around
10am. Maybe I need to create a TAR.
Prakash
-----Original Message-----
Sent: Wednesday, May 15, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
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: 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).
