Another "DBA" turned on select auditing for all tables in our
production warehouse because he and a couple others thought it was the
best way to capture some statistics. Within a matter of an hour or so
the auditing table grew to several hundred meg, fragmented up our
system tablespace and slowed down our loads considerably. AUD$ became
quite the bottleneck. Now we have a system tablespace that is 487M
with 403M free. Autoextend on, no maxsize - another philosophy that
abounds here. I could go on but...
- Brian
- "Koivu, Lisa" <lkoivu_at_qode.com> wrote:
> Well, golly be (gotta tone down my swearing)
>
> I thought that you could not audit selects. Wow. I learned something
> today
> besides what AFIEDT.BUF really means (or meant). Have you set audit
> at that
> level before? It sounds like it would drag a database to a grinding
> screeching halt, even if you had enough room to keep all those
> entries in
> the audit table.
>
> Lisa
> Ft. Lauderdale, FL, USA
>
>
>
> -----Original Message-----
> Sent: Thursday, August 17, 2000 11:48 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Step one, Set "audit_trail" in the init.ora file to true or DB or OS,
> Second,
> what do you want to audit? A "audit select on <table_name>" will
> audit all
> selects. There are other options as well.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com>
> Date: 8/17/00 4:29 AM
>
> Hello,
> can U pl say how to enable auditing on a table.Can U please say the
> syntax
> also .
>
> Regards
> Siva
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> charset=us-ascii">
> <META NAME="Generator" CONTENT="MS Exchange Server version
> 5.5.2650.12">
> <TITLE>RE: Auditing</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=2 FACE="Arial">Hello,</FONT>
> <BR><FONT SIZE=2 FACE="Arial">can U pl say how to enable auditing on
> a
> table.Can
> U please say the syntax also .</FONT>
> </P>
>
> <P><FONT SIZE=2 FACE="Arial">Regards</FONT>
> <BR><FONT SIZE=2 FACE="Arial">Siva</FONT>
> </P>
>
> </BODY>
> </HTML>
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> 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).
>
Do You Yahoo!?
Received on Thu Aug 17 2000 - 14:53:08 CDT