tag:blogger.com,1999:blog-14654018.post6638484692839186047..comments2023-07-18T12:55:13.959+01:00Comments on The /*+Go-Faster*/ Oracle Blog: Partition Maintenance with Global IndexesDavid Kurtzhttp://www.blogger.com/profile/00468908370233805717noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-14654018.post-73352344832549215362013-10-30T21:17:08.699+00:002013-10-30T21:17:08.699+00:00I recently ran across this recursive SQL in an AWR...I recently ran across this recursive SQL in an AWR report taking a huge amount of ET. In particular, "PX Deq Credit send blkd" was in the Top 5 Timed Events with avg wait = 844 ms. This implies that the SELECT was using parallel, but that the INSERT is note.<br /><br />So my question is: should ALTER SESSION ENABLE PARALLEL DML be executed prior to dropping partition to improve performance?Jeff Jacobshttps://www.blogger.com/profile/13361525811667000354noreply@blogger.comtag:blogger.com,1999:blog-14654018.post-23459691580511971202009-12-21T10:03:14.575+00:002009-12-21T10:03:14.575+00:00I have responded to Randolf's comment by updat...I have responded to Randolf's comment by updating the main blog posting.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-14654018.post-4739009912411643722009-10-30T15:40:15.248+00:002009-10-30T15:40:15.248+00:00David,
what you outline is also described in the ...David,<br /><br />what you outline is also described in the <a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/partiti.htm#i1006820" rel="nofollow">manuals</a> I think.<br /><br />What about the UPDATE [GLOBAL] INDEXES options of the partition maintenance operations?<br /><br />These should allow you to perform the partition maintenance even with data in place without invalidating the global index.<br /><br />Any particular reason why you don't want to use them in the Peoplesoft environment?<br /><br />Best Regards,<br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.com