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…
-
Kellyn’s Schedule of Presentations, 2012, 2nd and 3rd Quarter March 24th, 2012, Colorado Springs, CO SQL Saturday Oracle for SQL Server DBA’s April 19th, 2012, Billund, Denmark MOW 2012 ASH Analytics- Top Activity, the Next Generation April 20th, 2012, Billund, Denmark MOW 2012 EM12c: Making Oracle Enterprise Manager Work for You May 30th, 2012, Hämeenlinna, Finland OUG Harmony 2012 EM12c: Making Oracle Enterprise Manager Work for You June 1st, 2012, Riga, Latvia JUV Harmony 2012 EM12c: Making Oracle Enterprise Manager Work for You June 26th, 2012, San Antonio, TX. KSCOPE 2012 EM12c: Making Oracle Enterprise Manager Work for You
-
Yes, my dear Watson, Bind Peeking is still an issue in 11g…. We recently upgraded from 10.2.0.4 to 11.2.0.2.0 and come across a couple interesting performance challenges. I do like this type of problem and have been quite busy working on the fixes for each one that has shown itself. This was one of the latest, requiring a solid, positive relationship between the developer and the DBA to solve- The DBA may have the answer, but the developer must be comfortable with the solution and make the code/design change that is required to correct the issue. I do work with…
-
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…
-
As part of an 11g Upgrade, it was found that a database environment could be built from one of the upgraded databases through a duplicate. As this process had never been performed before in this fashion, a test was in order. The test was an excellent chance to discover that the OSUser that performs the duplicate process was the proud owner of a .kshrc file with hard coded Oracle variables set which was an excellent choice if you want to really screw up a new duplicate database… 🙂 Scenario: 1. Duplicate has started with correct variables set. 2. Subsequent shell…
-
As many know I’ve been busy trying to bring our many-times patched 10g Enterprise Manager migrated to a new server with EM12c. I thought it would be interesting to see how fast I could break it, considering my skills, I knew it might not be a challenge. Scenario 1. Bug with listener refusing to connect dynamically to EM12c repository database. 2. After releasing code to the database for advanced notification, the SYSMAN.MGMT_ADMIN_DATA package has gone invalid, which is used to manage much of the repository at the command line. 3. The repository owner password has become corrupted. These were my…
-
I had worked hard on a report, 47 SQL statements in all to tune it down from 5 hrs to under 30 minutes. The first runs had been quite successful, so when a third run sent an alert on temp usage, I knew something was wrong. SID PROCESS MACHINE SQL_TEXT SQL_ID TOTAL MB -------- ------------ -------------------- --------------------- 507 1137 HOST SELECT *** 7t3muww36xhzn 45516 600 1139 HOST SELECT *** 7t3muww36xhzn 45516 525 1132 HOST SELECT *** 7t3muww36xhzn 45516 509 1135 HOST SELECT *** 7t3muww36xhzn 45516 I checked the stats first, as one of the fixes was to ensure the staging…
-
Oracle Open World is over for me now, but what a great event it was. I met so many people and actually was able to spend a little time getting to know a few of them. I attended parties, dinners and meetups. I networked myself, my company and RMOUG. It was a phenomenal turn out, even with a few folks missing that I knew we’d miss terribly Arriving- California Zephyr If you hadn’t heard, we decided to take a train from Denver, CO to San Francisco, CA. via Amtrak, called the California Zephyr. This was a 33 hour train ride,…
-
Yes, typing on my tablet screen again, so patience with my short posts…:-) Had the pleasure of attending both the ACE and Oak table dinners the last two nights. Wonderful, impressive and technically gifted people at every table and a fantastic opportunity to meet so many that I’ve only known virtually. I enjoyed another set of high energy conversations with Gwen Shapira, Debra Lilley, Robyn Sands and Lisa Dobsen- all women who make me proud of the representatives of my gender in the technical world. Spent sometime with Mark Bobak, Kent G., Alex G., Craig S., Jeremy Schneider, Mike Swing…
-
After a long first day and a 33 hr train ride in, I’m ready for a fun and enjoyable Ace dinner that I’m a lucky guest to. First day, being Sunday, is commonly quiet, but Tim had two sessions that I wanted to attend and time flew by with meetups, expert panels, etc. I met a number of great new people today and saw some more old friends, (or as “new blood”, can I refer to them as old?) I was still recovering after a fantastic get-together at Graham Woods from lastnight. I was impressed with the great group of…
-
Rarely are reports based off large snapshot variances helpful to a DBA unless you come across an odd situation such as this one…Better yet, we need to know a little bit about our AWR tables behind our reports so we can piece together what the reports leave out…:) Scenario: After-hours support has killed a session after high temp usage has occurred. You, as the primary DBA, are left to look into the issue the next day. Your first attempt to inspect the issue is through Enterprise Manager, (OEM) and you are surprised that very little activity is actually showing up…
-
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…