Feb 20 2012

RMOUG 2012 Presentation Slides!

Category: DBA Life,OracleKellyn Pot'Vin @ 6:53 pm

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 to chat!

EM12C
Sherlock Holmes for DBA’s

~Kellyn


Jan 04 2012

RMOUG 2012!

Category: DBA Life,OracleKellyn Pot'Vin @ 3:01 pm

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, the Training Days Director for the 2012 event has done a bang-up job with planning and none of us could get along without the continued support from those, such as Peggy King and Team YCC.

Oracle folks who do attend are going to be treated to a keynote from one of my favorite DBA Gods, Cary Millsap, along with presentations from some of the greats in the DBA world, including Jonathan Lewis, Debra Lilley, Mark Farnham, John King, Alex Gorbachev, Guy Harrison, Dan Morgan,  Marco Gralike, James Morle and Graham Woods.  We also can’t forget the local favorites, like Tim Gorman and Randy Cunningham.

Upon quick count, I realized we have 14 Oracle ACE’s and 14 ACE Directors speaking this year.  With all these ACE folks, we’ve decided to create a special event with them, something to really find out what it means to be an Oracle ACE.  Stay tuned, it’s shaping up to be an awesome session.

We also have the benefit for those interested in Oracle RAC of having “RAC Attack”, a great workshop, first offered at Oracle Open World and UKOUG, now also offered at RMOUG Training Days for 2012!  This is a great opportunity to get your “RAC on” and learn from some of the best on how to properly build a RAC environment and when.  Pythian and Apress will be sharing in the sponsorship of this great workshop at the RMOUG training days event. Show up with a laptop that meets the requirements for the workshop and build your own, how great is that?

That’s a pretty impressive count for a two day Oracle conference when you think of it!  I’m thrilled with the quality on the content of the presentations this year and how the event is coming together.  We had a record year for abstract submissions and it was a difficult decision deciding who would be in the schedule, so many great, solid abstracts submitted!

So if you are interested in attending, here’s the link to RMOUG’s Training Days Event.  You can view the current schedule, registration and biographies for the speakers.  There’s only a short time left to take advantage of the advance registration rate, saving even more if you become a member, (that’s me as the membership director just selling it a bit! :) )

http://www.teamycc.com/RMOUG_2012_Conference/Registration.html


Dec 21 2011

Presenting at KScope 2012!

Category: DBA LifeKellyn Pot'Vin @ 12:34 pm


Dec 20 2011

It’s an RMOUG Christmas!

Category: DBA LifeKellyn Pot'Vin @ 10:25 am


Oct 09 2011

Oracle Open World 2011 Followup

Category: DBA LifeKellyn @ 8:51 pm

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, slowly trekking at times, racing traffic at others, through beautiful scenery, all from a second floor sleeper car.  We had lovely meals with folks in the dinner lounge car and visited with others on the observation deck, (specialized car with a glass, domed ceiling.

Upon our arrival in San Fran, we quickly rented a car and headed up to a lovely party at Oracle’s one and only, Graham Woods.  I quickly found Gwen Shapira, (we’ve been trying to meet for awhile now, so was glad to FINALLY have the opportunity met…) caught up with Alex Gorbachev and teased by Cary Millsap about our challenges with understanding that we needed to PAY for our bottle of wine on the train and that it was not included in the price of the meal, (glad they couldn’t figure out how to pronounce my name over the intercom, but quickly figured out that it was me and my wonderful companion they were looking for-  his name is not so difficult to pronounce!)

Debra Lilley arrived soon into the party and many found fun as she brought me from room to room in search of those she wanted to introduce me to.  I’m to ensure she has a great birthday at February’s RMOUG, so it’s important she and I bond, ya know… :)

I ended up with a lovely embarassing situation upon being introduced to “Greg Brown” who I had to ask repeatedly where I knew him from, which he found quite hilarious, considering our emails until it hit me I was speaking to “Greg Rahn”.  He was a good sport about my lack of IQ after the long trip and I appreciate his patience.

Sunday, OOW11

