Chris Shaw from Colorado Springs SQL Server SQLPass group invited me to come speak at this wonderful group last week and I promised a few folks that I would upload my slides to my site, (they are also available via Chris, too…) The group is a small, close knit group that I was very pleased to have the opportunity to speak to and look forward to having more interaction with in the future! Thank you to Chris and the rest of Springs SQLPass! Oracle for the SQL Server DBA Slides
-
-
Two things to be happy about today! 1st- Enkitec did a lovely announcement on Enkitec regarding my coming on board. I just arrived last night after three days at the main office in Irving, Tx, (Dallas area is lovely with all the fields of Blue Bonnet flowers this time of year…) and am psyched about working remotely for them from my home, northwest of Denver. 2nd- I have a wonderful opportunity to speak this evening at Colorado Springs SQL Pass group on “Oracle for the SQL Server DBA”. SpringsSQL It’s only going to get crazier the next two months from…
-
I’m forwarding out the latest KSCOPE 2012 Email. I love their stuff!! ———————————————————————————— The stars at night are big and bright, deep in the heart of Texas… And some of the brightest stars of the Oracle world will light up the scene at ODTUG’s Kscope12, San Antonio, June 24-28. Celebrated around the world for its top-notch content, outstanding networking opportunities, and memorable special events, ODTUG Kscope is unquestionably THE premier user conference for Oracle training. Kscope12 promises to deliver the goods again this year! At last year’s special event, ODTUGgers were putting on the Ritz aboard the Queen Mary. At…
-
This is not an “I’m against Oracle Best Practices” article. This is not an “I’m preaching against histograms” article. This is not an article telling folks that they should EVER take the steps or the choices that are presented in this article. I’m also going to refer to the wonderful post by Greg Rahn as to the reasons why what works in my environment would most likely NOT work in yours: http://structureddata.org/2008/10/14/dbms_stats-method_opt-and-for-all-indexed-columns/ What this article IS: An honest account of how a unique database design was impacted when changing from a previously researched method of stats collection to post an…
-
As many of you know, I’ve been a bit busy since RMOUG Training Days finding a number of presentation opportunities and while I was at it, a new gig with Enkitec. I am finally sitting down and putting to paper what a great year the RMOUG Training Days conference had for 2012. As everyone is still reeling from the great keynote from Cary Millsap, (so glad I was wrong about screwing up my passenger pick-up schedule, thinking I’d left our keynote speaker at the airport!!) His speech was enlightening, enjoyable and worth every minute of a heavy morning commute to…
-
Graham Wood was kind enough to send me a quick email and let me know that my presentation slides weren’t downloading correctly from RMOUG’s website, so I’ve put them here for anyone that may like to have them. I’m still recovering from the post RMOUG Training Day festivities, aka Foak Table, which was held up in Breckenridge again this year. I will make sure to blog about Training Days and the post event at a later date, but until then, here is a link to my slides. Please email me with any questions or comments you may have- always glad…
-
I ran out of time before I was able to provide an adequate white paper this year for my EM12c presentation, but there was some valuable info in what I had started, so thought I’d turn it into a mulit-part blog post… The Oracle Enterprise Manager, (OEM) is the standard monitoring tool for Enterprise Edition Oracle databases. The interface allows the DBA to manage the entire Oracle stack using a single console. The installation and interface is easy for most DBA’s to implement and utilize. In the newest EM12c version, it encompasses integrated systems management, application management, application-to-disk and cloud…
-
As busy as I am with the 11g project, (no real weekends off for 9 weekends and counting… :P) I wanted to take some time out to write on the upcoming RMOUG Training Days 2012. For those of you Oracle techies, DBA or Developer, this is a must attend and for any who do choose to travel and attend- kudos to you, good choice. As one of the directors on the RMOUG board, I can attest to the incredible amount of time and resources that have been invested into what is easily, the best grass-roots, Oracle conference around. John Jeunette,…
-
As I continue to work on very large databases, (VLDB), I am exposed to more opportunities to speed up IO. This can involve Oracle’s solution of Exadata or stand alone improvements with options such as SSD, (Solid State Disk) which can offer faster IO performance at a fraction of the price. When this option becomes a reality, there will always be non-DBA’s that advise what would best benefit from the hardware, but to take the time to research what would truly benefit is important for the DBA to perform. The Just the Facts on Solid State Disk: There are several…
-
I’ve spent the week updating, packing and communicating in preparation for my trip to Oracle Open World 2011. As with most folks that are attending, there is a lot to prepare for, but I have that added challenge of three kids who find this a fine opportunity to drive their father to distraction, as my ex-husband is responsible with managing their week, which he is unaccustomed to. Although I’m thankful for Google calendar that will tell my ex where and when each child has to be at all times, what homework, social events, etc., it is not a lot of fun for…
-
I truly believe that database myths are the scourge of the database world. With that said, I have to blame myself for not being specific enough in one of my own blog posts and propagating one myself! As it was brought to my attention by Tanel Poder and Greg Rahn, I hadn’t put a post out here until now, so apologies! I have flipped back to an almost exclusively 10g environment the last three months, but even though I’m back to my old stomping grounds, now fully staffed with almost double the DBA’s that were present when I left, have…
-
This is another blog post about how TEMP can kill you in performance. The Program Global Area, aka PGA, is a memory region that allows Oracle to perform many processes that once fell to static calculations in parameters that had to be managed by a DBA. As frustrating as it might be to a DBA to not have enough memory to allocate to the performance enhancing feature, I found it even more frustrating to find NO PGA allocation to window sorts. We were experiencing poor performance in one of our environments, but I noted it was only during heavy workloads,…
-
The introduction of the temp tablespace was a crucial step in the RDBMS to separating the “work area” for sorting and specific join operations from permanent segments. To eliminate the performance challenges of sorts and hash against the I/O threshold involved with performing this word in the temp tablespace, Oracle 9i introduced the Program Global Area, (PGA) to complete sorts and hashes within memory. DBA’s spent considerable time tuning the PGA, attempting to continually ensure that as more complex sorting and join features emerged, that these processes would complete their work within the PGA and not require such a large…
-
I’ve always had a *thing* for trace files. They serve me well- I like them and they seem to really like me. I have a special affinity for deadlock trace files and someone needs to remind me to pester Cary Millsap about a tool to decipher them so I have even more data to go through…:) Even without any tools, I can easily pull out what is important and work from this data to run queries and reports to drill down to find work-arounds when changes to logic or design are not an option. Deadlocks, although quite unpleasant, I find…
-
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…