RE: Questions about AUDIT

Hi Paul,

Check out:

DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS

Not sure on the rest of your mail (due to not actually having used auditing in earnest ;P) but I'm sure the rest of the list can help out with that..

HTH Mark

-----Original Message-----
Vincent
Sent: 27 March 2002 07:58
To: Multiple recipients of list ORACLE-L

Other than keeping a "pencil and paper" record of currently active AUDIT statements, is this information held anywhere in ORACLE? That is, is there a table or view, or something internal, that I can query to see what types of activity are currently being audited in a database? I'm not talking here about seeing the results of the audit - I know they're recorded in the SYS.AUD$ table - but about the criteria which are currently active. This would be useful to know, so that when I've issued a series of NOAUDIT statements, I can check to see that there's nothing still being audited.

A related question - (which may sound like a classic RTFM, but I can't see this explicitly stated anywhere in the docs) - does an AUDIT statement remain active through shutdown/startup cycles, until cancelled by a NOAUDIT statement, or is it only active until the next shutdown?

And finally: at what level of audit activity does it start to make a noticeable hit on performance? Would I expect users to start noticing delays if I was simply auditing CONNECTs? What if I was auditing every INSERT at ACCESS level? Or every SELECT? I know this is a "how long's a piece of string?"-type question, but I'm just after a rough, rule-of-thumb level of knowledge here...

Oh, the platforms here are: 8.0 on Windows NT, 8.1.6 on NT and Solaris, and 8.1.7 on Solaris.

Any answers/ideas appreciated!

Paul Vincent
DBA
University of Central England

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Vincent
  INET: Paul.Vincent_at_uce.ac.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).