Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Questions about AUDIT

Re: Questions about AUDIT

From: Wolfgang Kössler <wolfgang.koessler_at_uibk.ac.at>
Date: Wed, 27 Mar 2002 01:13:20 -0800
Message-ID: <F001.00434759.20020327011320@fatcity.com>


dba_stmt_audit_opts

> 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: =?iso-8859-1?Q?Wolfgang_K=F6ssler?=
  INET: wolfgang.koessler_at_uibk.ac.at

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).
Received on Wed Mar 27 2002 - 03:13:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US