cursor_sharing为force时执行计划重用的迷惑

ora_lion

谢谢棉花糖ONE,现在明白了,这个执行计划迷惑的问题我还真的没注意过,明天再看看的整理下思路,现在想问题也多了点空间了。

Yong Huang

To 棉花糖ONE:

> SQL> select sql_text,sql_id,child_number from v$sql
>   2  where sql_text like 'select count(*) from kk1%';
>
> SQL_TEXT
> --------------------------------------------------------------------------------
> SQL_ID        CHILD_NUMBER
> ------------- ------------
> select count(*) from kk1 where id=:"SYS_B_0"
> 1fnfa7pqtz9h6            0
>
>
> SQL> select * from table(dbms_xplan.display_cursor('1fnfa7pqtz9h6','0'));

If you want to find the plan for a SQL you just executed, why not just
select * from table(dbms_xplan.display_cursor);
Make sure serveroutput is off if you do that.

Yong Huang

棉花糖ONE

原帖由 Yong Huang 于 2008-11-26 02:40 发表
To 棉花糖ONE:

> SQL> select sql_text,sql_id,child_number from v$sql
>   2  where sql_text like 'select count(*) from kk1%';
>
> SQL_TEXT
> --------------------------------------------------------------------------------
> SQL_ID        CHILD_NUMBER
> ------------- ------------
> select count(*) from kk1 where id=:"SYS_B_0"
> 1fnfa7pqtz9h6            0
>
>
> SQL> select * from table(dbms_xplan.display_cursor('1fnfa7pqtz9h6','0'));

If you want to find the plan for a SQL you just executed, why not just
select * from table(dbms_xplan.display_cursor);
Make sure serveroutput is off if you do that.

Yong Huang

习惯问题啊,习惯先查出sql_id,再看执行计划

[ 本帖最后由 棉花糖ONE 于 2008-11-26 10:10 编辑 ]

sqysl

呵呵，这是个费劲的习惯啊。

1x1xqq_cu

哈哈，老帖子解决了我的疑惑。多谢。