I did a check -- you have to have MONITORING on on the table you are
modifying for the view to be filled.
>From: "Ron Rogers" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Last Update
>Date: Tue, 17 Jul 2001 10:55:33 -0800
>
>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.0
>Oracle 8.1.7
>Your thoughts?
>ROR m���m
>
> >>> [EMAIL PROTECTED] 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 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hillman, Alex
> 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: Ron Rogers
> 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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).
