| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Last Update
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" <RROGERS_at_galottery.org>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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
>
> >>> 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 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, ORACLE-L_at_fatcity.com AT
> INTERNET_at_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 <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:
> > > 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
> > http://personal.mail.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> > 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:
> > 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
>http://personal.mail.yahoo.com/
>--
>Please see the official ORACLE-L FAQ: 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: 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).
>--
>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-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: Hillman, Alex
> INET: Alex.Hillman_at_usmint.treas.gov
>
>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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
>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: Rachel Carmichael INET: carmichr_at_hotmail.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).Received on Tue Jul 17 2001 - 13:11:58 CDT
 |
 |