Database

Get Involved. Join the Conversation.

Topic

    Karthik Varma
    Which statements will be under monitored SQL tab [Autonomous...Answered
    Topic posted October 10, 2019 by Karthik VarmaGold Medal: 3,500+ Points, tagged Apex 
    18 Views, 1 Comment
    Title:
    Which statements will be under monitored SQL tab [Autonomous Database::Service console] ?
    Content:

    I have created few tables using Oracle Apex. Will these queries/statements listed here in monitored SQL tab?

     

    Image:

    Best Comment

    Simon Law

    Not every SQL will show up there. Here is an extract from the doc :

    Real-Time Database Operations provides the ability to monitor composite operations automatically. The database automatically monitors parallel queries, DML, and DDL statements as soon as execution begins. By default, Real-Time SQL Monitoring automatically starts when a SQL statement runs in parallel, or when it has consumed at least 5 seconds of CPU or I/O time in a single execution.

    Comment

     

    • Simon Law

      Not every SQL will show up there. Here is an extract from the doc :

      Real-Time Database Operations provides the ability to monitor composite operations automatically. The database automatically monitors parallel queries, DML, and DDL statements as soon as execution begins. By default, Real-Time SQL Monitoring automatically starts when a SQL statement runs in parallel, or when it has consumed at least 5 seconds of CPU or I/O time in a single execution.