RE: Last Update

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Tue, 17 Jul 2001 11:26:48 -0700
Message-ID: <F001.0034C893.20010717112954@fatcity.com>

If you want that other users like system can see it ,give grant select to system as user sys...

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 17 Jul 2001 10:20:31 -0800

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).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_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:26:48 CDT