sql plan issue [message #537352] |
Tue, 27 December 2011 21:15 |
andy huang
Messages: 498 Registered: July 2011
|
Senior Member |
|
|
Dear all,
I can not find the sql plan for insert statement,why?
Select sql_text From v$sql a
Where a.SQL_ID = '0yungrk19a277';
-------------------------------
INSERT INTO OS_USERBILL_ACTV_READ_MON_DT
(MONTHNO, MAILCODE, OPERTYPE, PROVCODE, AREACODE, DAY_TOTALCOUNT, TOTALCOUNT,
CREATETIME, MODIFYTIME, SENDER_TYPE, SENDER_DOMAIN)
VALUES
(:B9 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , SYSDATE, SYSDATE, :B7 , :B8 )
Select count(1) From v$sql_plan bb
Where bb.SQL_ID = '0yungrk19a277';
-----
0
[Updated on: Wed, 28 December 2011 00:53] by Moderator Report message to a moderator
|
|
|
|
|
|
|