And....then wait because the SMON updates it every
three hours or after an startup.
Regards.
PS: Even that you can manually wakeup the SMON through
oradebug wakeup <orapid of SMON>
- JOE TESTA <JTESTA_at_longaberger.com> wrote:
> you have to turn monitoring on for each table.
>
> alter table <tablename> monitoring;
>
> joe
>
>
> >>> rakumar_at_mahindrabt.com 07/16/01 10:36AM >>>
> Hi,
>
> but in my 8.1.7 db. (on SOLARIS), NO ROWS SELECTED
> when queried
> DBA_TAB_MODIFICATIONS...........
>
> Any init parameters to be enabled........??
>
> Arul.
>
> Christian Trassens wrote:
>
> > 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).
>
>
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
>
> Visit us at http://www.mahindrabt.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Arul kumar
> INET: rakumar_at_mahindrabt.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).
Received on Mon Jul 16 2001 - 09:28:40 CDT