sql monitor 12c
Dear Experts,
We have few questions on sql monitor.
1) Does it show predicate information?
2)How can we see which step is executing currently from the execution plan?
3)What all information can we gather from below sample?
SQL Text ------------------------------ SELECT MP.ORGANIZATION_CODE FROM APPS.MTL_PARAMETERS MP, APPS.MTL_MATERIAL_TRANSACTIONS MMT WHERE MP.ORGANIZATION_ID = MMT.ORGANIZATION_ID AND MMT.TRANSACTION_REFERENCE = :B1 GROUP BY MP.ORGANIZATION_CODE Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 1 Session : APPS (252:47226) SQL ID : bfc8q4kjw7mc3 SQL Execution ID : 16777289 Execution Started : 04/11/2022 17:19:55 First Refresh Time : 04/11/2022 17:19:59 Last Refresh Time : 04/11/2022 17:20:02 Duration : 7s Module/Action : e:INV:cp:xxttd/XXAPT_TSAP/INV/XXTTD_A01_MTVAPC_USER Service : PRODDB Program : STANDARD@erpprodapp01.ttd.com (TNS V1-V3) PLSQL Entry Ids (Object/Subprogram) : 4243362,1 PLSQL Current Ids (Object/Subprogram) : 4243362,1 Fetch Calls : 1 Binds ======================================================================================================================== | Name | Position | Type | Value | ======================================================================================================================== | :B1 | 1 | VARCHAR2(2000) | TTD/TRU/M12/2022/17901 | ======================================================================================================================== Global Stats =============================================================================== | Elapsed | Cpu | IO | Application | Fetch | Buffer | Read | Read | | Time(s) | Time(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | =============================================================================== | 7.03 | 0.76 | 6.26 | 0.01 | 1 | 166K | 10194 | 1GB | =============================================================================== SQL Plan Monitoring Details (Plan Hash Value=1307282366) ======================================================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Mem | Activity | Activity
0