Home » RDBMS Server » Server Administration » sql plan issue (11.2.0.1 windows xp)
sql plan issue [message #537352] Tue, 27 December 2011 21:15 Go to next message
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

Re: sql plan issue [message #537354 is a reply to message #537352] Tue, 27 December 2011 21:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
V$SQL_PLAN contains the execution plan information for each child cursor loaded in the library cache.
Re: sql plan issue [message #537362 is a reply to message #537354] Tue, 27 December 2011 23:30 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks BlackSwan,
How can i find the sql plan for the insert sql?
Re: sql plan issue [message #537375 is a reply to message #537362] Wed, 28 December 2011 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no plan for INSERT VALUES, it is irrelevant.

Regards
Michel
Re: sql plan issue [message #537412 is a reply to message #537375] Wed, 28 December 2011 03:36 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Previous Topic: how to find the sid from v$session of my current session as soon as it make connection with DB
Next Topic: Understanding segment size
Goto Forum:
  


Current Time: Tue Apr 23 23:01:18 CDT 2024