Re: Index creation monitoring + select/inserts

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.

>
> thanks
> brian

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