From JTESTA@longaberger.com Tue, 17 Jul 2001 11:15:07 -0700 From: "JOE TESTA" Date: Tue, 17 Jul 2001 11:15:07 -0700 Subject: RE: Last Update Message-ID: MIME-Version: 1.0 Content-Type: text/plain you need to have turned monitoring on the the table(s).   alter table monitoring;   joe   >>> RROGERS@galottery.org 07/17/01 02:55PM >>>Alex,I did a describe on sys.dba_tab_modifications and it shows a lot of info. I select * from the view and no rows were returned but I have inserted and truncated a lot of data this morning. Does it matter the userid doing the work? I have created a userid that has the insert, del, update, sel privs on the tables that get changed each morning.OS linux 7.0Oracle 8.1.7Your thoughts?ROR mª¿ªm>>> Alex.Hillman@usmint.treas.gov 07/17/01 02:20PM >>>It is not a table - it is a view owned by sys. And it exists only in 8i+Alex Hillman-----Original Message-----Sent: Tuesday, July 17, 2001 1:58 PMTo: Multiple recipients of list ORACLE-LGuys,can you please confirm to me you found dba_tab_modifications table.  Ichecked 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 AMTo: Multiple recipients of list ORACLE-LHi,Thanks for the clarification.   Always welcome.          shreepadTo:   Shreepad Vaidya/EMEA/ALLTELCORP, ORACLE-L@fatcity.com AT      INTERNET@CCMAILcc:However you can query the view dba_tab_modificationsfor checking when and how manyupdates/deletes/inserts/truncate have been done on thetable. If this is enough, great, don't you think so ?.Regards.--- Shreepad Vaidya 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,> ORACLE-L@fatcity.com AT>       INTERNET@CCMAIL> cc:>>>> alter table monitoring.> --- Shreepad Vaidya > 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,> > ORACLE-L@fatcity.com 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: ewilliams@brownco.com > >> > 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: ListGuru@fatcity.com (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: Shreepad.Vaidya@alltel.com > >> > 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: ListGuru@fatcity.com (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> ctrassens@yahoo.com > ctrassens@hotmail.com > 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: ctrassens@yahoo.com >> 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: ListGuru@fatcity.com (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: Shreepad.Vaidya@alltel.com >> 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: ListGuru@fatcity.com (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 TrassensSenior DBASystems Engineerctrassens@yahoo.com ctrassens@hotmail.com Phone : 541149816062__________________________________________________Do You Yahoo!?Get personalized email addresses from Yahoo! Mailhttp://personal.mail.yahoo.com/ --Please see the official ORACLE-L FAQ: http://www.orafaq.com --Author: Christian Trassens  INET: ctrassens@yahoo.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya  INET: Shreepad.Vaidya@alltel.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:   INET: lhoska@calibresys.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex  INET: Alex.Hillman@usmint.treas.gov Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ron Rogers  INET: RROGERS@galottery.orgFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).