tag:blogger.com,1999:blog-5124641802818980374.post7067380006645715334..comments2023-09-06T11:58:30.752+02:00Comments on Oracle related stuff: Dynamic Sampling On Multiple Partitions - BugsUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5124641802818980374.post-35622181943521450742012-03-17T20:18:04.045+01:002012-03-17T20:18:04.045+01:00Hi Dominic,
thanks for stopping by... I'm sti...Hi Dominic,<br /><br />thanks for stopping by... I'm still amazed by the fact that Oracle decided to enable deferred segment creation in Enterprise Edition by default.<br /><br />I've come across so many occasions where processes get into trouble because they didn't expect such a scenario (For example querying DBA_SEGMENTS to identify some segments for a particular activity).<br /><br />Looks like Oracle is still struggling themselves to catch up with that.<br /><br />But I see that you (and the bug description) also mention interval partitioning, so it's not exclusively related to deferred segment creation.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-50646841428300136912012-03-17T09:13:33.860+01:002012-03-17T09:13:33.860+01:00Hi Randolf,
I've just come across an ORA-0600...Hi Randolf,<br /><br />I've just come across an ORA-0600 error (kkedsGetTabBlkCnt: null segment) which maps to bug 13505390 on 11.2.0.3.<br /><br />This relates to dynamic sampling and either deferred segment creation or interval partitioning.<br /><br />In my particular circumstances, I got it from a range-list partitioned table where empty partitions had no segments yet.<br /><br />I'm surprised, given the error message, that when I create the deferred segments using dbms_space_admin.materialize_deferred_segments this does not address the issue (nor that plus gathering stats).<br /><br />At the moment the workaround seems to be to turn dynamic sampling off at whatever level (i.e. statment, session or system) is suitable or to patch.<br /><br />I'm still trying to distill a standalone test case from the application-specific error but no luck so far.<br /><br />Thought I'd just mention it as it seems relevant to your article.<br /><br />Cheers,<br />DominicDomBrookshttps://www.blogger.com/profile/02598622186013843759noreply@blogger.com