Oracle Database Discussions

SQL> drop table ttt;

Table dropped.

SQL> create table ttt(x varchar2(100));

Table created.

SQL>  insert into ttt values('CatchSQLPlan');

1 row created.

SQL>  select sql_text , sql_id from v$sql where sql_text like '%CatchSQLPlan%' and sql_text not like '%select%';

SQL_TEXT
--------------------------------------------------------------------------------
SQL_ID
-------------
 insert into ttt values('CatchSQLPlan')
bx2c6kcp0bzcg


SQL>  select count(*) from v$sql_plan where sql_id='bx2c6kcp0bzcg';

  COUNT(*)
----------
         0

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL>