Re: Trigger on v$sql catalog table

On 10 Jul 2003 23:19:34 -0700, db_guy_2002_at_yahoo.com (db dude) wrote:

>Why is this a bad idea. Will it degrade performance or cause any other problems?
>
>Auditing seems to degrade performance which I am trying to avoid or lessen.
 

For one second: think. If you can't think don't use Oracle. The v$sql table is one of the most heavily used tables! What, do you think will happen, when your stupid trigger fails? Any answer? Don't you think it is going to crash the database or resulting in all other strange effects?
If you know better and want to be 'smart' (trademark) and invent all kind of unsupported ' solutions, and are in for a career change, or want to end up in hell, why don't you just go ahead and get lost?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jul 11 2003 - 01:42:29 CDT