My Oracle Support Banner

OSB Managed Server Takes A Long Time To Start Due To Inefficient SQL Statement (Doc ID 2537575.1)

Last updated on OCTOBER 05, 2021

Applies to:

Oracle Service Bus - Version and later
Information in this document applies to any platform.


On : version, OSB Core Functionality

OSB managed server takes a long time to restart

with JMS reporting enabled, the server start up checks for below query, "SELECT 1 FROM WLI_QS_REPORT_ATTRIBUTE" and the query become quite slow when the table has 54 millions of rows.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.