Keeping statistics current, Can this be done automatically in 10g Options

[rgoldwrx]

Hi all, we have a table that grows intermittently, but can grow significantly. Unfortunately, with the nature of our system I have found that the plans used by the optimzer can be much better when the stats are very accurate, sometimes with a difference of 30 seconds to 20 minutes.

I expect that as the table can grow from 16000 to 32000 rows in one statement, some sort of trigger to recalc stats as a post commit might be the sort of thing that could do it.

Any experiences, ideas?