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