monitor and no_monitor hints specify if SQL statement that take less (or more) than 5 seconds are monitored select /*+ monitor */ dummy from dual; select * from table(dbms_xplan.display_cursor(format => 'rowstats -rows last')); -- -- ---------------------------------------------------- -- | Id | Operation | Name | Starts | A-Rows | -- ---------------------------------------------------- -- | 0 | SELECT STATEMENT | | 1 | 1 | -- | 1 | TABLE ACCESS FULL| DUAL | 1 | 1 | -- ----------------------------------------------------