RE: Last Update

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 17 Jul 2001 11:15:07 -0700
Message-ID: <F001.0034C87A.20010717112040@fatcity.com>

you need to have turned monitoring on the the table(s).

alter table <tablename> monitoring;

joe

>>> RROGERS_at_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_at_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_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.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-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.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_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.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_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: Hillman, Alex INET: Alex.Hillman_at_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_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:
Ron Rogers INET: RROGERS_at_galottery.orgFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing

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