The first day consisted of me attending a few of Tim Gorman’s sessions that I, as a VLDB DBA, had lived, but had never really sat through before.  I still picked up a few things from my first DBA God and yes, the Gods are good to me.  At his second session, Tim pointed out Andy Klock and I to each other, knowing we’d been tweeting back and forth about meeting up, so we sat together and it gave me an opportunity to physically meet one of the major clients I supported while at Pythian.  It was a pleasure to speak to her in person and glad to see someone not as indepth in the database world revel in the festivities and presentations of Oracle Open World.

Sunday evening was the ACE dinner and attendance was fantastic, (along with the food!)  It was easy to see why no one sat at any one table for very long and I did get to spend a good amount of time speaking with Mark Bobak, Kent Graziano, Doug Burns, James Morle, along with many others.

Monday, OOW11

I didn’t do to well on my schedule builder for Monday or Tuesday and if I go back over the actual schedule of sessions, I’m sure I’ll find a few that I should have gone to.  Monday night was the Oak Table dinner which was great fun.  We started out meeting up with Mike Swing and Craig Shalahammer for drinks before heading to the dinner.  Craig showed me some of his mathamatica graphics for buffers and latch visuals, (yes, his is one of those sessions I obviously missed adding to my schedule!)  We spoke about databases a bit, but the conversations regarding life were much more interesting.

Upon heading over to the Oak table dinner, there was a huge line of people waiting for taxis, but Mike Swing, Tim Gorman and I went up to the bellhop instead.  I’m not sure if it was Mike or Tim, but one of them asked if there was a better option and we had a personal SUV taking us to our dinner in just a few minutes for a few dollars more than a taxi would have cost, (note to future OOW attenders…screw the lines! :) )

As soon as we entered for the dinner, the gracious Carol Dacko ensured us our places and Mogens Norrsgard was busy entertaining everyone.  He and I quickly attained a quirky regard for each other and the jokes about Tim,  “I saw him first!” as the game of us challenging each other for Tim’s affections commenced.

I was seated next to Jeremy Schneider, who I thoroughly enjoyed conversing with.  He’s a brilliant young DBA, so his company, along with Gwen Shapira, Robyn Sands, Tim Gorman, Andy Klock, Rihaj Shamsudeen and Alex Gorbachev guaranteed a lively conversation.  This was also my first opportunity to meet up with Yury Velikanov from Pythian. I’ve only worked with him virtually, so this was a great chance considering he resides in Austrailia.  He is technically skilled, easy-going and quick to make friends-  a great representative for the Pythian name, like Gwen and Andy.

Tuesday, OOW11

Tuesday was the start for most of us feeling the heat from staying up to late and eliminating sleep from our diets.  My voice was starting to sound a bit horse at this point, so I’m sure folks were starting to wonder how well I had fought off my cold, (not very well in the colder, wetter weather of San Francisco…)  We met up with Ben Boise from Quest Software and spent a bit of time at the Enkitec booth.  The Enkitec booth was hands-down, the winner for me.  Kerry Osbourne had told me at Graham’s party, after I had finished teasing Frits Hoogland that he’d been given my copy of the Exadata book via Tanel, that if I came by, he’d have a copy for me.  Yeah, wasn’t turning that down… :)   So while there, spoke to Kerry about what a great DBA and all around good guy Karl Arao was.  He’s succeeding there and post the converation, asked Kerry and Randy Johnson to sign my copy of the book.  I went back a bit later to talk with Karl a bit more and for the fun of it, forced him to sign my copy, too.  Tanel had tweeted that he was going to have a secret Exadata hacking session that day, so I headed out with my book and was able to get Tanel’s signature, too…  No, none of you can have it… :)

On our way out of Moscone for the night, spent about 20 minutes speaking with Jonathan Lewis.  Dr. Steve Dorsey and a guest joined Tim Gorman, Jonathan and I to complete the conversation about the evenings plans.

We traveled down to The Stinking Rose for a wonderful dinner of wonderful dishes with way too much garlic in them.  I truly feared anyone who would come near us post the meal, but it was well worth it, (and apologies to anyone near us afterwards…)

Wednesday, OOW11

