nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

Steve Gerstner [bridgingIT]

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.

All comments

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

Steve Gerstner [bridgingIT]

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.

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.