Re: Index creation monitoring + select/inserts
From: gazzag <gareth_at_jamms.org>
Date: Wed, 7 Oct 2009 08:55:00 -0700 (PDT)
Message-ID: <b8f461a4-776d-480a-a167-f364db94673a_at_k26g2000vbp.googlegroups.com>
On 7 Oct, 09:40, briandba <briandba..._at_gmail.com> wrote:
> On 7 oct, 00:40, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > Comments embedded.
>
> > On Oct 6, 4:02 pm, briandba <briandba..._at_gmail.com> wrote:
>
> > > Hi,
> > > i'm new to oracle (i'm from db2) eand i have basics questions on
> > > oracle 9i and 10g:
> > > how can i view the progression of a create index or alter index
> > > rebuild ?
> > > there is no entry in v$session_longops for these orders
>
> > Not directly. Indirectly you'd be looking for table scan operations
> > on the base table for the index being created/rebuilt (although there
> > may not be a table scan for a rebuild since Oracle will usually scan
> > the existing index for entries).
>
> > > and another question, how can i determine the number of users select,
> > > insert, update ,delete on the database since the startup ?
>
> > Audit those operations. As SYS as SYSDBA execute :
>
> > audit select table, insert table, update table, delete table;
>
> > You would then query DBA_AUDIT_TRAIL for the results of those audits.
>
> ok but that's means overhead
> it's hard for me to not find counter for insert/update/select/... on a
> table basis
> because without activating audit , i'm not able to determine if there
> is user activities on a table TEST for example.
> I don't want the SQL but the counters, frequently i need to tell if
> there are activities like insert on a table.
> Maybe in 11g it's possible ?
>
>
>
>
>
> > > thanks
> > > brian
>
> > David Fitzjarrell- Hide quoted text -
Date: Wed, 7 Oct 2009 08:55:00 -0700 (PDT)
Message-ID: <b8f461a4-776d-480a-a167-f364db94673a_at_k26g2000vbp.googlegroups.com>
On 7 Oct, 09:40, briandba <briandba..._at_gmail.com> wrote:
> On 7 oct, 00:40, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > Comments embedded.
>
> > On Oct 6, 4:02 pm, briandba <briandba..._at_gmail.com> wrote:
>
> > > Hi,
> > > i'm new to oracle (i'm from db2) eand i have basics questions on
> > > oracle 9i and 10g:
> > > how can i view the progression of a create index or alter index
> > > rebuild ?
> > > there is no entry in v$session_longops for these orders
>
> > Not directly. Indirectly you'd be looking for table scan operations
> > on the base table for the index being created/rebuilt (although there
> > may not be a table scan for a rebuild since Oracle will usually scan
> > the existing index for entries).
>
> > > and another question, how can i determine the number of users select,
> > > insert, update ,delete on the database since the startup ?
>
> > Audit those operations. As SYS as SYSDBA execute :
>
> > audit select table, insert table, update table, delete table;
>
> > You would then query DBA_AUDIT_TRAIL for the results of those audits.
>
> ok but that's means overhead
> it's hard for me to not find counter for insert/update/select/... on a
> table basis
> because without activating audit , i'm not able to determine if there
> is user activities on a table TEST for example.
> I don't want the SQL but the counters, frequently i need to tell if
> there are activities like insert on a table.
> Maybe in 11g it's possible ?
>
>
>
>
>
> > > thanks
> > > brian
>
> > David Fitzjarrell- Hide quoted text -
You could write a trigger for the table in question. Sadly tahiti.oracle.com seems to be unavailable again at the moment, but the relevant documentation should be there.
HTH -g Received on Wed Oct 07 2009 - 10:55:00 CDT