Re: Index creation monitoring + select/inserts
Date: Wed, 7 Oct 2009 12:29:10 -0700 (PDT)
On 7 oct, 20:22, joel garry <joel-ga..._at_home.com> wrote:
> On Oct 6, 2:02 pm, briandba <briandba..._at_gmail.com> wrote:
> > and another question, how can i determine the number of users select,
> > insert, update ,delete on the database since the startup ?
> Why exactly do you need to know this? It sounds like an app-side
> _at_home.com is bogus.http://www.computerworld.com.au/index.php?q=article/321082/an_intevie...
I come from db2 and usually i monitor the number of select, insert ,
update , full scan, index access on some tables in real time to check
activity when asked.
the same when the index are rebuilded or created, on large table i can exactly tell when it will be finished,
we have migrated to oracle and i search the equivalent. maybe it's not a good solution but you know bad habits last :) Received on Wed Oct 07 2009 - 14:29:10 CDT