Re: database auditing
From: helter skelter <helterskelter_at_gmail.com>
Date: Tue, 28 Oct 2008 09:29:00 +0100
Message-ID: <ge6io9$3sg$1@mx1.internetia.pl>
>> Hi,
>>
>> I have lately turned on database auditing (audit_trail=db and
>> audit_sys_operations=true) but didn't activate any auditing options (no
>> records in sys.aud$). From this time I see that 'current open cursors'
>> statistic have increased about 20% and average system load is larger.
>> Could that things be connected ?
>>
>> This is 500GB OLTP database, 10.2.0.1, rhel4
>>
>> thanks
Date: Tue, 28 Oct 2008 09:29:00 +0100
Message-ID: <ge6io9$3sg$1@mx1.internetia.pl>
sybrandb_at_hccnet.nl pisze:
> On Mon, 27 Oct 2008 11:37:19 +0100, helter skelter > <helterskelter_at_gmail.com> wrote: >
>> Hi,
>>
>> I have lately turned on database auditing (audit_trail=db and
>> audit_sys_operations=true) but didn't activate any auditing options (no
>> records in sys.aud$). From this time I see that 'current open cursors'
>> statistic have increased about 20% and average system load is larger.
>> Could that things be connected ?
>>
>> This is 500GB OLTP database, 10.2.0.1, rhel4
>>
>> thanks
> > No. > Or you are running everything connected as a SYSDBA user. >
No. I am not running anything as a sysdba. So the reason of this overhead have to be somwhere else, thanks Received on Tue Oct 28 2008 - 03:29:00 CDT