[20180126]模拟SQL*Net message from dblink.txt
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SCOTT@book> create table t as select * from dba_objects ;
Table created.
CREATE PUBLIC DATABASE LINK LOOPBACK CONNECT TO SCOTT IDENTIFIED BY 'book' USING 'localhost:1521/book';
SCOTT@book> select sysdate from dual@loopback ;
SYSDATE
-------------------
2018-01-26 11:10:55
$ cat x1.txt
set term off
select * from t@loopback ;
set term on
SCOTT@book> @ x1.txt
SELECT * FROM V$ACTIVE_SESSION_HISTORY WHERE event = 'SQL*Net message from dblink' AND sample_time > '2018-01-26 11:10:55';
Record View
As of: 2018/1/26 11:13:49
SAMPLE_ID: 4859342
SAMPLE_TIME: 2018/1/26 11:13:17.368
IS_AWR_SAMPLE: N
SESSION_ID: 94
SESSION_SERIAL#: 85
SESSION_TYPE: FOREGROUND
FLAGS: 16
USER_ID: 83
SQL_ID: 2nhz1cyfwgt6d
IS_SQLID_CURRENT: Y
SQL_CHILD_NUMBER: 0
SQL_OPCODE: 3
SQL_OPNAME: SELECT
FORCE_MATCHING_SIGNATURE: 16891141731483804204
TOP_LEVEL_SQL_ID: 2nhz1cyfwgt6d
TOP_LEVEL_SQL_OPCODE: 3
SQL_PLAN_HASH_VALUE: 0
SQL_PLAN_LINE_ID:
SQL_PLAN_OPERATION:
SQL_PLAN_OPTIONS:
SQL_EXEC_ID: 16777216
SQL_EXEC_START: 2018/1/26 11:13:15
PLSQL_ENTRY_OBJECT_ID:
PLSQL_ENTRY_SUBPROGRAM_ID:
PLSQL_OBJECT_ID:
PLSQL_SUBPROGRAM_ID:
QC_INSTANCE_ID:
QC_SESSION_ID:
QC_SESSION_SERIAL#:
PX_FLAGS:
EVENT: SQL*Net message from dblink
EVENT_ID: 4093028837
EVENT#: 356
SEQ#: 1451
P1TEXT: driver id
P1: 1413697536
P2TEXT: #bytes
P2: 1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ => 看来在这里我理解错误.依旧看到是P2=1.
P3TEXT:
P3: 0
WAIT_CLASS: Network
WAIT_CLASS_ID: 2000153315
WAIT_TIME: 0
SESSION_STATE: WAITING
TIME_WAITED: 478
BLOCKING_SESSION_STATUS: UNKNOWN
BLOCKING_SESSION:
BLOCKING_SESSION_SERIAL#:
BLOCKING_INST_ID:
BLOCKING_HANGCHAIN_INFO:
CURRENT_OBJ#: 555
CURRENT_FILE#: 1
CURRENT_BLOCK#: 10696
CURRENT_ROW#: 0
TOP_LEVEL_CALL#: 5
TOP_LEVEL_CALL_NAME: FETCH
CONSUMER_GROUP_ID: 12889
XID: 0A000600B8540000
REMOTE_INSTANCE#:
TIME_MODEL: 1024
IN_CONNECTION_MGMT: N
IN_PARSE: N
IN_HARD_PARSE: N
IN_SQL_EXECUTION: Y
IN_PLSQL_EXECUTION: N
IN_PLSQL_RPC: N
IN_PLSQL_COMPILATION: N
IN_JAVA_EXECUTION: N
IN_BIND: N
IN_CURSOR_CLOSE: N
IN_SEQUENCE_LOAD: N
CAPTURE_OVERHEAD: N
REPLAY_OVERHEAD: N
IS_CAPTURED: N
IS_REPLAYED: N
SERVICE_HASH: 3427055676
PROGRAM: sqlplus@gxqyydg4 (TNS V1-V3)
MODULE: SQL*Plus
ACTION:
CLIENT_ID:
MACHINE: gxqyydg4
PORT: 0
ECID:
DBREPLAY_FILE_ID: 0
DBREPLAY_CALL_COUNTER: 0
TM_DELTA_TIME: 186420311
TM_DELTA_CPU_TIME: 866869
TM_DELTA_DB_TIME: 979153
DELTA_TIME: 186240964
DELTA_READ_IO_REQUESTS: 144
DELTA_WRITE_IO_REQUESTS: 32
DELTA_READ_IO_BYTES: 8880128
DELTA_WRITE_IO_BYTES: 8175616
DELTA_INTERCONNECT_IO_BYTES: 17055744
PGA_ALLOCATED: 9265152
TEMP_SPACE_ALLOCATED: 0
