More to add…from the Query Text Logical_Queries in Usage Tracking it starts with: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL

We would like to disable the query so it does not run. We have usage tracking enabled and can see the same series of queries running in every environment. Unfortunately the user name associated with these queries is a bunch of garbage and not a real user. I am not privy to the logs but have had others search. I will try…

@Federico Venturin, thanks for the reply. No one is running Oracle Analytics Desktop. The odd thing is the query that is running should run once a year or so but it is running daily and we cannot figure out why. It is so odd!!

Thanks, Gianni. I have looked at the S_NQ_JOB and it is empty. I am not sure where else to look. I am making an assumption that an agent has this scheduled as it is running at a particular time every day. Additionally, we do not see the results for it in the OAS monitor which causes some confusion. We have searched the…

What did you change? We have the same problem with this mapping. In our dev and test environments it runs well. In prod it hangs on the insert.