oracle致命的双工通讯协议错误,大家帮忙看看ORA-03106: 致命的双工通信协议错误...
trace文件内容如下：TKPROF: Release 11.2.0.1.0 - Development on 星期二 5月 31 17:56:31 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates.All rights reserved.Trace file: D:\Oracle\diag\rdbms\sphnc\sphnc..
trace文件内容如下：
TKPROF: Release 11.2.0.1.0 - Development on 星期二 5月 31 17:56:31 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Trace file: D:\Oracle\diag\rdbms\sphnc\sphnc\trace\sphnc_ora_5504.trc
Sort options: default
********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
SQL ID: 7k7vqur9zap62
Plan Hash: 0
alter session set SQL_TRACE=true
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 95
********************************************************************************
SQL ID: atuqq7yx8bt3r
Plan Hash: 4100743798
SELECT *
FROM
bd_bankaccbas where pk_banktype='0001201000000005C1OO'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 5 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 5 0 2
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 95
Rows Row Source Operation
------- ---------------------------------------------------
2 TABLE ACCESS BY INDEX ROWID BD_BANKACCBAS (cr=5 pr=0 pw=0 time=0 us cost=2 size=682 card=2)
2 INDEX RANGE SCAN I_BD_BANKACCBAS_3 (cr=3 pr=0 pw=0 time=6 us cost=1 size=0 card=2)(object id 91032)
********************************************************************************
SQL ID: cr8vgn5189c0q
Plan Hash: 0
alter session set SQL_TRACE=false
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 95
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 5 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 7 0.00 0.00 0 5 0 2
Misses in library cache during parse: 2
Misses in library cache during execute: 1
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 0 0.00 0.00 0 0 0 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 0 0.00 0.00 0 0 0 0
Misses in library cache during parse: 0
3 user SQL statements in session.
0 internal SQL statements in session.
3 SQL statements in session.
********************************************************************************
Trace file: D:\Oracle\diag\rdbms\sphnc\sphnc\trace\sphnc_ora_5504.trc
Trace file compatibility: 11.1.0.7
Sort options: default
1 session in tracefile.
3 user SQL statements in trace file.
0 internal SQL statements in trace file.
3 SQL statements in trace file.
3 unique SQL statements in trace file.
47 lines in trace file.
254 elapsed seconds in trace file.
魔乐社区（Modelers.cn) 是一个中立、公益的人工智能社区，提供人工智能工具、模型、数据的托管、展示与应用协同服务，为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作，由全产业链共同建设、共同运营、共同享有，推动国产AI生态繁荣发展。
更多推荐
0
0- 0
已为社区贡献2条内容
所有评论(0)