Re: Rates of change???

Thanks for the suggestion.

I'm hoping to be able to do this and not impact existing applications. These are both valid solutions, but would add some overhead to the application. I'm hoping that there is some system level information that I can capture.

Again thanks for the suggestion.

M.P.

"Terri Boydstun" <tmboydstun_at_cs.com> wrote in message news:8d84f698.0306290936.1cfcc565_at_posting.google.com...
> "Madison Pruet" <mpruet_at_attbi.com> wrote in message
 news:<hSkLa.43291$Fy6.13123_at_sccrnsc03>...
> > Hi,
> >
> > Is there an easy way to determine the rate of change for table? I
 realize
> > that I could do periodic select count(*) from XXX, but that would only
> > determine the size of the table. It would ignore updates.
> >
> > What I'd really like to do would be able to determine the number of
 non-read
> > operations over a table so that I can determine the rate of change for
 that
> > table.
> >
> > Thanks for any help..
>
> Another thought - If you just want to see the rate of change, create a
> database sequence. Then create an after insert and an after update
> trigger against your table, and the only thing the triggers do is
> select the sequence from dual (therefore, increasing the sequence
> number). Periodically, you can look at the sequence and see how many
> changes have occured against the table. You could also reset it to
> zero each time you look at it...
Received on Sun Jun 29 2003 - 20:49:12 CEST