Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

MOTS Mini – Oracle ASM 11g, The Evolution

image

Currently “following” (yeah I know Alex I am also writing the mini post) Alex Gorbachev’s “Oracle ASM 11g – The Evolution” presentation, discussing, talking about ASM overview over the years, methods involved and the ins and outs you should or shouldn’t use Oracle ASM 11g for. Not sure if he will also do this presentation during Oracle Open World, but if you need more info about it, not yet (really?) sure if or why you should implement it, this is one to go to (as said, if Alex is presenting this one during OOW as well). Currently watching very nice slides regarding ASM striping and rebalancing data.

MOTS Mini – The (partial) lineup


Click on the picture to enlarge

Probably I forget people, but Gwen Shapiro isn’t on this picture or Graham Wood, therefore the mentioning by me of “partial” lineup. As you can see, although there is still a half day to go, this was an impressive gathering of experienced speakers… If you weren’t. Yep. You have missed out.

MOTS Mini – Database Deathmatch: Oracle vs SQL Server

image

So actually enjoying now some presentations of my own. Riyaj Shamsudeen did good on his “Advanced RAC Troubleshooting” presentation and now I am enjoying Jeremy Wilton’s “Database Deathmatch: Oracle vs SQL Server”.

A presentation about “breaking things”, mainly as Jeremy explained, because he was asked, more then once, to please go back to presentations that demo stuff more (and/or break it). Jeremy (biased regarding Oracle) wanted to do some more SQL Server stuff, just so he knew more about this SQL Server database and because he hates “not knowing” things. So this presentation was born. He is/was demo-ing stuff (Oracle and SQL Server) straight from the Amazon Cloud, trying to simulate both environments to be strain under load, the same amount (or at least hoping to do a honest comparison).

image

It was indeed a funny presentation (and insight full), were Jeremy explained the internal workings of SQL Server and Oracle regarding transaction logging, explicitly corrupting blocks/logs, for fun of course, switching those corrupted logs/blocks from Oracle to SQL Server and vice versa, see what happens, how those databases cope with such corrupted blocks and demonstrating both databases under strain. I really like it. Its a fun way to discover things and learn about them. But then again, its always fun to just break things right?

MOTS Mini – Almost weekend (and then of towards OOW)

image

The “disadvantage” of presenting is that you can’t relax until the last presentation has been done. As some one once said to me, you will have to do your best because those people attending have paid top dollar to be there were they maybe should be working on customer issues getting things along. I try to keep doing my best in this perspective, so (Doug!) no party for me last night because my last presentation (that is today) was already on 09.00 AM so…

image

I picked up my so needed coffee infusion at 08:00 AM and to my surprise I was the first one in the hallway, in front of the conference rooms, were also a nice table was put up with drinks, coffee and breakfast.

Anyway, got three enthusiasts, brave guys attending at my presentation, although it was so early. Chapeau (“hat off”/”I salute you”)!

image

I ran overtime (again – damn me), as said before, nowadays I have more to tell than would fit in a 1 hour presentation. I really have to work on this. I think, hope, I did my best, and those (early up) people enjoyed it. Now I can relax and enjoy some presentations until next Wednesday when I have the 3rd presentation within a week on Oracle Open World, San Francisco. If you read this and are interested in seeing some demo’s and are attending OOW, then maybe you want to attend to my presentation. There is still some room.

Its time to listen in on Riyaj Shamsudeen‘s “Advanced RAC Troubleshooting” presentation.

OpenWorld 2010: ACE Director Meeting – Day 1

Yesterday started by me waking up at silly o’clock. The joys of international travel. At least I can see on twitter that I’m not alone. :)

ACE Director Meeting – Day 1

Since we are not allowed to talk about the content of the meeting, I’m only going to mention the opening talk by Thomas Kurian who gave an overview of the big announcements at OpenWorld this year.

Now you people out there know how cynical I am at times and how underwhelmed I’ve been about some of the previous years big announcements. Well this year I’m blown away. I’m genuinely excited about the events this year. I’ve read some of the press speculation and quite frankly they have all underestimated this years OpenWorld by several orders of magnitude. The press are going to be hit by a barrage of new stuff right across the company. I defy anyone who truly understands enterprise computing to not be impressed by the breadth and scale of the announcements this year.

The thing I liked most about Thomas Kurian’s talk was the passion he delivered it with. I’m not talking about that crazy Ballmer on crack football coach fake crap. I’m talking real passion for the products and the direction of the company.

From my own perspective, I think Oracle taking over Sun was the best thing that could ever have happened to Sun. I know a lot of the Sun fanboys would disagree, but let’s be real. Sun was terminally ill. They had lots of good people, lots of good technology, but were incapable of giving it any direction at all. They were a mess. The only way they were going to survive was by getting some vision. Enter uncle Larry. I must admit to not understanding Oracle’s motives for the Sun deal, but this year it’s all starting to make sense to me. I look forward to seeing the press frenzy.

The evening was quite sedate. Just some food in the bar then bed. I woke up again at silly o’clock this morning. Once again, lots of ACEDs on twitter obviously suffering the same timezone issues. The early rise allowed me to get myself up to date and do some Yoga, which was great after a day of travelling and a day of sitting in meetings.

The downside of doing Yoga in a hotel room is they tend to have a lot of mirrors. In my head I know I look like Brad Pitt in Fight Club, but there was this fat, hairy guy staring back at me in various contorted positions. Quite off putting. :)

Next stop, round 2 of the ACE Directors meeting…

Cheers

Tim…

MOTS Mini – No time to waste…

