I am using osb11g, from osb console-operations-dashboard-service health, I can only know response time for ps/bs for current aggregation interval or since last reset, question is may I know this statistic info for a special period I concern?
Is there api or db table for that?
The simple, manual way is to reset the stats in the console at the start of the period you're concerned with.
The more complicated way is to use the API to periodically pull down the stats and keep them (which the console doesn't do - it only shows averages and max/min), resetting at each pulldown. I cobbled together some Java to do this based on stuff I read in the Oracle docs here: http://docs.oracle.com/cd/E23943_01/admin.1111/e15867/app_jmx_monitoring.htm#OSBAG748.
This is helpful, but my customer does not want to involve BAM for this requirement, considering statistics data can be displayed after reboot osb server, my customer believes there must be a db table there to save statistics data, but I can't find that table.
Maybe I need to clear my request, customer needs to know average response time during any period from last reset, for example: 5m, 2h, 3days, the request depends on business person, we can't define the period in advance.
For this request, I think the besk method is query the statistic table in osb db.