Re: Index creation monitoring + select/inserts
From: briandba <briandbaora_at_gmail.com>
Date: Wed, 7 Oct 2009 12:29:10 -0700 (PDT)
Message-ID: <8dba8cb3-6250-470a-abe8-88119bfb0816_at_e18g2000vbe.googlegroups.com>
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
> issue.
>
> jg
> --
> _at_home.com is bogus.http://www.computerworld.com.au/index.php?q=article/321082/an_intevie...
Date: Wed, 7 Oct 2009 12:29:10 -0700 (PDT)
Message-ID: <8dba8cb3-6250-470a-abe8-88119bfb0816_at_e18g2000vbe.googlegroups.com>
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
> issue.
>
> jg
> --
> _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