Re: Index creation monitoring + select/inserts
Date: Wed, 7 Oct 2009 01:40:44 -0700 (PDT)
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