The day went quickly and the evening was the blogger meetup, there was a break between networking, dropping off postcards promoting RMOUG 2012, where we were able to head over to Mogen’s office, (i.e. back of Chevy’s restaurant this year…) where everyone had been hanging out throughout each day when needing a break from the chaos.  Throughout the day, there was some conversation via Twitter on who was going to get my wristband, as we were bowing out of the concert/chaos that night.  First it appeared that Greg Rahn would need it, but I had already pointed him towards Mike Swing who was offering him up one, so Doug Burns was the lucky winner and new owner of my band.  The group at Chevy’s, as always was fun to simply observe, let alone partake in conversation with and how can you say no to Mogens?

The meetup was a quick hop and a jump over to Jillian’s where there were a number of private parties going on, but the bloggers meetup by Pythian was the top deal.  We were all given a bandana and sharpies to get each other’s signature, which I was a happy blogger to just go around and meet as many as I could.  I enjoyed writing “Kellyn was here” and pointing arrows to the Pythian logo on the bandana or as everyone was wearing them on their heads, it had humor all in itself, (note to self, another reason I’m glad no one decided to wear the bandana as a bustier…)

Paul Vallee did a lovely tribute to Steve Jobs in the beginning of the meet up at the high time, Pythian first gave away an Apple TV to the blogger picked who had posts from the dates randomly chosen, (happened to be RMOUG Training Days week, so I didn’t even have to check, I KNEW I had posts out there.. LOL)  Yury won the TV and then they gave away an IPod Touch to the person who had received the most signatures.  I was sure I was no where near the top, but then got a look at the leader, Tim Hall’s bandana.  Upon counting mine up, I was two short of his number and he won, but Tim, the gracious guy he is, handed me the prize.  I, confused easily as I am, asked why I was getting it, I came in second and he replied, “I [worked] around to get my signatures and you just got them while meeting everyone, I’m disqualifying myself!”  Thank you, Tim Hall, from me and my children, who one in particular has been jonesing for one of these! :)

Post the meetup, Tim Gorman and I were going to head out for some dinner and Alex Gorbachev joined us at a wonderful Indian restaurant called Amber.  Wine and conversation flowed, while the fun and chaos of the Petty/Sting concert went on at Treasure Island.  When we did finally finish, it was just in time to meet everyone back over at the night’s bar of choice, “W”.  I sat and spoke most of the evening with Martin Paul Nash, Alex G. and Dan Norris, (Mogen’s slept in the corner, those Danes and their catnaps to catch up on jetlag really impresses me!)  Folks came in from the concert, Lisa Dobson, Connor McDonald, Andy Klock, Doug Burns and others, little by little.  We stayed and talked until my voice had become so hoarse that I was starting to sound a bit like Barry White.

Gotta say, another brilliant, easy-going and friendly DBA, Martin Paul Nash.  Between Martin, Andy, Jeremy, Connor and Dan, I’m feeling good about the future of our database administration world.

Thursday, OOW11

Surprise came the next morning when we found out many of the people we left the night before had never actually slept that night.  They continued to enjoy the opportunity to see folks that many may only see once a year and had simply stayed up!  A few of them were presenting on Thursday, so a lot of attendees may have wondered about that, too… :P

I attended only one session on Thursday, had slept in too late for the one I’d wanted to attend on optimal performance, (and had to answer to Gwen and others as to why I wasn’t there… :) )  Maria Colgan was great, (as usual) and she was one of the last folks I really wanted to meet, but had reserved the fact by the group that crowded her immediately after the presentation, that it just wasn’t going to happen.  Tim and I went over to Chevy’s to have a last OOW11 lunch with Mogens’ group before heading to the airport and who shows up to have lunch there, too?  Yes, Maria Colgan, so I did get to meet her…AND have lunch with her, (along with DBA Gods, Demi-Gods, you know the drill… :) )

During all of this, I did a lot of RMOUG networking to ensure that I added as much to the great plans for the 2012 conference that I could.  I was thrilled to have so many folks dedicated to coming out to Denver in February to talk, (because the conference is second to Debra Lilley’s birthday, I swear the marketing is there!)  Had a lovely conversation about bringing RAC Attack out for training days this year, which I think will be well received.  Jeremy Schneider is in Africa the week of the conference, but we are working on others who can really take on this great opportunity for DBA’s to take advantage of.