So after this fun “Moans The Magnificent” special guest appearance, straight off to my hotel room to prepare my demo session about interfacing via XMLDB functionality. I wasn’t happy with those “old” demo’s so started to fiddle around, dropped half of them and created 2 more complete one’s which made a bit more sense regarding being a coherent “use-case” instead of the old demo “just a SQL statement”. Maybe not the smartest to do, being only 2 hours before my session. I got really bit stressed when I pressed on “shutdown” instead of “hibernate”, while finishing up, 30 minutes before my presentation started. Of course at that moment those brilliant Windows wizards kicked in an showed a desktop with the remark “Installing 1 of 7 updates”. It felled like those updates took ages… With only 10 minutes to go, I rushed down, but luckily for me Joze Senegacnik was busy with a great presentation and hadn’t finished in time, plus there were a lot of questions from his audience.

image

Despite Riyaj Shamsudeen and Cary Millsap, with his great presentation “Thinking Clearly About Performance” (part 1 of 2), I had after a minute of 5 in my presentation slot, even some 10 up to 15 people in the audience, which honestly, wouldn’t have expected to attend, at least not in those numbers. I had already settled in my mind with a “explain me your problem and I will demonstrate” kind of alternative (also cool) presentation / demo’s. Having around 15 people in the room I had to follow some of the lines I had set out for this presentation. I will give this presentation as well during OOW on Wednesday and although I had cut those demo’s in half; I again run out of time. I guess I have nowadays to much to tell plus I got some good questions from the audience on which I elaborated with some extra info.

image

Afterward the last session I attended the reception with some appetizers and beverages. I had some good talks and / or listened in on interesting discussions from Kyle Hailey, Jeremy Wilton, Gwen Shapira, Daniel Fink and others. Most of them were performance related which makes such an event like MOTS different than the standard conferences out there. There is to much techie passion around to not discuss such like database administration, performance or other (Oracle) database issues. After the reception we all/most of us,  went up to Carol Dacko’s hotel room to have a sip or two on those woody whiskey’s that were standing there or just some juice or beers… Didn’t make it that long though. At 20:00 hours the Central European Timezone was (still) kicking in and with a nice warm whiskey stomach feeling I went of to my room… Tomorrow at 09:00 hours my second presentation and then I can enjoy those last bits, 5 presentations I can choose from. Burdens of presenting. You will have to skip / balance stuff…but at least I have only heard good, really enthusiastic response from people that were attending. So that makes it worth while, despite having to sacrifice a few presentations or two yourself…

Oracle OpenWorld Session Updates (In The Flesh ?)

Based on emails I’ve received, I know a number of you are keen to attend some of my sessions at Oracle OpenWorld this year so a few updates for your information. I’ll keep this blog entry as up to date as I can with the latest information as it comes to hand, so keep checking back [...]

Another Tim Hall…

A long time ago, in a galaxy far, far away I got an email from a guy called Tim Hall who had started working at Oracle and was getting emails he wasn’t expecting. The reason for his problem was people were firing emails to him, thinking I was an Oracle employee.

Tim Hall (from Oracle) was presenting today at the Oracle ACE Director meeting, so I got to meet him for the first time. :)

Just to clear up any confusion, if you have questions about AIA, you definitely need to contact the Tim Hall from Oracle, not me. If on the other hand you are trying to get hold of me to talk about DBA and PL/SQL stuff, writing to an “oracle.com” email address is not going to get you where you want to go. :)

Cheers

Tim…

Oracle Open World 2010… Optimizing Oracle Databases on Sun SPARC Enterprise M-Series Servers

This year at OOW I will be co-presenting on Oracle performance on Sun servers. Stop by and say hi if you get a chance.

ID#: S315915
Title: Optimizing Oracle Databases on Sun SPARC Enterprise M-Series Servers
Track: Sun SPARC Servers
Date: 20-SEP-10
Time: 12:30 – 13:30
Venue: Moscone South
Room: Rm 270

Filed under: Oracle Tagged: OOW, OOW2010, Oracle, performance, sparc, Sun

In-Memory Parallel QueryのテストをするとCPUビジーになるけど、、、

In-Memory Parallel Queryセッション数 のときのリソースモニターを見ると、セッション数を増やしていくとCPUは100%ビジーとなった。
でもIn-Memory PQはCPU dpend? ではParallel Queryの方が実はCPU合計時間が多いと書いた。
Parallel Queryはdirect path readのビジーによりCPUが回らないだけで、合計のCPU時間はIn-Memory PQより多い。

Heavy SQLの比較 で取得したTPC-HのTop5 SQLのCPU時間を比較してみる。
比較は、前回のV_$mystatからの統計情報を使用した。値はCPU時間(カッコ内)はDB時間

SQL# In-Memory PQ Paralle Query
1 414 (794) 433 (1379)
2 418 (943) 449 (1347)
3 140 (357) 166 (837)
4 548 (1160) 566 (1432)
5 219 (508) 246 (855)

確かに、Parallel Queryの方がCPU時間が多い。
でも、これは全てがbuffer cache上に収まっているからだ。ということが前回のテストで分かった。
buffer cacheにデータがないと:

SQL# In-Memory PQ Paralle Query
1 553 (1488) 433 (1379)
2 514 (1793) 449 (1347)
3 247 (1113) 166 (837)
4 567 (1790) 566 (1432)
5 307 (1195) 246 (855)

>「buffer cacheにデータがないと」... In-Memory PQは実行できない。上記との整合性のためIn-Memory PQと記した。
In-Memory Parallel Queryはbuffer cacheにscattered readでデータを読み込むのでCPUも多く使う。
だからIn-Memory Parallel Queryはセッションレベルで意識して使うべき。と思う。