Does blank lines in sql monitor report (text type) indicate that those operations are not called
From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Wed, 15 Jan 2020 14:59:59 -0500
Message-ID: <CAJSrDUo0jpA9+Mkhc+Gdmh-bfzDneZ-tb-L9cxcpL-cKJ3oCag_at_mail.gmail.com>
Hi Listers,
select /*+ monitor */ count(9) from dba_objects
| Elapsed | Cpu | Other | Fetch | Buffer |
| Time(s) | Time(s) | Waits(s) | Calls | Gets |
| 0.04 | 0.04 | 0.00 | 1 | 4085 |
| Id | Operation | Name | Rows | Cost |
Time | Start | Execs | Rows | Mem | Activity | Activity Detail |
| | | | (Estim) | |
Active(s) | Active | | (Actual) | (Max) | (%) | (# samples) |
| 0 | SELECT STATEMENT | | | |
Date: Wed, 15 Jan 2020 14:59:59 -0500
Message-ID: <CAJSrDUo0jpA9+Mkhc+Gdmh-bfzDneZ-tb-L9cxcpL-cKJ3oCag_at_mail.gmail.com>
Hi Listers,
I have one quick question. Does the blank column values mean those operations are not called and do they mean 0 records returned.
SQL Text
select /*+ monitor */ count(9) from dba_objects
Global Information
Status : DONE (ALL ROWS) Instance ID : 1 Session : KUNWAR (102:53661) SQL ID : 74f93u44y6nmg SQL Execution ID : 16777217 Execution Started : 01/15/2020 07:13:50 First Refresh Time : 01/15/2020 07:13:50 Last Refresh Time : 01/15/2020 07:13:50 Duration : .042713s Module/Action : SQL*Plus/- Service : SYS$USERS Program : sqlplus_at_*** Fetch Calls : 1
Global Stats
| Elapsed | Cpu | Other | Fetch | Buffer |
| Time(s) | Time(s) | Waits(s) | Calls | Gets |
| 0.04 | 0.04 | 0.00 | 1 | 4085 |
SQL Plan Monitoring Details (Plan Hash Value=1203538133)
| Id | Operation | Name | Rows | Cost |
Time | Start | Execs | Rows | Mem | Activity | Activity Detail |
| | | | (Estim) | |
Active(s) | Active | | (Actual) | (Max) | (%) | (# samples) |
| 0 | SELECT STATEMENT | | | |
1 | +0 | 1 | 1 | | | |
| 1 | SORT AGGREGATE | | 1 | |
1 | +0 | 1 | 1 | | | |
| 2 | VIEW | DBA_OBJECTS | 89023 | 3031 |
1 | +0 | 1 | 91210 | | | |
| 3 | UNION-ALL | | | |
1 | +0 | 1 | 91210 | | | |
| 4 | FILTER | | | |
1 | +0 | 1 | 91210 | | | |
| 5 | HASH JOIN | | 89326 | 392 |
1 | +0 | 1 | 91210 | 2M | | |
| 6 | INDEX FULL SCAN | I_USER2 | 125 | 1 |
1 | +0 | 1 | 125 | | | |
| 7 | HASH JOIN | | 89326 | 391 |
1 | +0 | 1 | 91210 | 2M | | |
| 8 | INDEX FULL SCAN | I_USER2 | 125 | 1 |
1 | +0 | 1 | 125 | | | |
| 9 | TABLE ACCESS FULL | OBJ$ | 89326 | 389 |
1 | +0 | 1 | 91210 | | | |
| 10 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 |
1 | +0 | 885 | 1 | | | |
| 11 | NESTED LOOPS SEMI | | 1 | 2 |
| | | | | | | <<<<<<< See no entries for Rows(Actual) and other columns for id 11-18
| 12 | INDEX SKIP SCAN | I_USER2 | 1 | 1 |
| | | | | | |
| 13 | INDEX RANGE SCAN | I_OBJ4 | 1 | 1 |
| | | | | | |
| 14 | TABLE ACCESS FULL | USER_EDITIONING$ | 1 | 2 |
| | | | | | |
| 15 | NESTED LOOPS | | 1 | |
| | 1 | | | | |
| 16 | INDEX FULL SCAN | I_LINK1 | 1 | |
| | 1 | | | | |
| 17 | TABLE ACCESS CLUSTER | USER$ | 1 | |
| | | | | | |
| 18 | INDEX UNIQUE SCAN | I_USER# | 1 | |
| | | | | | | ====================================================================================================================================================
-- Cheers, Kunwar -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 15 2020 - 20:59:59 CET