Can anyone add to the knowledge of this session

Like how frequently they run it ?
How many records get written daily ?
What is their rate of deletion ie run time compared to records deleted ?

Only we have been running it for 6 hours and the record count on the table has increased !

I run that session in a job on a daily basis in order to keep the number of records to an acceptable level.

Regards,
Han

Hi,

I run the session two times a month.
But it can be done oftener, because 1 clean the $BSE/tmp directory and keep tmp-files of max. two days old.
(There is a link to the $BSE/tmp files from that table.)

So if you clean the $BSE/tmp dir. till 5 days ago, you can run the session with the date minus 5

GN

Thanks GN

We also keep clean the $BSE/tmp directory and keep tmp-files of max. two days old.

Will that effect the running of the ttaad3321 session since we have not run it for a long time ?

Hi Frank,

I don't know which session that can be, but i suppose you mean ttaad3221m000 :-)

Take a look into the table with session ttaad3120m000, for example your userid.
There you see your latest and your first sequence number.
The difference should be the number of records, which will be purged for your userid.
So it may take a long time!!! for ALL users, i suppose.
You may run the session for e.g. 10 users and purge the records to date minus 2 days and calculate in this way, how long it will take for ALL the users.

GN

We delete the records from Oracle - sqlplus.
This script runs every night, runs for 6 seconds
and deletes 1500 records. (i.e. we create 1500
records a day with 227 current users).

delete from tttaad320000
where
t$rdte < sysdate - 7
;

This will delete all queues older that 7 days.

If you have not run this before, then delete a few
months data at a time....

Interesting that we have left all parms as default apart from date
and hardly any records deleted ( on a net basis) but when selecting a single user name as a parm we deleted 20,000+ in a few minutes

This we have repeated, ah well only 2.4m to go !

...that if you keep your tmp files for 2 days, then that should be the frequency of your purge.

Why keep information that's not really there? That freaks me out, man.

Yep ! you are so right . We just missed this completely

Ah well , we are down to 2.2m entries