H Performance Tuning
A typical Oracle Insurance Allocation Manager for Enterprise Profitability implementation involves dozen, hundreds, or sometimes even thousands of distinct allocation rules. There is commonly a bell-curve distribution of processing times for each allocation rule. Some finish in seconds, some finish in minutes, and others may take hours to complete. An allocation's run time is related to the volume of data it generates, but there may be times when an allocation runs slower than it should due to stale database statistics, skews in the data being queried, a lack of appropriate indexes, or a poor execution plan generated by the database optimizer. Your DBA may be able to enhance the overall performance of the database by gathering database statistics more frequently, generating additional indexes, or by other tuning techniques. One such additional tuning technique is to add hints to your queries.
Topics: