yeah, *** BUT *** this is true even with a normal connection (no db link) from the other machine, see :

DEVEL!!fco:bd_dev:/traffic/fco>hostname
bd_dev

DEVEL!!fco:bd_dev:/traffic/fco>sqlplus fco@bd_prod

SQL*Plus: Release 9.2.0.5.0 - Production on Qui Jul 5 14:37:10 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production

SQL>


==> in the dest db :

e069356@BD_PROD:SQL>select * from v$session where machine='bd_dev';

SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS MACHINE TERMINAL PROGRAM TYPE SQL_ADDRESS SQL_HASH_VALUE PREV_SQL_ADDR PREV_HASH_VALUE MODULE MODULE_HASH ACTION ACTION_HASH CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIME LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU CURRENT_QUEUE_DURATION CLIENT_IDENTIFIER
---------------- ---- ------- -------- ---------------- ----- ---------------- ------------------ ------------------ ---------------- ---------------- -------- --------- ------------------ ------------------------------ ------------------------------ ------------ ---------------------------------------------------------------- ------------------------------ ------------------------------------------------ ---------- ---------------- ------------------ ---------------- ------------------ ------------------------------------------------ ------------------ -------------------------------- ------------------ ---------------------------------------------------------------- -------------------- ------------------ ------------------ ------------------ ------------------ ------------------- ------------------ --- ------------- ---------- --- -------------------------------- -------- -------- -------- ---------------------- ----------------------------------------------------------------
C0000000F727C1C0 49 39892 1617823 C0000000FA27ADF8 66 FCO 0 2147483644 INACTIVE DEDICATED 66 FCO fco 16566 bd_dev pts/tc sqlplus@bd_dev (TNS V1-V3) USER C000000117EC6210 4282642546 C000000117EC6210 4282642546 SQL*Plus 3669949024 4029777240 521238 -1 0 0 0 05/07/2007 14:37:17 74 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0

==> yes, there IS a session, but NOT from a db link :

e069356@BD_PROD:SQL>select
2 username,osuser,status,sid,serial#,machine,process,terminal,program
3 from v$session
4 where saddr in ( select k2gtdses from sys.x_$k2gte );

não há linhas selecionadas (no rows selected)

e069356@BD_PROD:SQL>

[]s

Chiappa