Connect by hanged on 10g r2 ?
- From: Lou Fangxin <anysql@xxxxxxxxx>
- To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 10 Sep 2005 14:11:39 +0800
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
Other related posts:
- » Connect by hanged on 10g r2 ?