This package completely passed me by until it was mentioned in Dan Hotka’s presentation (Tuning SQL When You Cannot Change the Code) at OpenWorld. I ad a play with it and this was the result.
DBMS_ADVANCED_REWRITE in Oracle 10g
Cheers
Tim…
Oracle related rants (and lots of off-topic stuff)…
This package completely passed me by until it was mentioned in Dan Hotka’s presentation (Tuning SQL When You Cannot Change the Code) at OpenWorld. I ad a play with it and this was the result.
DBMS_ADVANCED_REWRITE in Oracle 10g
Cheers
Tim…
I feel like Edward Norton at the start of Fight Club. The bit where he’s living in a sleepless limbo. On Monday I got to work 2 hours late. Yesterday I was 4 hours late. Today, I got in on time, but I only got 2 hours sleep so I’m next-to-useless. I feel physically sick and my chest feels really heavy.
Last night I tried an over-the-counter sleeping remedy and some booze. Neither worked!
On the positive side, I got my copies of my PL/SQL Tuning book this morning.
Cheers
Tim…
Fedora Core 6 (FC6) was released while I was away at OpenWorld, so I thought I better update my draft installation documents:
Cheers
Tim…
Here goes…
“Making the Most of PL/SQL Error Management Features” by Steven Feuerstein – This presentation covered a number of aspects of error trapping available in PL/SQL, including new features in 10g and overall methodology. It was pitched more for beginners and those new to 10g, so there wasn’t a great deal for me. I guessed this from the title, but this was the only Steven Feuerstien presentation I could get to and I really wanted to hear him speak. He’s a great presenter and comes across as a really relaxed and “low temperature” guy. I hope in the future I’ll get to hear him speak on something a little more meaty.
“Sifting Through the ASHes: Advanced Database Performance Tuning Using Active Session History” by Graham Wood – Here we got an overview of how ASH works and what information you can get from it. Essentially, it’s pitched as filling the gap between AWR and SQL_TRACE. The line of argument goes, AWR isn’t realtime and SQL_TRACE is too expensive to have running for all sessions all the time. ASH doesn’t give you as much information as SQL_TRACE, but it’s running all the time, so you get realtime sampling not available from AWR. Pretty good for looking at current problems!
“Welcome to My Nightmare: The Common Performance Errors in Oracle Databases” by Michael Ault – Mike listed some of the major problems he has seen over the last few years of consulting and discussed possible solutions to them. Lots of the people near me were writing furiously, so I guess it went down well.
“Tuning SQL When You Cannot Change the Code” by Dan Hotka – Dan started at a furious pace, banging through lists of ways to affect execution plans for packaged or third party applications. Some of it was pretty obvious, some of it not so obvious. About half way through the hour slot he reached the end of his presentation, then it became apparent he had got the times mixed up and believed he only had 30 minutes. At this point the reason for the furious pace became obvious.
“Dell IT: Get Beyond Oracle Real Application Clusters and Start Deploying an Enterprise Grid Architecture” by Logan McLeod and Kirk McGowan – I advise people to look at some of the figures in this paper. These guys have a serious amount of servers and Oracle power. It makes most of our RAC look like hobby systems. I wish I had got to the technical session on this earlier in the week. Apparently they’ve automated RAC setup to the point where they can install and configure a whole RAC in approximately 30 minutes from booting the hardware to completion. Wild!
I got talking to a guy called Rick at the end of the last session and I ended up chatting to him during the whole of the two hour “It’s a Wrap!” party. He was making notes using Mind Mapper Pro, which I’ve seen before, but never used. We started talking about that, which turned into a general chat about writing, then I mentioned my website and finally we both went into full geek mode. Very cool! 🙂 It’s been really fun meeting and talking to all the people at the conference.
So now it’s over. I’ll probably write a Wrap-Up blog entry in a few days, once it’s all sunk in. So that’s goodbye to OpenWorld, but I still have a few more days in the USA!
Cheers
Tim…
I didn’t get to update the blog yesterday because I had a little bit of an issue with my hosting provider. The site seems OK now, so sorry for any inconvenience it caused… 🙁
As mentioned previously, I didn’t get to see too many presentations in the first two days because of the “Ask the Experts” panel and “Meet and Greet” presentations, so I was determined to do as much as possible on Wednesday, so here’s what I went to see…
“Recent Enhancements in Oracle’s Cost Basede Optimizer” by Jonathan Lewis – Over the years I’ve read quite a bit of Jonathan’s stuff and it has become obvious to me that my brain is too small and squishy to think on that level for too long. Sometimes I read his stuff and think, “I rubbish and I’m going to give up!” With that in mind, I was a little nervous about this presentation, thinking it may confound me to the point of making me quit Oracle. Fortunately, he dummed it down to mortal-level and an went away thinking, “Cool! I know what I’m doing.” Nice one Jonathan! 🙂
“Oracle Real Application Clusters: Scale Up or Scale Out” by Erik Peterson & Lan Shao – I’ve been using RAC for quite some time and I’ve seen my share of issues, so I was interested to see some comparisons between single large nodes and many small nodes. The presentation was very “big picture”, so it didn’t contain much raw data, but it seems that scale out (lots of small nodes) gives much better performance than scale up (one node). By the presenters own admission, some of the performance comparisons were very surprising. If you are thinking about RAC, it might be worth taking a look at this overview to get a feel for the configurations you might want to consider. You have to remember, these performance benchmarks were specific for the China Lottery, high numbers of small OLTP transactions, so you can’t assume hybrid or warehouse systems will respond the same way. Interesting stuff though!
“Recent Advances in Automatic SQL” by Jonathan Lewis – Once again, I didn’t walk away feeling like a rank amateur, so thanks Jonathan! This was a quick run through a number of the automatic SQL tuning features in 9i and 10g. It’s well worth checking out this paper if you are new to the automatic SQL tuning features because it will help you avoid a number of common mistakes people make when using these features.
“Tuning Oracle9i and Oracle Database 10g with Statspack and Oracle AWR Report” by Rich Niemiec – This presentation contained about 130 slides, most of which had numerous subsections. As a result, it felt like 500 slides in 60 minutes and I’m sure this confused this hell out of the newbies in the crowd. That said, Rich is a funny and interesting presenter. A little time was spent discussing the use of hit ratios for tuning, which you don’t hear a lot of these days. His attitude was, variations in hit ratios can give an indication that something has changed in the system, not that specific values of the ratios mean good or bad performance.
I also spent a lot of time at the trade stands speaking to techies, rather than sales staff. You can get some very useful real-world information from some of these people, and it’s not all biased in favour of their products.
It was a really busy and ejoyable day, but by the time I got back to the hotel I was too tired to go out again, so I just went to bed. 🙂
Cheers
Tim…
I already posted to say this mornings “Meet and Greet” went really well. This afternoons was even busier! All the seats were full and there were people standing at the back watching my presentation on PL/SQL tuning. I was extremely surprised by the turnout considering it was a trade stand. Over the last two days I gave away about 60 books, so there are plenty of people going home with heavier suitcases. It was a really cool experience and I got some great feedback from the people I spoke to. I can see how this public speaking thing could get very addictive! 🙂
This afternoon I went to a presentation called, “What Every DBA Must Know About Grid Control”. As the name suggests, it was a quick run through everything you can do with OEM Grid Control, so there wasn’t really much new information for me. The main reason I went was because Julian Dontcheff from Nokia was one of the speakers. I first met (on the net) Julian a few years ago when we were discussing Oracle 9i OCP beta exam on DBASupport.com, but I’ve not heard much about him since he moved to Nokia. I now know why. He’s part of a six-person team managing approximately 500 databases on versions varying from 8i to 10g. He’s a bit too busy to be frequenting forums these days. It was really cool to meet up with him in person after all these years!
I’ve got the bloggers bash tonight, which coincides with the big OpenWorld party. So I’m going to miss out on seeing Elton John perform live to spend the evening with a load of Oracle geeks. That just goes to show how geeky I truely am. 🙂
Cheers
Tim…
Update: I went and met the guys as the blogger drink. It’s always good to meet up with other like-minded people. A few of us then went on to the OpenWorld party. We were lucky, as we got there just before the doors to the Elton John show were closed. I’m not a fan but I was hoping to hear “Yellow Brick Road” and “Rocketman”, which I did. 🙂
This session by Leng Leng Tan was very interesting, listing all the new self-managing features of the next release (codenamed 11g). These features include…
Change Management:
Fault Management:
Performance and Resource Management:
So in summary, the performance and resource management is very much and evolution of the 10g automatic management features, but the change and fault management is completely new in 11g. Exciting stuff!
Cheers
Tim…
This mornings “Meet and Greet” went really well. I must have given away about 20 books and was asked to sign most of them. That’s my 15 minutes of fame, well 30 minutes I guess. I think people are a little surprised to see you present some technical information at an exhibition stand, rather than a sales pitch. More information to come!
Cheers
Tim…
I was totally stitched up in the “Meet the Experts” session with Tom Kyte. Tom got the times mixed up and arrived a little late, so I spent the first few minutes taking questions from a bunch of people who really came to see Tom. I was a bit nervous, but anyone who knows me knows I can talk the hind legs off a donkey, so I managed OK. Of course, when Tom turned up I didn’t manage to get a word in edge-ways. 🙂
It’s really interesting hearing Tom answer questions. He doesn’t just answer a question, he does a complete brain dump on the subject. It’s very impressive to witness. Certainly something to aspire to.
Later on I did a “meet and greet” at the Texas Memory Systems stand. This involved a 15-20 minute presentation on PL/SQL tuning and then just chatting to people and signing books. It’s quite wierd doing this sort of thing because you essentially have to start presenting before people will sit down. I started presenting to 1 person, but as soon as I started talking other people came and sat down. It was good fun. I’ve got two more of these today (11:00 and 16:00), then that’s my official duties over for the week.
I attended the a session by John Kanagaraj called, “Using ADDM, AWR, ASH, and Database Metrics with Oracle9i and Oracle8i Database”. His company manages lots of 8i and 9i databases, so he has looked at some of the monitoring features in 10g and “backported” bits of them to 8i and 9i. Some of the ideas were quite neat. It’s certainly worth taking a look at his paper if you are using older releases of the database.
In the evening I went out to the Oracle Technology Network party. There was food, drinks, a quiz show, dancers, contortion artists and some artificial camels. What more could a guy want?
While I was there I bumped into John Scott. We had a bit of a chat about being new ACEs. Nice guy!
Cheers
Tim…
Day 1. OK, so it’s not really day one for me, but you get the idea. What’s my mission I hear you ask? I’m going to try and get through the rest of OpenWorld without getting any more photos taken of me. Tom Kyte already got a snap of me at dinner last night, and I think Eddie Awad has one of me also. From now on I’m in stealth mode!
I managed to do a Helicopter tour of the city yesterday. It went all round the city, over and under Golden Gate Bridge and over Alcatraz and around the coast. Pretty cool!
I’m on a “Meet the experts” panel with Tom Kyte in about 1 hour. If he gets out his camera he’s history! 🙂
Cheers
Tim…