Re: Help: alter table monitoring

Just as a little aside - Oracle 9 has a procedure

    dbms_stats.flush_monitoring_info
which I think is designed to write the monitoring info to the relevant tables when it is called.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


John Darrah wrote in message
<410ab02ecdfac7502fb6c6ea6cf34add.36240_at_mygate.mailgate.org>...


>There is typically a delay of up two two or three hours before you will see

>these changes.  The modifications are intermittantly written to a structure

in


>memory and then periodically written down to the tab_modifications table.

If


>this wern't the case, you'd have massive contention on the table with

>monitoring turned on because every session changing that table would have

to


>serialize to write their modification data.  A couple side effects of this

are


>1) rollbacks are still counted as modifications 2) no locks are taken out

on


>the structure so two processes can overwrite oneanothers' data if they hit

at


>exactly the same time.  Basically that table is supposed to give an

>approximation of what is going on with the base tables being monitored.

>"a" <dbadba62_at_hotmail.com> wrote in message

>news:%75%7.22729$tz1.19838_at_nwrddc01.gnilink.net...

>

>> After I alter table monitoring as the owner of the table, I insert one

row


>> into the table, and then commit.  After that, I select count(*) form

>> sys.dba_tab_modifications as system, the result is 0.

>>

>> Is there anything I did wrong?  How do you collect the info after you

alter


>> table monitoring?

>>

>> I am using Oracle 817 on Solaris.

>>

>> Thanks for your help.

>

>

>

>

>--

>Posted via Mailgate.ORG Server - http://www.Mailgate.ORG