Search notes:

Oracle SQL Plan operation SELECT STATEMENT REMOTE

A select statement that is fully executed on the remote database of a database link has the top level operator SELECT STATEMENT REMOTE:

explain plan for
select count(*) from xyz@db_far_away;
select * from dbms_xplan.display();
----------------------------------------------------------------------------------------
| Id  | Operation              | Name         | Rows  | Cost (%CPU)| Time     | Inst   |
----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT REMOTE|              |     1 | 12034  (14)| 00:00:01 |        |
|   1 |  SORT AGGREGATE        |              |     1 |            |          |        |
|   2 |   INDEX FAST FULL SCAN | XYZ_IX       |    33M| 12034  (14)| 00:00:01 | XINST~ |
----------------------------------------------------------------------------------------
Note
-----
   - fully remote statement

Oracle SQL Plan operation SELECT STATEMENT REMOTE

See also