OSB SQL Query Performance with Reporting Data
(Doc ID 1515214.1)
Last updated on OCTOBER 05, 2023
Applies to:
Oracle Service Bus - Version 10.3 and laterInformation in this document applies to any platform.
Goal
Having some problems with a SQL OSB query:
This LOB object has a big size (150 GBs total, 50 GBs used), and you want to compact this table.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| A: You can automatically purge the reporting tables |
B. You can drop the the data or to disable reporting |
| Additional Recommendations: |