So we've been messing with some Continuous Query Notifications for about a month now in our application. The goal of using CQN is to have a cache of the database items and refresh the cache whenever there's a change detected. It's mostly been going as expected, but then all the sudden we get a query running that we're not at all familiar with and it must have been the system running it, but we have no idea what.
Here's the query:
select subscription_name, location_name, user#, namespace, user_context, context_size, reg_id, nvl(con_id, 0)
from sys."CDB_SUBSCR_REGISTRATIONS"
where timeout <= :1
Does anyone know why this query would randomly run and what it's goal is? I can't seem to find any information about that table at all. We are on Oracle version 12.2.0.1
Thank you