Re: On 9i and 10g, When an Oracle User Last Accessed the Database?

From: ddf <>
Date: Sun, 30 Aug 2009 05:54:36 -0700 (PDT)
Message-ID: <>

On Aug 29, 4:23 am, "Gerard H. Pille" <> wrote:
> ddf schreef:
> > and you're done as userid and logoff$time is populated in SYS.AUD$
> > (along with other bits of information).  To report the last logoff for
> > a user:
> You're not done, unless you want to be done in:  don't forget to monitor the growth of sys.aud$,
> it can flood your system tablespace.

This is true, and I mention that in the blog post for which I provided a link. I will agree i probably should have included that information in the original response.

David Fitzjarrell Received on Sun Aug 30 2009 - 07:54:36 CDT

Original text of this message