The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results forĀ 
Search instead forĀ 
Did you mean:Ā 

Need information about permanently running SQL from Confluence which load CPU

Aleksandr Timchenko
February 12, 2014

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!

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
Steve Gerstner [bridgingIT]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 13, 2014

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.

1 vote
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 12, 2014

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
February 13, 2014

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

0 votes
Aleksandr Timchenko
February 13, 2014

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

TAGS
AUG Leaders

Atlassian Community Events