The applications has a purge audit or signon report that you submit to
the concurrent managers. This program will purge the sign on data to
the parameters you specify. On a development instance, I typically see
it set for 5 - 7 days, on a production system, as long as 30 days. I
don't have the apps available to me now to list the steps, but go to the
submit reports screen, as sysadmin, and query for reports "Purge%"
(without quotes) and you should see a list come up. Choose the one
called Purge Audit or Purge Signon..I can't remember the exact name. The
sysadmin book explains the parameters in detail. Look into the AGE
parameter, this allows you to keep so many days before purging. I set
this to run everyday.
Emboff wrote:
>
> Is the fnd_logins table just a historical table? Is there any reason I can't
> purge it to reduce its size? Ours has 1.6 million rows right now and since it
> appears to be a sort of audit of logins and logouts I would like to trim it.
> Anyone have experience with that?
Received on Mon Jul 20 1998 - 22:22:52 CDT
