Hi, Documented way for >= 10.2.0.3: New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information <https://metalink2.oracle.com/metalink/plsql/f?p=130:14:9086829504850226415::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,731908.1,1,1,1,helvetica> Thanks, Timur Akhmadeev -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Klier Sent: Tuesday, August 04, 2009 13:23 To: pete@xxxxxxxxxxxxxxxx Cc: 'oracle-l@xxxxxxxxxxxxx' Subject: Re: How to log attempts to connect as a locked user account Thanks Pete, for your reply. Pete Finnigan schrieb: > Just to add there is a session view already built into the database > SYS.DBA_AUDIT_SESSION that limits AUD$ to just session audit logs. How can I configure the retention time of the audit log results? Is there a link/paper somewhere, or could you explain this in a few words, please? Thanks Martin -- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- //www.freelists.org/webpage/oracle-l The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.