dba_stmt_audit_opts ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 8:58 AM
> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: =?iso-8859-1?Q?Wolfgang_K=F6ssler?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).