POiSON WORLD

In a RAC Database :

SQL> ALTER SYSTEM SET audit_trail=NONE SCOPE=spfile sid='*';
System altered.
SQL>

Note : Restart the database to have the change take affect, or do a rolling restart, one instance at a time.

In a Single Instance Database :

SQL> ALTER SYSTEM SET audit_trail=NONE SCOPE=spfile ;
System altered.
SQL>

Note : Restart the database to have the change take affect.

Comments

comments

Tags: 11G Database, A 11G Database, APPS DBA, Audit Query Oracle, DBA, DBA Oracle, Disable Auditing, Disable Auditing In A 11G Database, Oracle, Oracle 11g, Oracle Application, Oracle Apps, Oracle Database, Oracle DBA, Oracle DBA Query, Oracle RAC database, RAC database:, Single Instance Database

This entry was posted on Saturday, November 18th, 2017 at 12:01 am and is filed under Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.