RE: Last Update

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 17 Jul 2001 10:54:56 -0700
Message-ID: <F001.0034C7C0.20010717110123@fatcity.com>

8.1.7 on aix, it exists just fine.

joe

>>> lhoska_at_calibresys.com 07/17/01 01:57PM >>>Guys,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_at_fatcity.com AT
INTERNET_at_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 <Shreepad.Vaidya_at_alltel.com>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_at_fatcity.com AT> INTERNET_at_CCMAIL>
cc:>>>> alter table monitoring.> --- Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>> 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_at_fatcity.com AT> >
INTERNET_at_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:> > <A
href="http://www.orafaq.com">http://www.orafaq.com> > -->
> Author: Erik Williams> >   INET:

ewilliams_at_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_at_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_at_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_at_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_at_yahoo.com> ctrassens_at_hotmail.com> Phone : 541149816062>>

__________________________________________________> Do You

Yahoo!?> Get personalized email addresses from Yahoo! Mail> <A href="http://personal.mail.yahoo.com/">http://personal.mail.yahoo.com/> --> Please see the official ORACLE-L FAQ:> <A href="http://www.orafaq.com">http://www.orafaq.com> --> Author: Christian Trassens> INET:
ctrassens_at_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_at_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:> <A
href="http://www.orafaq.com">http://www.orafaq.com> --> Author: Shreepad Vaidya> INET:
Shreepad.Vaidya_at_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_at_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_at_yahoo.comctrassens_at_hotmail.comPhone :

541149816062__________________________________________________Do You

Yahoo!?Get personalized email addresses from Yahoo! Mail<A href="http://personal.mail.yahoo.com/">http://personal.mail.yahoo.com/--Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com--Author: Christian Trassens INET: ctrassens_at_yahoo.comFat 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_at_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: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author: Shreepad Vaidya INET: Shreepad.Vaidya_at_alltel.comFat 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_at_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_at_calibresys.comFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

Lists--------------------------------------------------------------------To