RE: setting of audit_trail initialization parameter
Date: Wed, 22 May 2013 11:05:13 -0500
Message-ID: <A4B582B1B91D3C4D956D8880535CC098130505F668_at_MAIL.solutionary.com>
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:05:13 CEST