Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to audit/trigger "ALTER SESSION" Statements?
so the DDL-Trigger obviously doesn't fire for the particular Statement
ALTER SESSION set cursor_sharing=force.
To complicate things further:
Even when you try
AUDIT ALTER SESSION
you won't find above Statement in the AUDIT_TRAIL in contrast to what
I've said in one of my posts before.
But on the other hand for example you'll find
ALTER SESSION set sql_trace=false
in the AUDIT_TRAIL!!!
This particular ALTER SESSION Statement seems to be absolutly not
"catchable", not via a DB or DDL Trigger nor through auditing.
Some guys out there should have found a solution for that, shouldn't
there??
I need a way to capture ALTER SESSION set cursor_sharing=force!!
Thanks, Michael Received on Sun Apr 24 2005 - 15:06:24 CDT