do you possibly have any monitoring tool that runs a query on dba_tablespaces
(e.g. select * from dba_tablespaces where tablespace_name like '%TEST%')?
You should see this query as a recursive one then :)
Independent Oracle performance consultant and researcher
Noveljic Nenad <nenad.noveljic@xxxxxxxxxxxx> hat am 4. Februar 2020 um 09:17--
The following query (sql_id is 89w8y2pgn25yd) was recorded in
v$undostat.maxqueryid in a 12.2. database during a period of a high undo
select ts# from sys.ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048
from v$undostat u
The query itself has never been captured in v$active_session_history which
might indicate that the cursor remains open during some other activity.
There were two deletes running in the observed time period.
Does anybody know what could trigger the execution of the query above?