20180126模拟SQL*Net message from dblink

简介: [20180126]模拟SQL*Net message from dblink.txt SCOTT@book> @ &r/ver1 PORT_STRING                    VERSION        BANNER -----------...

[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

目录
相关文章
|
1月前
|
SQL 数据库 C#
C# .NET面试系列十一:数据库SQL查询(附建表语句)
#### 第1题 用一条 SQL 语句 查询出每门课都大于80 分的学生姓名 建表语句: ```sql create table tableA ( name varchar(10), kecheng varchar(10), fenshu int(11) ) DEFAULT CHARSET = 'utf8'; ``` 插入数据 ```sql insert into tableA values ('张三', '语文', 81); insert into tableA values ('张三', '数学', 75); insert into tableA values ('李四',
65 2
C# .NET面试系列十一:数据库SQL查询(附建表语句)
|
6月前
|
SQL 关系型数据库 MySQL
【SQL异常】启动MySQL时发生系统错误的解决方法(net start mysql 发生系统错误 5。 拒绝访问)
【SQL异常】启动MySQL时发生系统错误的解决方法(net start mysql 发生系统错误 5。 拒绝访问)
132 1
|
安全 Java 数据库连接
Java报错javax.net.ssl.SSLException MESSAGE: closing inbound before receiving peer‘s close_notify解决方法
Java报错javax.net.ssl.SSLException MESSAGE: closing inbound before receiving peer‘s close_notify解决方法
Java报错javax.net.ssl.SSLException MESSAGE: closing inbound before receiving peer‘s close_notify解决方法
|
9月前
|
SQL 开发框架 前端开发
ASP.NET Core+Element+SQL Server开发校园图书管理系统(完)
ASP.NET Core+Element+SQL Server开发校园图书管理系统(完)
94 0
|
9月前
|
开发框架 JavaScript .NET
ASP.NET Core+Element+SQL Server开发校园图书管理系统(四)(下)
ASP.NET Core+Element+SQL Server开发校园图书管理系统(四)(下)
70 0
|
9月前
|
开发框架 JavaScript .NET
ASP.NET Core+Element+SQL Server开发校园图书管理系统(三)(下)
ASP.NET Core+Element+SQL Server开发校园图书管理系统(三)(下)
53 0
ASP.NET Core+Element+SQL Server开发校园图书管理系统(三)(下)
|
SQL Web App开发 Java
十四、.net core(.NET 6)搭建ElasticSearch(ES)系列之给ElasticSearch添加SQL插件和浏览器插件
给ES添加SQL插件的方法:下载SQL插件地址:https://github.com/NLPchina/elasticsearch-sql当前最新的是7.12版本,我的ES是7.13版本,暂且将就用一下,也许能用呢?
217 0
十四、.net core(.NET 6)搭建ElasticSearch(ES)系列之给ElasticSearch添加SQL插件和浏览器插件
|
SQL Oracle 关系型数据库
Oracle 等待事件研究:SQL*Net break/reset to client
SQL*Net break/reset to client事件是一个容易被误解的事件,这个事件看起来和网络有关,但实际上大多数情况下这个事件与网络无关。
388 0
Oracle 等待事件研究:SQL*Net break/reset to client
|
SQL 数据库
SAP ABAP——OPEN SQL(四)【FROM】
本文主要介绍SAP ABAP中OPEN SQL的FROM语句
252 0
SAP ABAP——OPEN SQL(四)【FROM】
|
SQL Windows
TIA Portal STEP 7 Professional V15 - WinCC Advanced V15需SP1。请在此PC中启用NET 3.5 SP1。在运行SQL server时需要此版本。
TIA Portal STEP 7 Professional V15 - WinCC Advanced V15需SP1。请在此PC中启用NET 3.5 SP1。在运行SQL server时需要此版本。
1214 0
TIA Portal STEP 7 Professional V15 - WinCC Advanced V15需SP1。请在此PC中启用NET 3.5 SP1。在运行SQL server时需要此版本。

热门文章

最新文章