| Purging and Archiving
I am looking for help in the area of custom purges and/or archiving. We have been live for 4 months now and we are seeing really poor performance. The Business Monitor, Saved Queries, and custom reports are timing out on a regular basis. I'm looking for anyone willing to share what they do for purging or additional indexing if relief can be found there. I really need a table structure so we can write a custom PL/SQL script. I want to make sure we don't miss anything.
Here are some of our common tables with counts.
449,172 OR records
3,319,474 OR_refnum records
5,036,227 OR_line records
150,574 shipment records
311,932 Shipment_stop records
Let me know if anyone can help point me in the right direction.
Thanks! |