This content has been marked as final. Show 6 replies
You can use JMX Monitoring API to access monitoring data.
find details in below url..
here we run SQL queries directly on the 2 reporting tables in SOAINFRA schema. we used simple JSTL sql tags.1 person found this helpful
we created a job to archive data regularly to an archive table, with indexes to speed up searches
Based on how you described the scenario, it seems like you can implement a Custom Reporting Provider to access the OSB report data and appropriately use it.1 person found this helpful
Please refer to the example Custom Reporting Provider @ http://www.oracle.com/technetwork/middleware/service-bus/learnmore/index.html for more details and a sample implementation.
I am not a big fan of using the built in DB structure of the reporting tables as it is very generic and does not allow you to create indexes on certain business fields, partitioning etc ...
I would rather prefer to build a custom reporting layer to extend the reporting data and populate a certain set of tables (aligned to my specific business needs, with proper indexes and partitioning to help support the data optimally) and then querying this data to provide visibility to other teams/applications.
Hope this helps.
In my case, customized reporter and quering data in 2 reporting tables in SOAINFRA schema are both doable solution.
Anyone who can tell me the names of that 2 reporting tables in SOAINFRA will be highly appreciated.
The tables are as follows :
You can the specific table structure from the scripts which are located in OSB_ORACLE_HOME/dbscripts.