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

From: SEJ <sejprv_at_hotmail.com>
Date: Sun, 30 Aug 2009 21:31:28 +0200
Message-ID: <4a9ad3c2$0$333$14726298_at_news.sunsite.dk>


"Gerard H. Pille" <ghp_at_skynet.be> skrev i en meddelelse news: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.

For many years ago i read it was a good practice to move the aud$ table to another tablespace

regards SEJ Received on Sun Aug 30 2009 - 14:31:28 CDT

Original text of this message