Need information about permanently running SQL from Confluence which load CPU

[Aleksandr Timchenko]

We catch following SQL from Confluence:

SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name

Bind variable values is:

:1 = '%'
:2 = 'PROBABLYNOT'

Could you provide information about this query, it place and how to disable similar SQLs or minimize quantity of runs?

Thanks!

[Steve Gerstner [bridgingIT] · Accepted solution]

I would suggest going into safe mode -> https://confluence.atlassian.com/display/UPM/Disabling+and+Enabling+Add-ons

If all works fine then, you should enable one plugin after the other and check which one is causing your problem.

[Nic Brough [Adaptavist]]

That is very odd - none of the Confluence systems I've got access to are running anything like that (or, if they are, it's infrequent and I'm simply not getting it in the logs)

You probably need to examine the add-ons you're using to see if one of them is causing it

[Aleksandr Timchenko]

Thanks for the your hint. We will investigating all add-ons and keep posted here.

[Aleksandr Timchenko]

Thanks for the your hint. We will investigating all add-ons and keep posted here.