INSERT INTO t
SELET *
FROM t@dblink
WHERE id = :a;

connect .../...
exec dbms_session.session_trace_enable;
INSERT INTO t
SELET *
FROM t@dblink
WHERE id = :a;
disconnect

set autotrace on
INSERT INTO t
SELET *
FROM t@dblink
WHERE id = :a;
set autotrace off

SQL> set autotrace on statistics
SQL> select * from dual;
D
-
X

1 row selected.


Statistics
------------------------------------------------------
          1  recursive calls
          0  db block gets
          3  consistent gets
          2  physical reads
          0  redo size
        407  bytes sent via SQL*Net to client
        396  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL> set autotrace off