We have been using OSB in our organization for some time now , however we recently encounter the DB space issue which is very familiar in SOA.
The table that was consuming most of the space was :
WLI_QS_REPORT_DATA in the SOAINFRA schema (around 50 gb as blob)
This table is primarily used by OSB for maintaining the data for all the requests that came to OSB and the reporting data.
Another table which has the relationship with this table is :
wli_qs_report_attribute
Similar to SOA purge we can purge these tables based on how long we need to keep the data, Which in ideal case is 5-7 days.
The purging can be done from OSB console as well using the "Purge Messages" option at the Message report home page.
I personally prefer purging using the console , the purging happens asynchronously. But if you dont have access to console follow the DB route.
A really nice blog explaining more details about these tables:
http://jvzoggel.wordpress.com/2012/01/18/osb_tracing_report_action/
Cheers !!
No comments:
Post a Comment