Re: Moving Audit Tables out of SYSTEM
From: Jean Anderson <jean_at_beno.CSS.GOV>
Date: 7 Mar 92 01:05:06 GMT
Message-ID: <50483_at_seismo.CSS.GOV>
Date: 7 Mar 92 01:05:06 GMT
Message-ID: <50483_at_seismo.CSS.GOV>
In <kpalm.699910535_at_athena>, kpalm_at_athena.qualcomm.com (Kent Palm) writes:
> Jean, I'm not sure. But one thing I want to mention is that I have cron
> maintain that table for me so it doesn't get out of hand (i.e., delete rows
> that are too old or unneeded).
Thanks for the note, Kent. I want to gather long term connection statistics on a variety of databases that have exceptionally unpredictable activity. I'm not sure yet what I'm going to see or what trends I'll actually want to track over time, so I want to keep the source audit data around for a while (possibly several to six months). Hence the desire to move it out of SYSTEM.
regards,
- jean
+-----------------------------------------------------------------------+ | Jean Anderson, DBA email: jean_at_seismo.css.gov | | SAIC Open Systems Division, MS A2-F or: jean_at_esosun.css.gov | | 10210 Campus Point Drive phone: (619)458-2727 | | San Diego, CA 92121 fax: (619)458-4993 | +-----------------------------------------------------------------------+ | execute sp_disclaimer _at_opinion="mine" | +-----------------------------------------------------------------------+Received on Sat Mar 07 1992 - 02:05:06 CET