The SMON spit out this error after the cycle of the db on the rollback of the huge insert into the largest table in one of our warehouse environments. I had serious concerns about a poor execution plan and wondered what we were going to be in for on the rollback and with good reason. The source to the performance hit was a combination of missing column statistics on the main table used for the joins from the staging table, but also fragmentation caused by a poor design choice, (yes, get exchange partition in there ASAP!) Here is the issue w/ fix with the…
-
-
Like Chet, from OracleNerd, I received my official Blogger Approval for Oracle Open World yesterday! This will be my first attendance, as something always came up before that kept me from going, so I am looking forward to the event. A number of people asked me why I didn’t submit a presentation, but I think I’m going to check out the event as a blogger for my first time out and see about presenting next year! 🙂
-
So we have a parallel process, coordinator 739 running, just not very well… I have an ugly pink section in my OEM grid and as we know, pink is not a DBA Girl’s favorite color… 🙂 Not so fast… the process, due to the wait on temp and then to buffer, has decided to “force” it to serial? Description OBJECT Obj Node Order Rows Bytes Cost In/Out PQ Dist. CREATE TABLE STATEMENT 12 3,200 PX COORDINATOR FORCED SERIAL 11 PX SEND QC (RANDOM) SYS.:TQ20001 :Q2001 10 13,717,999…
-
I started to write this blog post almost two months ago and finally updated it to post to the site. I think it’s a bit more fun in hindsight anyway… 🙂 With my children at an age where they really would like their mother to just go get a life, (and get out of theirs as much as possible… :)) I chose this year to approach Ron Bich and Tim Gorman at RMOUG training days and state my interest in participating more. I was quickly informed there was no escape at that point and told I had to put my…
-
Thanks to Chet Justice of OracleNerd, I’m now registered for Oracle Open World 2011 with the Blogger’s registration. I will be sitting here impatiently waiting for October now… 🙂 Anyone who remembers last year’s will also remember that I (again) did not get to attend and worked miserably through the week, listening to the tweets on Twitter and blurbs on Facebook, then was reminded on Blogs afterwards of all I missed. Not this year! I am going and I am going to enjoy it- try and stop me… 🙂
-
Although Streams is a goner, (Golden Gate taketh over…) My notes on performance considerations when utilizing streams as I work with it is always valuable. These came from a number of blogs, notes from Oracle and simple grief, so thought I would share… 🙂 1. TYPE OF DATA REPLICATION Due to the way this table is loaded, we need to be concious of “queue spill”. Queue spill, per Oracle’s support documentation, is associated with LCR’s not being processed in a timely fashion per interval from the buffered queue, resulting in the old LCRs to “spill” from memory out to disk…