Dynamic Logic Statistics

Efficient dynamic logic is essential for well performing Oracle Health Insurance applications. Inefficient dynamic logic on the other hand may impact the performance of the Oracle Health Insurance application and ultimately the end-user experience.

Oracle Health Insurance applications automatically capture statistics about the running of dynamic logic.

The Dynamic Logic Statistics Integration Point makes the statistics available.

The statistics are gathered per dynamic logic code.

The table below shows the statistics that Oracle Health Insurance applications gather:

Table 1. Dynamic Logic Statistics

Statistic	Description	Unit
totalElapsedTime	Total time elapsed in milliseconds in the time period.	Millisecond
totalExecutions	Total number of dynamic logic runs.	Count
averageElapsedTime	Average elapsed time in nanoseconds in the time period.	Nanosecond
executionCount0	Number of times the dynamic logic took less than 0.1 milliseconds to run.	Count
executionCount1	Number of times the dynamic logic took >= 0.1 and < 1.0 milliseconds to run.	Count
executionCount10	Number of times the dynamic logic took >= 1 and < 10 milliseconds to run.	Count
executionCount100	Number of times the dynamic logic took >= 10 and < 100 milliseconds to run.	Count
executionCount1000	Number of times the dynamic logic took >= 100 and < 1000 milliseconds to run.	Count
executionCount10000	Number of times the dynamic logic took >= 1000 and < 10000 milliseconds to run.	Count
executionCountLong	Number of times the dynamic logic took >= 10000 milliseconds to run.	Count
totalAllocatedMemory	The total amount of memory allocated in kilobytes by dynamic logic for all the runs of dynamic logic.	Count
maxAllocatedMemory	The highest amount of memory allocated in kilobytes by dynamic logic in a single run of dynamic logic.	Count
averageAllocatedMemory	The average amount of memory allocated in kilobytes by dynamic logic for all the runs of dynamic logic.	Count
queryCount	The total number of queries started while running the dynamic logic.	Count
retrievedRowsCount	The total number of rows retrieved for all the queries run while running the dynamic logic.	Count
maxResultSetSize	The highest number of rows retrieved among all the queries run.	Count
averageRowsCount	Average number of rows retrieved while running the dynamic logic.	Count

The statistics are reasonably accurate, but need not be 100% exact. Under heavy load, some runs may not show up.