Re: select from ts$ in v$undostat.maxqueryid

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: _at_OracleSK

> Noveljic Nenad <nenad.noveljic_at_vontobel.com> 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/

--
http://www.freelists.org/webpage/oracle-l