Re: On 9i and 10g, When an Oracle User Last Accessed the Database?
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 29 Aug 2009 11:23:31 +0200
Message-ID: <4a98f392$0$2847$ba620e4c_at_news.skynet.be>
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:
Date: Sat, 29 Aug 2009 11:23:31 +0200
Message-ID: <4a98f392$0$2847$ba620e4c_at_news.skynet.be>
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. Received on Sat Aug 29 2009 - 04:23:31 CDT