I wish I could say the plane ride back was relaxing and a wonderful time to reflect on a great Oracle Open World, but as usual, the airlines were busy trying to ruin travel for all of us.  I am thrilled with everyone I met while in San Francisco and although I should have attended more sessions, I wouldn’t have changed a thing.

Thank you Oracle, Pythian and all that I met this last week for such a wonderful experience!


Oct 04 2011

OOW11 Dinners

Category: DBA LifeKellyn Pot'Vin @ 12:27 pm

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 and Yuri Y.  I was also so thrilled to spend time with a virtual team member, Andy Klock- great guy to work with and happy to meet in person.  Carol Dacko did a phenomenal job planning the Oak Table event and I know Robyn Sands helped with some of the arrangements, too.  Mogens N. Is beyond entertaining and his legend is intact another year.  I threatened to stalk Tanel unless he signed my Exadata book, (thank you, thank you Kerry Osbourne for the copy…) and still am missing mentioning many others that should be named here.  All made an impact and were a pleasure to meet.

Food and spirits pale in comparison to the wonderful opportunity these dinners offer us all to sit and speak with the peers we admire so much…


Oct 04 2011

First Day at Oracle Open World

Category: DBA LifeKellyn Pot'Vin @ 12:05 pm

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 people inattendance.  DBA Gods like Tim Gorman, Alex Gorbachev, Cary Millsap, Kerry Osbourne and even demi-Gods like Frits Hoogland and Greg Rahn were there.  I met,(finally) so many others that have been on my list.


Sep 28 2011

Oracle Open World 2011, Prep Time!

Category: DBA Life,OracleKellyn Pot'Vin @ 8:52 pm

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 him, as the schedule is commonly kept from my home and not his during the week so finding a way to keep it from becoming too chaotic for him may not be feasible…

My preparation has included a few last minute tasks for RMOUG, which turned out to be pretty painless, so that wasn’t impacting.  I think one of my biggest challenges was a final rush to try and get what identification I needed sync’d with the correct name, as we all know, the government agencies are far from efficient when someone changes their name, no matter if it’s marriage or in may case, a divorce, (ask me how my identity crisis is going, considering how often I need to use a different last name depending on what company/agency I’m speaking with at any given time…sigh…)

Upon checking my calendar, it appears that I have a dinner to attend every night that we are in San Francisco.  The company for each of these events, of course, is wonderful- some of the folks I know and many I only know virtually and look forward to meeting for the first time.  I’m looking forward to the Pythian Blogger’s meetup on Wednesday night.  It’s a great opportunity to meet up with ex-coworkers and meet fellow bloggers-  always a fun, enterprising group!

I’m looking forward to meeting a long list of folks, including, Dan Norris, Lisa Dobson, Eddie Awad, Yuri Velikanov, many more folks than I can possibly list…) and those that I haven’t seen in quite a while, Alex Gorbachev, Cary Milsap, Deb Lilley, Carol Dacko and again, more than I can list… :) )

There will be many that were unable to make it this year, including a last minute cancel due to family needs by Chet Justice.  He will be missed by many and want to pass a long a thank you for my daughter Cait and I for the picture on oraclenerd.com.  We love our matching “DBA Goth Princess” T-shirts.  When asking my 16yr old son to take our picture, his response was, “You know Mom, there is this great feature called a self-timer found on cameras…”  I had to respond with “You know, there is this great feature called, I keep feeding you…”  He took a great picture of Cait and I for Chet’s site… :)

Packing will continue tonight,  along with more planning in the calendars, an attempt to get my tasks for the latest Agile sprint at work done and a hope that what clothes I pack will work the slightly different weather in San Francisco.  Yes, I’m bringing my cowboy boots… :)

See you there!

 


Sep 15 2011

Keep is Simple and Other Superman Challenges

Category: DBA LifeKellyn Pot'Vin @ 3:53 pm

“Oh what tangled web we weave when complexity is added we can’t see…”

How many times has complexity of design in an application, outside of the database, lead to the database blamed for slow performance?   This is where a manager thanks the technical Gods for a DBA with great Sherlock Holmes skills to track down and prove the database not only innocent, but figure out what the real problem is.  The database is guilty until proven innocent, we all know that, so when user’s come to the DBA and demands, “Why can’t I run this report?  I should be able to run a simple report, shouldn’t I?”  We have to take out the Holmes pipe and figure out what is going on.

