Re: Index creation monitoring + select/inserts
Date: Tue, 6 Oct 2009 15:40:04 -0700 (PDT)
On Oct 6, 4:02 pm, briandba <briandba..._at_gmail.com> wrote:
> 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.
David Fitzjarrell Received on Tue Oct 06 2009 - 17:40:04 CDT