tag:blogger.com,1999:blog-5124641802818980374.post1787988376923164386..comments2023-09-06T11:58:30.752+02:00Comments on Oracle related stuff: Extended DISPLAY_CURSOR With Rowsource StatisticsUnknownnoreply@blogger.comBlogger12125tag:blogger.com,1999:blog-5124641802818980374.post-13957029849161799492019-08-07T10:09:13.918+02:002019-08-07T10:09:13.918+02:00XPLAN_ASH works fine for queries which run into th...XPLAN_ASH works fine for queries which run into that ORA-065211 when analyzed with xplan_extended_display_cursor.sql. Thank you very much :-).Robert Ortelnoreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-79400445736360357102019-08-07T09:17:18.183+02:002019-08-07T09:17:18.183+02:00Hi Randolf,
database versions are 12.1.0.2.180717...Hi Randolf,<br /><br />database versions are 12.1.0.2.180717, 18.5 and 18.7 which run into that. I never bothered with the output options and was fine with the default. I will check your comments and see if that helps.<br /><br />PGA for the 12.1.0.2.180717 database is:<br /><br />pga_aggregate_limit 0<br />pga_aggregate_target 90G<br /><br />I will get in contact with you via mail to reduce the exchange here.<br /><br />Regards,<br />RobertRobert Ortelnoreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-30908841829004624362019-08-05T23:42:31.847+02:002019-08-05T23:42:31.847+02:00Hi Robert,
could you mention which Oracle databas...Hi Robert,<br /><br />could you mention which Oracle database version?<br /><br />I'm regularly using XPLAN_ASH which is the newer and more sophisticated version of that script (when using ASH option "NONE" and ALLSTATS [LAST] formatting option XPLAN_ASH will only show Rowsource Statistics but no Active Session History related stuff), and it works for me even for extremely complex execution plans (up to several thousand of operations / lines). I've never encountered the mentioned error so far, up to and including version 18c. So maybe you can provide more details, like exact version used and maybe PGA memory settings etc.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-31323948576920306282019-08-01T13:34:05.838+02:002019-08-01T13:34:05.838+02:00Hi Randolf,
very very nice, but runs into ORA-065...Hi Randolf,<br /><br />very very nice, but runs into ORA-06522: CANNOT ALLOCATE ENOUGH MUTABLE AREA for complex executions plans as it seems and only runs fine as long as the execution plan is simple enough to some unknown degree. Unfortunatly oerr and oracle support are not of great help understanding what that error actually means.<br /><br /> <br /><br />oerr:<br />ORA-06522: string <br /> Cause: ORA-06520 or ORA-065211 could stack this error with a system specific error string. <br /> Action: This error string should give the cause for errors ORA-06520 or ORA-065211 <br /><br />oracle support:<br />This error is due to the script that is provided and has to do with the associated data types <br />An object's mutability is determined by its type. ... Other objects like integers, floats, strings and tuples are objects that can not be changed. <br />So there is an issue with the script overflowing the object type in one or more areas.<br /><br /><br />Maybe it helps you to understand and maybe fix it.<br /><br /><br />RobertRobert Ortelnoreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-63759692688787152162018-04-08T14:29:18.699+02:002018-04-08T14:29:18.699+02:00Hi Amit,
just check for my XPLAN_ASH script that ...Hi Amit,<br /><br />just check for my XPLAN_ASH script that I've published as well, it adds all that, but requires the Diagnostic Pack license for Active Session History (and Tuning Pack license for Real Time SQL Monitoring) support.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-46992772534380318162018-03-24T15:03:12.698+01:002018-03-24T15:03:12.698+01:00Hi Randolf,
This is really cool.
How we can add a ...Hi Randolf,<br />This is really cool.<br />How we can add a Activity% and Actual activity like 'direct path read temp (1)' in the script.Amit Sarohahttps://www.blogger.com/profile/09303374930427066012noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-48276328280517618822011-12-23T22:07:11.354+01:002011-12-23T22:07:11.354+01:00great
thanks for sharing
rocket science in there
...great<br />thanks for sharing<br />rocket science in there<br /><br />earl<br />OracleMan ConsultingAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-70157894698939089532011-12-23T21:55:04.425+01:002011-12-23T21:55:04.425+01:00Thanks Randolf, really nice Christmas present :)Thanks Randolf, really nice Christmas present :)jchttps://www.blogger.com/profile/11021890730078704441noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-77870180206603295552011-12-23T15:22:36.010+01:002011-12-23T15:22:36.010+01:00Thanks for this present! :-) Very nice, easily rea...Thanks for this present! :-) Very nice, easily readable output!Marcus Mönnighttp://marcusmonnig.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-17877128585063960692011-12-23T12:59:57.033+01:002011-12-23T12:59:57.033+01:00a great idea: display_cursor on steroids. Many tha...a great idea: display_cursor on steroids. Many thanks for this christmas present. If the display wide is not sufficient I will adjust the font size ...<br /><br />MartinMartin Preisshttps://www.blogger.com/profile/06388592214305009761noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-915929366669623842011-12-23T07:23:18.307+01:002011-12-23T07:23:18.307+01:00Awesomne utility. This one will be very useful in ...Awesomne utility. This one will be very useful in almost any performance analysis. Thank you very much for sharing it.Arup Nandahttps://www.blogger.com/profile/03392706779349258765noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-26751581624123899022011-12-23T01:50:24.453+01:002011-12-23T01:50:24.453+01:00Nice script!
I like all the graphs and the execut...Nice script! <br />I like all the graphs and the execution order and parent id stuff.<br />thanks for referencing the script on dboptimizer.com.<br />- KyleKyle Haileyhttps://www.blogger.com/profile/13586511268045480856noreply@blogger.com