Re: Index creation monitoring + select/inserts
From: Palooka <nobody_at_nowhere.com>
Date: Wed, 07 Oct 2009 17:26:08 +0100
Message-ID: <Bi3zm.10656$cD3.6619_at_newsfe05.ams2>
On 07/10/09 16:55, gazzag wrote:
> On 7 Oct, 09:40, briandba<briandba..._at_gmail.com> wrote:
>> 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- Hide quoted text -
>
> You could write a trigger for the table in question. Sadly
> tahiti.oracle.com seems to be unavailable again at the moment, but the
> relevant documentation should be there.
>
Except of course that a trigger cannot record selects. Anyway, even if it could, I think an audit statement is vastly preferable.
Date: Wed, 07 Oct 2009 17:26:08 +0100
Message-ID: <Bi3zm.10656$cD3.6619_at_newsfe05.ams2>
On 07/10/09 16:55, gazzag wrote:
> On 7 Oct, 09:40, briandba<briandba..._at_gmail.com> wrote:
>> 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- Hide quoted text -
>
> You could write a trigger for the table in question. Sadly
> tahiti.oracle.com seems to be unavailable again at the moment, but the
> relevant documentation should be there.
>
Except of course that a trigger cannot record selects. Anyway, even if it could, I think an audit statement is vastly preferable.
Palooka Received on Wed Oct 07 2009 - 11:26:08 CDT