audir related SQL

are there any useful SQL queries that can determine what audit settings are enabled for an oracle database? i.e. is auditing turned on, if yes, what events are being audited etc.
LVL 3
pma111Asked:
Who is Participating?
 
Praveen Kumar ChandrashekatrConnect With a Mentor Database Analysist Senior Commented:
check the parameter audit_trial setting in the DB if it is set to none its disabled.

$export ORACLE_SID=<SID>
$sqlplus "/as sysdba"
SQL>show parameter audit;

check this document for more details.
http://www.oracle-base.com/articles/10g/auditing-10gr2.php
0
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
you can also use the below query to check the audit parameters/values.

select *
from v$parameter
where name like '%aud%'

Thanks,
0
All Courses

From novice to tech pro — start learning today.