Re: Index creation monitoring + select/inserts

From: ddf <>
Date: Tue, 6 Oct 2009 15:40:04 -0700 (PDT)
Message-ID: <>

Comments embedded.

On Oct 6, 4:02 pm, briandba <> 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.

> thanks
> brian

David Fitzjarrell Received on Tue Oct 06 2009 - 17:40:04 CDT

Original text of this message