Connect by hanged on 10g r2 ?

Hi all:   

SQL> SELECT ID, PARENT_ID FROM V$SQL_PLAN WHERE HASH_VALUE=2425599108; ID PARENT_ID
---------- ----------

0
1 0
2 1
3 2
4 2
5 1

6 rows selected.

Elapsed: 00:00:00.01
SQL> SELECT ID, PARENT_ID FROM V$SQL_PLAN WHERE HASH_VALUE=2425599108 2 CONNECT BY PARENT_ID = PRIOR ID START WITH ID=0; SELECT ID, PARENT_ID FROM V$SQL_PLAN WHERE HASH_VALUE=2425599108 *
ERROR at line 1:
ORA-01013: user requested cancel of current operation -- hanged.

Elapsed: 00:00:42.27

SQL> SELECT * FROM (SELECT ID, PARENT_ID FROM V$SQL_PLAN WHERE HASH_VALUE=2425599108 )
CONNECT BY PARENT_ID = PRIOR ID START WITH ID=0; 2 ID PARENT_ID
---------- ----------

0
1 0
2 1
3 2
4 2
5 1

6 rows selected.

Elapsed: 00:00:00.02

--

Welcome, Fangxin.Lou from China
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html

--

http://www.freelists.org/webpage/oracle-l Received on Sat Sep 10 2005 - 01:15:48 CDT