Oracle recommends that a database administrator run statistics on a Central Coding application if:
If the job runs for a long time and a timeout exception error occurs, the ExceptionMap.xml file contains an entry that instructs you to ask a database administrator to gather statistics on the Central Coding account.
Oracle recommends that the database administrator monitor the statistics for the account during the day and gather statistics if the statistics start to be out of date and the performance of the application slows down.
Copyright © 2006, 2016 Oracle and/or its affiliates. All rights reserved.