20180126模擬SQL*Net message from dblink

lfree發表於2018-01-26

[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

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2150545/,如需轉載,請註明出處,否則將追究法律責任。

相關文章