请大家以SYS用户执行下面的查询语句:
SELECT * FROM SYS.x$kcccp WHERE INST_ID=1AND CPTNO=2 and CPODR_SEQ=2666AND ROWNUM SELECT * FROM SYS.x$kcccp WHERE INST_ID=1 AND CPTNO=2 and CPODR_SEQ=2666 AN
D ROWNUM SELECT * FROM SYS.x$kcccp WHERE INST_ID=1 AND CPTNO=2 and CPODR_SEQ=2666 AN
D ROWNUM select*from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Productio
n
SQL> SELECT * FROM SYS.x$kcccp WHERE INST_ID=1 AND CPTNO=2 and CPODR_SEQ=2666 AND ROWNUM SELECT * FROM SYS.x$kcccp WHERE INST_ID=1 AND CPTNO=2 and CPODR_SEQ=2666 AN
D ROWNUM
最初由 jlandzpa 发布
[B]连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> SELECT * FROM SYS.x$kcccp WHERE INST_ID=1 AND CPTNO=2 and CPODR_SEQ=2666 AN
D ROWNUM [/B]
jlandzpa
请你在9204下,把几个查询的条件改变下再查查看
我在HP-UX 安腾下基本每次执行都会挂起
谢谢!