Autonomous Transaction Processing

Get Involved. Join the Conversation.

Topic

    Joel Grocock
    ATP - Service Console / Monitored SQL
    Topic posted May 9, 2019 by Joel GrocockGreen Ribbon: 100+ Points, last edited May 9, 2019 
    37 Views
    Title:
    ATP - Service Console / Monitored SQL
    Summary:
    Delay in SQL statements appearing in the "Monitored SQL" screens
    Content:

    Hi,

     I've run a query from SQL*Developer (and SQL*Plus) against my ATP instance using the TP consumer group and the query is not being displayed in the Monitored SQL screens in the service console.
    (I have refreshed the screens)

    The query returns in 1.1 seconds. Should I expect to see this in the Monitored SQL screens?

    Another test query that takes around 70 seconds to return does appear in Monitored SQL.

    Any thoughts appreciated.
    Regards
    Joel