RE: Last Update

[JOE TESTA]

8.1.7 on aix, it exists just fine.   joe   >>> [EMAIL PROTECTED] 07/17/01 01:57PM >>> Guys, can you please confirm to me you found dba_tab_modifications table.  I checked both 7.3.4 and 8i versions and I don't seem to find the table. Thank you. -----Original Message----- Sent: Tuesday, July 17, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Hi, Thanks for the clarification.   Always welcome.           shreepad To:   Shreepad Vaidya/EMEA/ALLTELCORP, [EMAIL PROTECTED] AT       INTERNET@CCMAIL cc: However you can query the view dba_tab_modifications for checking when and how many updates/deletes/inserts/truncate have been done on the table. If this is enough, great, don't you think so ?. Regards. --- Shreepad Vaidya <[EMAIL PROTECTED]> wrote: > > > Hi, > > This is what is mentioned in the manual. > Alter table MONITORING >  specifies that Oracle can collect modification > statistics on table. >  These statistics are estimates of the number of > rows affected by DML > statements over a particular period of time. > They are available for use by the optimizer or for > analysis by the > user. > > I think erik is looking out for the date and time > when the DML > occurred.  , > whereas the monitoring clause woud give the  rows > affected  . > > Hope my interpretation is correct. > >                     shreepad > > > > > > To:   Shreepad Vaidya/EMEA/ALLTELCORP, > [EMAIL PROTECTED] AT >       INTERNET@CCMAIL > cc: > > > > alter table monitoring. > --- Shreepad Vaidya <[EMAIL PROTECTED]> > wrote: > > > > > > Hi Erik, > > > > Check out the dba_objects tables. > > There is a column called as Last_ddl_time , which > > will give the ddl > > time.  But if you want to capture > > select,insert,delete,update > > times ? > > I guess you will have to write trigger and capture > > the times. > > > > > > > > HTH > > > >                     shreepad > > > > > >                     shreepad > > > > > > > > > > To:   Shreepad Vaidya/EMEA/ALLTELCORP, > > [EMAIL PROTECTED] AT > >       INTERNET@CCMAIL > > cc: > > > > > > > > How can I tell when a table was last updated? I am > > able to tell when > > it is > > last anylized, but I am looking for the date of > the > > last DML on the > > table. > > > > Thanks > > Erik > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Erik Williams > >   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: Shreepad Vaidya > >   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). > > > ===== > Eng. Christian Trassens > Senior DBA > Systems Engineer > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : 541149816062 > > __________________________________________________ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Christian Trassens >   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: Shreepad Vaidya >   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). ===== Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens   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: Shreepad Vaidya   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:   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).