tag:blogger.com,1999:blog-7395977411859619892.post7143484799999656525..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: dbms_xplan.display_cursorRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7395977411859619892.post-19673821440548800992015-12-13T10:00:03.621+01:002015-12-13T10:00:03.621+01:00nice! thank you!!nice! thank you!!Anonymoushttps://www.blogger.com/profile/00700471156681745356noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-76500879363552599362013-06-12T13:23:15.116+02:002013-06-12T13:23:15.116+02:00"If I query v$sqlplan, the row with the sql_i..."If I query v$sqlplan, the row with the sql_id is not there."<br /><br />Then you need to find out why the cursor doesn't get loaded in the library cache. If it's there, dbms_xplan.display_cursor will display it.Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-78802046463277885902013-06-12T11:57:40.327+02:002013-06-12T11:57:40.327+02:00I am on 11202 and am not able to make this work.
...I am on 11202 and am not able to make this work. <br /><br />I am trying to get the plan for a DELETE with gather_plan_statistics hint. And I have tried the above. Also tried with serveroutput on and off both, but I just cant get the plan. <br /><br />If I query v$sqlplan, the row with the sql_id is not there. <br /><br />The server is free, nothing else executing on it. So what could be going pcorahttps://www.blogger.com/profile/06175050663015422245noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-67747131916565435792012-09-06T13:31:11.937+02:002012-09-06T13:31:11.937+02:00very good one...Perfect...Thanks a tonvery good one...Perfect...Thanks a tonLochanhttps://www.blogger.com/profile/13405762076650425466noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-18414397494942697122010-10-08T10:24:53.674+02:002010-10-08T10:24:53.674+02:00Thank you for the Great Explanation ! This is what...Thank you for the Great Explanation ! This is what I was looking for.Unknownhttps://www.blogger.com/profile/13672265668204060318noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-69091742547493718592010-01-03T10:25:33.172+01:002010-01-03T10:25:33.172+01:00I bookmarked this page and for the time being it w...I bookmarked this page and for the time being it will be my bible... thanks a lot for this excellent explanationEva Brandhttps://www.blogger.com/profile/12084068581964300880noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-88521664381420919842008-03-08T00:49:00.000+01:002008-03-08T00:49:00.000+01:00Great job with the details on the other parts of t...Great job with the details on the other parts of the display_cursor statistics. Thanks!Unknownhttps://www.blogger.com/profile/08742301657283249149noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-86357643080217983202008-03-06T09:48:00.000+01:002008-03-06T09:48:00.000+01:00As requested http://jonathanlewis.wordpress.com/20...As requested http://jonathanlewis.wordpress.com/2008/03/06/dbms_xplan3/<BR/><BR/> by Jonathan Lewis:<BR/><BR/> ‘All’: Prints the Query block/Object Alias section, the Predicate information, and the Column Projection information after the basic plan.<BR/><BR/> ‘Advanced’: as for ‘All’, but also include the Outline information (the set of hints that will reproduce the plan).<BR/><BR/> ‘Jason arneilhttps://www.blogger.com/profile/01904982497311931571noreply@blogger.com