My latest mystery landed me in a web, which would have been funny if not happening to me.  The exact demand from the users above was rightfully requested of the DBA group.  Being a good, responsible DBA,  we quickly took responsibility when we discovered a bug that was impacting stats collection with parallel degree set, provided a work around while the SR was being worked with MOS and proceeded forward to ensure the user received their report, ensuring business revenue.

As the trace is my first choice in this type of challenge, I attempted to trace the session numerous times, wanting to ensure I’d fixed the issue, along with a future goal of performance tuning, but found I was unable to pin it down and found that I was really seeing numerous sessions involved with this process, not just one to create the report.

The users, running the report to test my fix, experienced another failure with the following  error:  ” Failed to read the Report Stream from Report Server.”  Now this is a vague error and rarely one that *really* has to do with the Oracle database.  I could see the stats failure via initial data load logs but nothing really explained after removing this roadblock as to why the users were still experiencing failures.

As this report was kicked off through our web interface, supported by APEX, I went to the application support specialist for answers.   He appeared just as frustrated when he informed me that the report was actually called from APEX, but was phycially run from SSRS, (SQL Server Reporting Services.)  I promptly asked for the report and was dismayed to find out, depending on the parameters passed, it could contain anywhere from 24 to 50 database calls to complete the report.

What appeared to be one, simple, but slow report to the user, was actually a very large collection of queries, ran from a SQL Server Reporting Repository, submitted through an APEX web interface on a second server and then to the production database on a third.

Ahhh, but I’m not through yet.  I pulled the queries from the report, formatted them for a command line run and then passed in the parameters for the large feed that had been failing.  When I ran this from the command line, no failures occurred and I was able to trace everything for my future performance tuning.  I was surprised to see that there really wasn’t that much that was wrong with the SQL, only a few queries of the many that would require time and offer the biggest bang for the buck.   I then ran the report through the web interface hoping to find a way to trace it and my run through the web interface WAS SUCCESSFUL!  It also ran in 1/2 the time that it took for the version that reported in the logs that failed.   I already had the APEX and SSRS guys looking into anything on their side that might indicate a timeout or failure cause, but I still felt like we were missing something.

I approached the user and asked them where they were kicking the report off from and found out that they were executing it from a terminal server web session, not from their workstation’s web interface.  I quickly emailed the Windows Admin, who also administers the terminal servers and asked her if she was aware of any reporting session or terminal server timeout.  She  informed me that they disconnect any idle sessions after three hours.  As this session would show as idle, only submitting the report, but requiring a connection to be active for the remainder of the run, this was the actual issue.  Terminal server was dropping the session while it was attempting to complete a report that through it’s entire batch process across three servers, took almost five hours… :(

The users were then requested to run the report only from a workstation web interface.  The results were successful and the database was again innocent.

Moral of the story:  Complexity is the enemy of production processing.  As developers, application designers and DBA’s, it is often seen as proof to the world of our God-like creative powers.  This is where we also quickly move from being an asset to a liability to the business.  Do not create that which can not be easily supported and kept in the life-cycle of technology as technology grows and changes .  It is a fool-hardy endeavor that quickly costs the company money, time and nerves…  Want to be a superstar?  Stop being someone that to support his technical choices, requires a Superman effort…

 


Jul 19 2011

You Know You’re Doing Too Much Database Work When…

Category: DBA LifeKellyn Pot'Vin @ 9:38 am

This is when I know I’ve been doing too much database work in one day.  I awoke from a dream, quite early in the morning and was replaying it in my head.  The scenario went like this:

Scene:  City streets, obviously a murder scene with yellow tape drawn and bystanders watching off to the sides as the main characters, two seasoned detectives are discussing the decision to enter the crime scene.

Officer #1:  “Are we sure we covered our bases?  Is there anyway the criminal could have escaped the scene or we could have compromised the evidence when we entered the crime scene?”

Officer #2:  “Nope, positive we are in the clear-  I ran an ASH report before we did anything!”

Sigh… I need a vacation… :)


Next Page »