Re: Index creation monitoring + select/inserts
From: briandba <briandbaora_at_gmail.com>
Date: Wed, 7 Oct 2009 01:40:44 -0700 (PDT)
Message-ID: <38f6c895-0cfb-426a-ad88-99e2b3b8fda7_at_o36g2000vbl.googlegroups.com>
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.
Date: Wed, 7 Oct 2009 01:40:44 -0700 (PDT)
Message-ID: <38f6c895-0cfb-426a-ad88-99e2b3b8fda7_at_o36g2000vbl.googlegroups.com>
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
Received on Wed Oct 07 2009 - 03:40:44 CDT