20180126模擬SQL*Net message from dblink
[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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【等待事件】SQL*Net message from dblink事件SQL
- 0126奇怪的SQLNet message from dblink模擬SQL
- 0824SQL/Net message from client 丟包模擬SQLclient
- 0124奇怪的SQL*Net message from dblinkSQL
- SQL*Net message from clientSQLclient
- sql net message from|to client與sql execution countSQLclient
- 【等待事件】SQL*Net more data from dblink事件SQL
- SQL*Net more data from dblink Reference NoteSQL
- select hang住等待SQL*Net message from ClientSQLclient
- SQL*Net more data from dblink引起library cache pinSQL
- SQL*Net message from client 事件產生的原因分析SQLclient事件
- [20161208]SQL*Net message from clientSQLclient
- SQL* Net message to client 和SQL * Net more data to client等待事件SQLclient事件
- SQL*Net more data from clientSQLclient
- Oracle模擬MySQL的show index from table命令OracleMySqlIndex
- Nodejs 模擬telnetNodeJS
- [20190622]收集SQLNet Message From Client資訊.txtSQLclient
- .NET 下 模擬陣列越界陣列
- 使用Netty模擬發生OOMNettyOOM
- 【PL/SQL】oracle建立dblinkSQLOracle
- Oracle的SQL*Net more data from client 等待事件分析OracleSQLclient事件
- improve spring integration read message performance from mqSpringORMMQ
- 使用PL/SQL模擬SQLLOAD的功能SQL
- 使用 Netcat 模擬 HTTP 請求HTTP
- ASP.NET的模擬應用程式ASP.NET
- Java模擬.NET的連線池 (轉)Java
- SQL Server建立dblink至MySQLServerMySql
- SQL Server :DBLINK建立及使用SQLServer
- sed+awk模擬簡單sql查詢SQL
- SQL Server模擬別的賬戶登入SQLServer
- 簡單實現.NET Hook與事件模擬Hook事件
- Oracle SQL performance with database links - dblinkOracleSQLORMDatabase
- 面試官:請用SQL模擬一個死鎖面試SQL
- oracle實用sql(13)--併發簡單模擬OracleSQL
- http模擬from表單提交,進行跨域請求和上傳資源HTTP跨域
- 模擬
- How to resolve ORA-19706 error when select from dblinkError
- 資料庫入門—航空公司模擬(pl/sql)資料庫SQL