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?
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.
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
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG