tag:blogger.com,1999:blog-5124641802818980374.post293763881941166365..comments2023-09-06T11:58:30.752+02:00Comments on Oracle related stuff: DBMS_XPLAN.DISPLAY_CURSOR And Parallel ExecutionUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5124641802818980374.post-69046014486678907422012-12-13T13:09:52.843+01:002012-12-13T13:09:52.843+01:00Hi Martin,
thanks a lot, a quick look into the of...Hi Martin,<br /><br />thanks a lot, a quick look into the official documentation was something I should have done right away.<br /><br />It looks like the Dynamic Performance View was the first time officially documented in the Oracle 8 timeframe and can be found in most documentation versions still officially available since then (8.1, 9.2, 10.1, 10.2 etc.).<br /><br />Either it never was functional, or ceased to function in one of the more recent releases.<br /><br />I'll have a look at some older versions may be some time later, just for curiosity.<br /><br />The official documentation of the view leaves a lot unclear what information it was supposed to provide, by the way.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-56319270792826529772012-12-13T12:28:22.318+01:002012-12-13T12:28:22.318+01:00Hi Randolf,
recently I have seen (in 11.1.0.7) th...Hi Randolf,<br /><br />recently I have seen (in 11.1.0.7) that there is a view v$execution and the documentation says it "displays information on parallel execution" - http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_1119.htm#REFRN30080. But I have never seen any rows in it. According to v$fixed_view_definition it is based on x$kstex (and it's the only view based on this object). But I did not find further information on the object - so I assumed it's perhaps not functional.<br /><br />MartinMartin Preisshttps://www.blogger.com/profile/06388592214305009761noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-62665122952018651022012-12-12T22:19:03.528+01:002012-12-12T22:19:03.528+01:00Hi Pavan,
I'm not aware of a V$EXECUTION view...Hi Pavan,<br /><br />I'm not aware of a V$EXECUTION view. You might mean V$PQ_TQSTAT, or you might mean one of the V$SQL related views, so I don't know exactly what you are referring to.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-21958926321652266672012-12-12T18:41:47.722+01:002012-12-12T18:41:47.722+01:00Hi Randolf,
I hope the parallel execution details...Hi Randolf,<br /><br />I hope the parallel execution details would be extracted using V$execution view. Which was externalized for user.<br /><br />Let me know your comments/inputs on this.<br /><br />Pavan Kumar N<br />Pavan Kumarhttps://www.blogger.com/profile/00782569679545599805noreply@blogger.com