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

Home -> Community -> Usenet -> c.d.o.server -> seeking advice/suggestions in regards to Oracle auditing

seeking advice/suggestions in regards to Oracle auditing

From: David J DeWolfe <sxdjd_at_orca.alaska.edu>
Date: 1997/01/10
Message-ID: <32D69782.53FB@orca.alaska.edu>#1/1

Hello all;

We are currently in the process of getting auditing configured in several of our 7.2.3 databases. We will be auditing to the database as OS auditing is not supported under Dec Alpha/Digital Unix. We've done the obvious, like moving aud$ out of the system tablespace, and auditing aud$ itself. I would appreciate any advice/suggesstions anyone may have in regards to issues and concerns with auditing to the database. We do plan to have a process wake up and check the % used of the audit tablespace and export/truncate aud$ if it has reached a certain level, however, we wondering about audit records being generated after the export and before the truncate and thereby losing audit records. We have thought of copying records from aud$ to another table and then deleting from aud$ by rowid etc. Again, any thoughts or suggestions would be most appreciated.

TIA

-- 

David J. DeWolfe
Systems Programmer 
Statewide Office of Information Services
University of Alaska
907.474.7399
sxdjd_at_orca.alaska.edu

In a vicious struggle for survival intelligence emerges as the weapon of 
 choice. - Nova, In Search of Human Origins
Received on Fri Jan 10 1997 - 00:00:00 CST

Original text of this message

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