RE: setting of audit_trail initialization parameter
Date: Wed, 22 May 2013 11:26:03 -0500
Message-ID: <A4B582B1B91D3C4D956D8880535CC098130505F66B_at_MAIL.solutionary.com>
I said "11gR2", but meant 11.2.0.2. Oracle did not eliminate the "permanent" index file adx_<SID>.txt and it's issues until 11.2.0.2.
Don Granaman | Ph: 402-361-3073 | Cell: 402-960-6955 | Solutionary - Relevant | Intelligent | Security
-----Original Message-----
From: Don Granaman
Sent: Wednesday, May 22, 2013 11:05 AM
To: 'JBECKSTROM_at_gcrta.org'; oracle-l-freelist
Subject: RE: setting of audit_trail initialization parameter
It is actually quite easy to run queries against V$XML_AUDIT_TRAIL - IFF the XML audit data exists in the expected location (AUDIT_FILE_DEST), the index file is accurate and you are running on 11gR2. Prior to 11gR2, there are a number of serious bugs with XML, but the most crippling may be one which causes queries against V$XML_AUDIT_TRAIL to crash when the index file (adx_<SID>.txt) becomes too large. (In our biggest 10g system, this would occur about twice a day!) There are still some significant bugs in XML in even the latest releases, but it seems to be usable.
Don Granaman | Ph: 402-361-3073 | Cell: 402-960-6955 | Solutionary - Relevant | Intelligent | Security
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Tuesday, May 21, 2013 2:15 PM
To: oracle-l-freelist
Subject: RE: setting of audit_trail initialization parameter
I received some responses as well Google results showing that DB had the most overhead. How easy is it to query the XML audit data, instead of, database data. Right now I am torn between the XML and DB options.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Tuesday, May 21, 2013 8:09 AM
To: oracle-l-freelist
Subject: setting of audit_trail initialization parameter
I know what the docs say but what do people really set this to; DB, OS or XML and why?
TXT:SEG
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 22 2013 - 18:26:03 CEST