Re: On 9i and 10g, When an Oracle User Last Accessed the Database?
From: ddf <oratune_at_msn.com>
Date: Sun, 30 Aug 2009 05:54:36 -0700 (PDT)
Message-ID: <96e88f91-3106-411c-838c-d4c684cce529_at_j19g2000vbp.googlegroups.com>
On Aug 29, 4:23 am, "Gerard H. Pille" <g..._at_skynet.be> 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.
Date: Sun, 30 Aug 2009 05:54:36 -0700 (PDT)
Message-ID: <96e88f91-3106-411c-838c-d4c684cce529_at_j19g2000vbp.googlegroups.com>
On Aug 29, 4:23 am, "Gerard H. Pille" <g..._at_skynet.be> 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