信息:
11.2.0.3.0 - 64bit Production
各位大神,在sqlplus里执行以下SQL,然后就没有结果返回,一直不动。统计v$sqlarea相关的视图问题一样。执行时用的SYSDBA权限,排除权限问题。
做sql trace貌似是执行完成了。但就是没有结果返回。真心求解:
SQL> select count(*) from v$sql;
select count(*) from v$sql
*
第 1 行出现错误:
ORA-01013: 用户请求取消当前的操作
trace 内容:
SQL ID: 7r64n86whym61 Plan Hash: 1001747286
select count(*)
from
v$sql
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 1 0.17 213.49 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.18 213.49 0 0 0 0
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=36 us)
4377 4377 4377 FIXED TABLE FULL X$KGLCURSOR_CHILD (cr=0 pr=0 pw=0 time=1078524 us cost=0 size=13 card=1)
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 1 0.17 213.49 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.18 213.50 0 0 0 0
Misses in library cache during parse: 1
Misses in library cache during execute: 1
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6 0.01 0.05 0 0 0 0
Execute 7 0.00 0.04 0 0 0 0
Fetch 7 0.00 0.02 1 18 0 4
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 20 0.01 0.11 1 18 0 4
Misses in library cache during parse: 5
Misses in library cache during execute: 3
2 user SQL statements in session.
6 internal SQL statements in session.
8 SQL statements in session.
********************************************************************************
Trace file: ora11g_ora_14185_mysession.trc
Trace file compatibility: 11.1.0.7
Sort options: default
1 session in tracefile.
2 user SQL statements in trace file.
6 internal SQL statements in trace file.
8 SQL statements in trace file.
7 unique SQL statements in trace file.
115 lines in trace file.
221 elapsed seconds in trace file.