Hello Nenad,
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 :)
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Noveljic Nenad <nenad.noveljic@xxxxxxxxxxxx> hat am 4. Februar 2020 um 09:17--
geschrieben:
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
usage:
select ts# from sys.ts$ where ts$.online$ != 3 and bitand(flags,2048) != 2048
;
select
undoblks,txncount,maxquerylen,maxconcurrency,activeblks
from v$undostat u
where maxqueryid='89w8y2pgn25yd'
;
UNDOBLKS,TXNCOUNT,MAXQUERYLEN,MAXCONCURRENCY,ACTIVEBLKS
39199,4027,1378,5,2531960
…
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?
Best regards,
Nenad
https://nenadnoveljic.com/blog/