Live to Ride....

Agenda Update! Here is what I plan to do in the next two months...
(remind me to update the list to the right... I'm not very disciplined blogger these days - will try to prioritize soon...)

As some of you know, I plan to visit several OUG events by Motorbike. Start date is 24 May, leaving from Spa, B. And return on the 23rd to The Hague, back to work (if I'm still in one piece, if my customers will still have me, if my colleagues havnt filled my seats..)

Firstly, the Bike (I named her Beauty-Case, you can check why) the Bike gets a large maintenance and new tyres (rear tyre is in dire need, I ride it way too much...). After I break in the tyres, it is off to the East, leaving on 24th.

If it all works out, than this is approximately the proposed route (c/o Google maps, right-click to new tab to zoom):

Of course, I'm posting the map with a purpose: If you live along the route and fancy a coffee or light meal, drop me a line.

First destination is SrOUG, which runs from 28 to 30May:

Next is a trek north, through Hungaria, Slovakia, Poland, then the Via Baltica through Latvia and  Lithuania, on to Talinn in Estonia, where I have a Tallink ferry to catch for Helsinki.

OUGF happens at Haltia (google it!) on 05 and 06Jun.

After OUGF, which includes a night of Camping (Glamping, I hope), it is Ferry again to Tallin, and a trek south to Sandanski (that is surprisingly close to Greece, so yeah; South). Sandanski is where BGOUG takes place from 13 to 15Jun.

Proud to display this logo:

Then it is back to The Hague where, on 23Jun, I hope to take up residence in a new(ly rented) apartment with a nice View!

And back to work - the finance-chief of PDVBV (that is me!) will want me to fill the coffers after such a splash (and I might need a new rear tyre again).


BTW: Cross  fingers that the Internet connection at the apartment works by then. Imagine returning "home" after 9000km and no connectivity to brag about it...

PDVBV is alive....(and for hire!)

As some of you already know: I quit my "job" and started as an "indie".

I am now officially a mercenary: you can hire me.

The name of my new entity : PDVBV s.p.r.l/b.v.b.a.
The name is a reference towards my dutch-language heritage, the designation signify a belgian "Limited" company.

My aim is to look for jobs similar in content to what I did as a wage-slave: Part-time, advisory and troubleshooting jobs. I dont mind travel (on the contrary) and I would not want to be linked to a desk for 5 days permanently.
I'm lucky, my first customer-assignement is just what I wanted.

I'll update the blogs, my resume, Twitter, Linked-in, facebook etc... when time and usefulness permit (wanted to do that much earlier, but life is too short to mess with the internet all the time)
I may even start a PDVBV page somewhere.

Suffice to say : I should have done this much earlier.

The main reason to become indie is that I can now decide for my self where and how I can use the fruits of my labour. I notably dont have to tow party lines anymore (although...), and I can decide all by myself to plan/budget any visit to a conference or usergroup or any interesting gathering.
The straw that broke my camel's back: in-ability of previous employer to pay for a visit to the Scotland UKOUG event (or any other event for that matter).

I've taken back my freedom.

First trip: I intend to visit the AIM SIG of UKOUG in October. Look forward to meet some old friends there.

Given the development of my client-base, I already regret that I turned down invitations of SIOUG and HROUG. No worries: I'll make good next year, may even try to go by Motorbike - After all those years crossing the alps by car, I feel like riding a bike over those passes for a change.

Note: I currently ride a motorbike for Fun and necessity, but after handing in the company-cage, using a motorbike to commute to work feels quite liberating (at least for the summer).

(ps: I almost regret all the jokes I made about "urenzuigers", I risk becoming one of those myself).

OEM Oracle Enterprise manager graphs are great

The title says it all.

I am really coming round to Oracle Enterprise Manager, OEM, for use in monitoring and troubleshooting performance. I'm with Doug Burns here, who once did a presentation on how he learned to love pictures.

OEM is maturing
gradually
into a
great,
good,
and indispensible
tool.

I cannot express my appreciation for OEM enough.



Am
ai
below
the blog-aggregator
horizon
already?

---

*PdV peeks over the edge, then looks over shoulder - twice*

This will not get me credit with Vendors...

---

Oracle-OEM, Quest, and Symantec all have competing commercial products,
but today, I am plugging ... :

TORA.
And to a lesser extent, Lab128 (which is effectively free as well).

(If those two are old news to you, I apologize, just close the tab and go click elsewhere)

I will admit that the commercially licensed products are much better.
They are richer in functionality (feature bloat!) then any open-source, free-to-give Tool could hope to be (or are they?). I should also mention that the commercial products often will offer all the goodies, gizmos, spotlights and the key-hangers that my kids like so much. I would never pass up on the free parties, eh, salesevents Seminars with food and refreshments. In that area, commercially licensed product are unbeatable.

But for Sheer Simplicity, for Acutal "Value" I have used TORA for nearly 10 (ten!) years now. My trusty 1.3.8 version dates back to 2001. I always used the free version worked fine on oracle 8, 9 and 10. It still works on 11, and I'm sure that when an 11.2 "problem" pops up at one of our customers, that even the old 1.3.8 version will show my the wait-stats.

Since Quest (bless them, they are the makers of Toad), claimed to have bought TORA in eh... 2003, I had not checked for TORA updates.

But now Timo Raitalaakso (Rafu on OTN, blog can be found Here) from Finland told me TORA is still around.
Version 2.0.0 is available.

Go and check it out at sourceforge, and go find a few references on google...

Then download it and Test It (it is totally for free - Wayhey!). If TORA is right for you, you will become addicted quite easily.

My main reason for having TORA is the server-tuning screen called "wait-events". It offers a free, and quick-to-use alternative to the OEM waitevent graphic.

I can run TORA without need for permissions on OEM (acutally, without the OEM period), and it gives me roughly the same screen. All I need is "PERFSTAT" or any user with sufficient privs (the "advisor" role is fine). If I can run spreport or awrrpt, I can generally also run TORA.

It just takes a tns-entry, and Oracle-Net connection, and then TORA is up and running. Mine runs from my company-windhoze. But there are Linux and Mac builds too.

I combine TORA with some servertool sar, vmstat (unix), lparstat (AIX) or taskmgr (windhoze) and with statspack (AWR for the licensed-lucky).
With those tools, I have solved just about every performance-problem I was given.
(admittedly, my problems tend to be simple - but I'm waiting for the first SOA/SOAP system to overload).

Inside TORA, I run the "server tuning" screen at 10 sec interval (I only use the 3rd tab with the graph and the pie-chart of the wait-events). I tend to disable the other screens, not just to save on sqlnet traffic, but also to keep my windows-lappy running happy.



And Voila, that screen (which predates and resembles the OEM graph...) tells me what is happening right now, and in the last hour. In using it, I have a few dislikes and a wishlist too, but I'll keep that for another time.

Tip: I often configure 12 gridlines and 360 datapoints to have a 5 min grid on 1 hr of data.

I am still of the opinion that real DBA's use SQL*Plus, common sense, and not much more. But if you are into troubleshooting databases, you could do worse then look into these tools.

Catch the Wave

Got the invite, and I jumped in. I have actively tried to surf some googlewaves with a few friends, but I do get the feeling this is a case of Emperors Clothes sometime.

How many of you have actually stood on a surf-board or even windsurfed? Both are not easy - well not to clumsy impatient geeks like me. But once you "get it", the experience is Excellent!

How many realize that the perfect wave is something very ethereal. To be catched when it happens, and to never return. We all have our "perfect wave" moments, but I'm not sure if gee-wave is one of mine

The good thing of this new wave is to link up, again, with ppl I appreciate, and some I had nearly forgotten.
And the gadgets look mint to: cool voting widgets, maps, all sort of embedded content. And we havnt even seen the "wave" of applications that can be built with the API. If Facebook is anything to go by, wave has a huge Gee-Wizz potential.

But the down-side is that it seems to take much more time then plain email, skype-chat, yahoomessenger, msn, googlechat, whatever. And that live typing is relatively slow from most connections I have used so far. Any way I can turn that off?

Does anyone remember IRC or ICQ chat ?
Anyone used the the VMS and unix "phone" utility ?

And now we have facebook (mafia wars!), hyves, skyrocks (my 13yo has about 7 hompages there, for various purposes), LinkedIn, google-talk and twatter. And with Google Lattitude, several ppl (+ all of google) keep track of my whereabouts already.

Tomorrow we will be on gwave and lattitude (and a few more that only my kids know of).

A UKOUG Conference-promotional wave anyone ?

I'm only a Simple Oracle Dba, and I'll try not to be a Luddite.


Okokok, just got a txt msg asking if I could check a certain wave that mentions an email of about an hour ago...

Oracle Usergroup meetings - Tips

Last week was Perfect: I could escape the project-managers for all but Monday and spent the rest of the week "working" remotely, while visiting two usergroup-events.

I had the pleasure to attend the DBA-Day from Oracle Usergroup Holland (OGH), and the Autumn Seminar from Oracle Usergroup finland (OUGF). Both events were Very Well organized and had excellent content.

Being lazy, I do hope some other enthusiastic bloggers will do a writeup of the interesting items from each event. Today, I have another priority on this blog.

I hope all of the the attendees had an interesting and productive time. And I would encourage them to tell their managers how useful these meetings are.

If anyone has to justify their Usergroup-Fees or cost, I always like to make the point that these groups are the only way to get information that is not totally-tainted by pre-sales. At a usergroup, you can hear how it really works, rather then how it is supposed to work. The unbiased (ok: less biased) information combined with the staff-motivational aspect, are probably the best business-case.


Evaluation forms

I know most usergroups are trying very hard to please their audience, their members and their sponsors with ever-present "Evaluation Forms", and I do fill in my share of forms.

I would like a quiet word with that one person at UKOUG events who always fills in 100% minimal scores on my presentations. I can only presume he is linked some some vendor that lost business because of my "simple" crusade.

I know for a fact that at least some of my comments to UKOUG have been read, and considered. Thanks Aimee, Rachel and all the other members of staff.
Those forms are useful, and I forward all the good comments to my boss.


Tips

As a regular visitor and presentor at Usergroups in various countries, I have compiled my own list of preferences and what I consider best-practices.

Mind, this is not criticism, but rather praise and encouragement. I full well realize that it is much easier to criticize then to construct. And I do applaud the volunteers and staff who organize it all.


So, at the risk of ridicule, here goes...


- Handcuff speakers to the table.
Do not allow speakers to run in, rush-ppt, and run away from the event. No matter how "celebrity" they are, they should allow time to discuss and mix with the (paying) audience. Find some incentive to keep the speaker after his talk. Allow approachability and discussion.

- Clean out the speakerlounge regularly.
Discourage speakers from hiding in speakerlounges. See above. Usergroups are for users. The mixing and hobnobbing with higher celebrities can be done elsewhere.
And for speakers: the information you pick up from listening to in-the-field users is often invaluable. Get out there.

- Provide a safe cloakroom.
Especially for those who travel with luggage-trolleys, it is very convenient to have a safe spot. It is one less worry, and ppl dont lug around the additional coats and other items (also a firehazard).

- Use simple timings.
Plan the start/stop of sessions on whole-hour, half-hour or quarter-hour, please.
Simple timing is easier to keep. When a speaker is sweating in front of an audience he doesnt want to permanently do time-math. And users wandering around or smoking outside will easier remember simple timings as well.

I sometimes had to fit a 45min ppt (+/-22 slides + some demos) into a slot between 14:25 to 15:10. Running it from 14:30 to 15:15 is just easier (me - I like simplicity). I know that staggered breaks are better for services, staff, crowd-control and exhibition-sponsors. I understand that, but it doenst mean I like the funny timings.

- A visible clock.
A nice big clock on the wall, visible to both speaker and public is a great help. See above.

- Breaks between sessions.
Breaks should be 15-20 minutes, please. In between all sessions. Breaks are meant for discussing the topics, for networking, for coffee/ciggies and for phone-calls/mails. A whole morning sessions with no break (because the speakers want to run away?) is tiring, and doesnt allow to digest and discuss the material presented.

- Simple Refreshments at Every Break.
Preferably Coffee (strong), Tea(ditto), water (still) and biccies (optional) at all breaks. IT ppl like we are run on coffee (and some also run on ciggies [link to Doug?]). And a cup facilitates mixing and networking.

- Provide some (walking) space during breaks.
The venue should provide sufficient space to walk around and mix (with cup of coffee in hand). Networking and listening to peers is such a very important aspect! Additionally, some of the attendees will want to return phone-calls and will appreciate some space to hide and speak.

- Provide Free wifi - Please.
Possibly negociate vouchers with venue if the wifi is payable. A lot of us want to stay in touch, or even verify what the speakers say on tinternet.

- Practical Food.
The Quality of the lunch needs to be Acceptable, but the food should mainly be practical, and easy to consume while networking. Sandwiches are perfect, hot soup is a big risk. The sit-down lunch in "Slough" is very Good (a much appreciated classic at UKOUG). But if such quality is not on offer, then make sure the food can easily be consumed standing/walking. Balancing a hot plate plus a glass in a crowded space can be awkward.

- Facilitate shared transport after the event.
Ask publicly, around lunchtime, if anyone wants to share taxi to trainstation or airport. The RMOUG has set the golden standard for this, AFAIK.
But it is plain funny to command 5 taxis separately and form a convoy to the trainstation. And sometimes a gentle soul even offers a ride from Solihul all the way to London (Thanks Dave!).


That concludes my pedantic advice
(I'm a consultant after all - I always want to impose some unsolicited opinion).

If it helps anyone, then fine. If you think all of the above is totally obvious or ridiculous, then I apologize for wasting your time (you should have stopped reading earlier - consultants are there to be ignored, remember).

See you at some Usergroup maybe!

Oracle 11gR2 buzz and my "Thank You" to Oracle

re-Hi all, and nice to see everyone busy downloading/tweaking the 11gR2.

Must say I havnt really kept up with all the buzz, but when I looked at the new features I tried to be a-typical: I'll not go and sing praise to all the new complexities yet. I'm sure they are fine and wont cause serious trouble. They will come my way in due course.

My 11gR2 buzz ?
I'm on the lookout for the simple stuff that may just be of benefit to a large number of DBA grunts like me. For the moment, I will have to let someone else study the new intricacies of the upgraded root.sh script (Hi Martin, Jason!)

---

I have to fuss-up that the most high-tech "fixes" I did in the last year was around conventional locking (TX Enqueue, just app-logic, talk to the vendor), Dynamic-SQL (politely lean on the vendor of the app) tweaking CBO (and not even subtle, just applied some Tapio[link]) and the (system-)statistics. Most of my work didnt come close to proper rocket science, any of you could have done it. The bulk of my assignments seem to involve pushing people, rather then data-blocks. And my email-cc skills have greatly improved in the last months. Sigh.

---

Reading the "wotsnew", I still found several gems of simple (I hope) and possibly very usefull features.

There is at least one client that will be interested in "Instance Caging". The site that can benefit from this as the Developers have 100 small, but sometimes nasty databases running on a single machine with 24 CPUs. And sometimes they have an "oops" moment and one instance affects the whole (development) system. Reading up on "instance caging", it is dependent on Resource-manager. That sort of locks me in, I now Have to use this Resource manager malarky... (Guess I'm a Lazy Luddite at heart)

The IGNORE_ROW_ON_DUPKEY_INDEX may well be an instant hit. I will not be able to resist abuse of that one! The benefits are Obvious.
But... (there are at least two buts)
This new hint will lead to a lot of lazy-programmer-style stuff. Potentially as dangerous as the "whenever others" that Tom Kyte is sometimes on about.
And, on a more Friday-philosophical level [link to MWidlake], I dont like the fact that a Hint has an impact anywere but on the optimizer.
I can not stop Oracle from developing (useful!) stuff like this, but it puts "Hints" in a whole different part of the game. Food for thought there.

So let me politely say "Thank You" to Oracle for the new, simple, and easy-to-use(?) features. There are a few more ones, I will explore them further when time permits.

First got to do some prio stuff, such as booking trips and updating the Agenda [link]. Hope to see some of you in Real Life on a conference, a SIG, or a Gig somewhere.

Oracle CBO version 12 - secret preview

Tanel Poder has the scope on this.

He got his hands (and eyes, and brain) on something that seems to have escaped from an Oracle Lab.

Have a look.

Nice one Tanel!

compliments to metalink support

Metalink is a very positive experience.

My compliments to Oracle for their state-of-the-art 3rd generation pro-active Support system.

The good old metalink interface was Snappy and Fast and the new flash(?) interface is so clever it is just a doddle (albeit a bit obese, I do alway request for a mega-size hi-res screen, and a 3Ghz Dual-core machine, just in case).

You will notice that I cram in as much positive words as I possibly can, just to make it look like I really am a fantastic supporter of this excellent metalink support system. The search engine will love this. And may the gods of google and Redmond reward me with oodles of Good Karma, and lunches, and plane-tickets, for all this forward-facing and link-enhancing Feedback. if only I wasnt so lazy with links...


Anyway, the Rant...

Last week I had one of those refreshingly positive Metalink experiences.

An issue with "system statistics". The details are rather client/app specific, hence no further details (yet).

System_statistics?
You know, the stats that replace Multi-block-read-count and ind_cost_adjust_perc. The stats that tell the Cost-Based-Optimizer about the underlying hardware.

System stats are the stats that get stored in SYS.AUX_STATS$ with items like CPUSPEED, MBRC, SREADTIM and MXTHR (another great feat of engineering-in-progress, the CBO). For those of you who think I'm talking about stats on the SYS schema, or just the auto-gather job: Get the Book By Christian Antognini. He has what I think is a good explanation, and the Best Strategy (best practice, if you want management speak) for gathering system-stats.


OK, so we have an Issue with this gather_system_stats. And nor metalink nor google came up with a satisfactory answer. Even a phone-call to an ACE director didnt give me a resolve (but at least we agreed on possible approaches, Thx Anjo!)

So what is a consultant to do ? I reluctantly opened an SR...

After two polite and cheerful acknowledgements (Hi I'm Joe and I will help you.... Hi I'm Tom and I will help you....) but no answer whatsoever, the third "Support Analyst" had actually searched metalink and typed (pasted) some reply. Thank you.

His first reply was to read 10 or so notes on Metalink, all related to "object stats", e.g. gather_schema and gather_table stats. My colleages had already read all of those, and I had read most. I sacrificed my time on a double-check but our answer wasnt in there.

So I had to update the SR and politely point out that my question was about SYSTEM statistcs. The ones stored in SYS.AUX_STATS$, and gathered by dbms_stats.gather_SYSTEM_stats. The stats that represent the underlying hardware configuration.

Next reply from the analyst (more metalink searching on his part) was that the gathering of stats on the SYS schema was explained in ML notes Eeeeeeh.1, Grrrrr.1 and Zzzz.1... with some obviously sensible and MC (Metalink-Correct) caveats and version-dependency remarks.

I then Icey-Politely stated I did not want to offend him, but that I would really appreciate it if he read the question and my replies again, carefully. Please-pretty-please.

Maybe the question was not that trivial, after all. I had spent a full evening in an Ice-cold shopping centre with wifi trying to find the answer myself on both metalink and google.

One Weekend further, a support analyst called my mobile number. Relief. This person at least knew approximately what system-statistics were. And he called mainly to confirm and assure that he actually understood the question (Yay - Progress!). He Did understand the Issue. And the question. And he is now looking for an answer inside Oracle.

The secret of using the CBO is to not let it eat up your time and effort. And in writing this, the CBO just cost me another 30min of my life. My mistake.

Am I Positive about Metalink ?
You Bet !

That fact alone that someone now read and understood the question, and the actual effort he displayed to now find an answer is Refreshing. It restores my faith in online-support.

And metalink-alone justifies the flat-screen TV I've requested on my desk.

Irony anyone ?
(I never was good at jokes)

Planboard

Today's image is a plan board. This is of course to promote the Planboard DBA symposium. A relatively small-scale, Dutch event by "planboard". The small scale of the event makes for excellent knowledge transfer (I expect many questions that I cannot answer...) and good networking.

Kuddos to Planboard for this initiative, and my gratitude to those who have convinced their budget-holders that these events are Valuable. Believe me, they are! And they are cheaper then training too.

It is something the UKOUG has noted as well. Small and targeted events, Special Interest Groups if you like, often are the most valuable meeting.
I'd be tempted to report on a discussion I had with two DBA's over lunch at the Scottisch DBMS SIG. They might just have solved a nagging listener-connection problem from a good discussion with Joel Goodman and a few others.

And that is the kind of value you get from SIGs and Symposia.

That is Ace indeed. Oracle Ace even.

The Brits, normally fairly cool folks, have a way of saying "That is ACE!" when they are enthusiastic or excited about something.


And I feel sufficiently proud of my new status to say that myself. (I'll do some screaming therapy form a hilltop in the Ardennes this weekend, and then I'll try to refrain from looking too smug next week...)

But at the same time, I realize I owe this to many friends, customers and co-workers.

I owe this to all the sparring partners I debated with over the years (Even Nigel!).

And I owe this to all the managers that benevolently signed off the expenses for trips and presentations (Thanks JP!).

I owe it to those who let me attend their events at a reduced rate (if I name them, they will get spammed?).

And I owe this to all the Project Managers and Architects that took responsability for my Mistakes and Blunders (FredP, MikeC, Geert, ChrisC, DavidH, IanS, PeterP, PeterG, ...). I have helped a few Nasty bugs to surface as well, notably in FBIs and IOTs... Not always to the joy of my customers. Customers expect the systems to work, rather then to score bugs that feature in powerpoints by Phil Davies.

Right.
And now I need to live up to the expectation.
I am doing 3 ppts in the coming week, one in York and two in Edinburgh. And my regular customer wants an in-house presentation on top of that.
Then there is Planboard Symposium on 26 May...

But First A good night sleep, and then Back to Work.

Thank You, that was ACE

Thank You, Anjo.

(Rush job blog, as I have a few other things on, writing from the BK in Metrocentre, with funny blockage of blogger-items ...)

Anjo-YAPP-Kolk doesnt really need introducing, and I am not going to link to
him again, for fear of over-doing the link-stuff (dont want jealous webmasters, do we?) and my boss is also looking...

But Anjo basically, on a rainy evening over one of those idea-bouncing
nerdy dinners, dropped the concept, wrote the introduction, and magically made me enter the ACE-arena...

And now he twitted the news prematurely and I got a few "Gratz" mails.

All I still need to do now is to sign over my life to Larry, sit still, behave respectably (Havnt bought a suit in ages...), and then I might be allowed to put various logos on my blogs and presentations. Maybe someone will someday finally READ all this... This writing stuff isnt really my thing, I prefer to stand up in front of customers or a usergroup-audience. More Fun, less spelling-errors).

Anyway. Awaiting the last results from the jury...

And my next blog ( at SimpleOracleDba.blogspot.com) will be semi-serious, about a select count(:x) stmnt, whereby x is...

Oracle Usergroup Scotland and Northern Server Day

Or, as now two different UKOUG representatives have stated: we dont mind if you mention our events on your blog.

Well, since a lot of the internet is indeed just "Search Engine Content", and since it is mainly about link-harvesting, here is some plug-text for the Events where I myself present.
speaking of links... I refuse to point out the site that most bugs me when I do googlies on "oracle" content. you all know there is a lot of obnoxious trivial stuff around, and I am quite ashamed to go into the game of search-enginge-link-farming myself. The name "dom" comes to mind [link to Ora600.be]. Kurt did a good job of making fun of it.

I am also green with envy those who can go and see Tanel in Europe, and even Jeremiah Wilton comes to holland this summer. But I will make the effort to first promote the following (nearly free) events:

First, there is the Northern Server Day of UKOUG on 28 April 2009.
To be held in the beautiful city of York.

After you have done the touristy-check (York is Beautiful!), please also check out the content of the Meeting (just follow the UKOUG logo...). There are two streams (you may have to choose) and topics are about disasters Recovery, flashback, exadata, and (hometown of Pete Finnigan... you guessed it... ) Security.

The Northern Server day is an excellent opportunity to mix with fellow-practicioners and exchange some relevant real-world (non-sales) experience. And York is easy to reach by train from just about anywhere in the North (or anywhere else, for that matter).


Secondly, The Scots, proud as ever, of course have their own OUG, and some blue color in the logo.

The Oracle User Group Scotland DBA SIG, will be held the next day, 29 April 2009, in "Embro". And again, you can meet peers with Real World Experience who use the same products and tools you do. Come and learn from eachother. Personally, I did have a problem convincing my management that I really should visit both, but I gave them a few strong-worded arguments, backed up with links to both events (hey, links and search-engines can be your friends indeed)

Hope to see you on one, or both, of the events!


PS: Tjees, do I sound like a commercial or what ?
Even dom himself couldnt do more link-shopping, could he ?
You two (you know who you are) now Happy with this ?

Anyone interested in starting a Toon-chapter of UKOUG. Logo: black and white stripes...?

Miracle Open Oracle World

Mooow.

This is a Shameless Plug.

I'll blame it on the credit-crunch: I was looking at a slow-ish week with a few documents to review, a few meetings left-right-centre, and especially a lot of boring car-commutes.

What saved me was a brief chat with Anjo Klok from Miracle Benelux. There were a few spaces left at the Miracle Oracle Openworld (Moo?) Event in Lalandia.

So, Im writing form the back of a minivan on my way to the Event. and to justify my use of the Miracle Taxi Service (MTS), I should give the good folks at Miracle some free publicity.

Here is the Banner


There are a few aspects that make this event unique:
First, the quality of the speakers and presentations. Secondly, there is the relatively small scale of the event. It is about the size of a good UKOUG SIG meeting, and offers a good opportunity to mix with the speakers. Mogens, the organizer, deliberately did not provide a speaker-lounge, hence the Gurus cannot hide from the hoi-polloi. Ample opportunity to harass them with questions.

Oh, and dont mention it to your manager, but the Danes also know how to throw a party, or two.

More later!

Birmingham UKOUG annual conference

If you can attend just one Oracle event per year: Come to Birmingham.

Despite the logo, the event is more then just a party:

The size of the event makes it unique and the provides a huge range of topics and speakers.

And if the bean-counters question the need for membership-fee and participation-effort, then question them on the amount of licensing- and consulting fees that need to be paid annually to this large software vendor....

Because if your employer is spending millions per year in licensing, they should at least make sure they keep checks on what other users do. A Usergroup is an excellent opportunity to discuss and argue with colleague-victims who are held hostage by the same vendor.

"The Conference" is one of the Largest and Best Organized non-Oracle-Oracle events (e.g. not organized by Oracle, but still about Oracle) on this side of the Atlantic.

Why do I really post this?

As always, the blogosphere is asked to plug, to promote and to web-Link this event into the search-engine rankings (the request went out weeks ago, and I am probably the last, fashionably late, blogger to put in an entry... But hey: there might be drinkies again at the blogger-event).

See you in Brum!

UKOUG 2008 Bloggers Assistance.

It is that time of year: the UKOUG is on with the Organisation of the next Big Yearly Conference. And as this is the 25th edition, it may just be Extra Feisty.

The call for papers is out and can be found here: http://conference.ukoug.org/




As always, the blogosphere is asked to plug, to promote and to web-Link this event into the search-engine rankings (the request went out weeks ago, and I am probably the last, fashionably late, blogger to put in an entry... But hey: there might be drinkies again at the blogger-event).

To be honest: This one is Worth It!

It is one of the Largest and Best Organized non-Oracle-Oracle events (e.g. not organized by Oracle, but still about Oracle) on this side of the Atlantic. Another good one is the SIOUG in Slovenia[link]: surprisingly Large Event and in a very nice location (yes, I was there last year, and it was Great Fun).


Time to go over my project-notes from this year to see what I can bring to the party. I had several ideas in the last months, but none of them are very "nice". But then, that is what user-groups are for maybe: Calling a Spade a Spade ?

"Upgrade Nightmares"
Indeed, why do we do it each time? why do we take the bait and the FUD each time and go through these Painful Upgrades...
My Cost+work saving tip for today would be: If you are still on 9.2 or even 8.1.7.4, and are considering to upgrade (as you should) why not show real balls and wait for 11.2 to come along?
If you have to go through the pain of an upgrade, you might as well
go to the highest possible version and be done for at least the next 2 years...

"Is my Diaster (re)Covered?"
Well... yes, but... (Oracle will never say No..)
If and Only If you took all the right precautions, and after you have managed to DIY the recovery all by yourself, Then the jovial Oracle representative is ready to share in your success!

If you had failed, then that is exactly what would have happened:
"YOU and only you, the miserably non-manual-reading, non-certified,
non-budget-spending, non-patch-applying DBA, would have Failed".
It could not possibly be the fault of those expensive Oracle products, could it?
Actually, let this narrow-escape be a lesson to you:
In future, you will need to buy more (licensed options) of these products just to make sure you show your total determination to spend your whole budget on their products.
BTW: the long winding small print on all Oracle products (the screen with the "I agree" button)states the equivalent of:
"Any disaster will still be your responsability..."


Right.
Those titles should get me in the "good book" of someone (whoever pays for my UKOUG budget), but probably not in the book of Oracle... hmmm.

In short:
If you want to know what works and what does not work with Oracle Products and Tools, then come to the UKOUG conference. The information you can get there is about as good as it gets.

See You There!

Touting for Business

For the moment, October is heating up with a very full Agenda.

Remember, I must also bring in some bacon for my bosses. Hence keep an eye on my billability. Combined with various other activities and just-one-more-presentation popping up, It looks like October is counted for.

November, by contrast looks Quiet. First three weeks of November see a surprising drop in demand (demand for my services, that is). I am looking forward to doing some Research and Development, and to refresh my Hands-On experience.

But... as a good consultant, with respect to Shareholder value (not to mention my managers-managers-bosses who want to retire early) I should be charging my time Adding Value to some Customer (Mind you, November, and I'm stocked up on firewood...)


Anyway, need to get serious. Hence this simple Tout:

Hire Me. (in November)

I can poke fun at your vendors.
I can make your Architects Cringe.
I can make your DBA's laugh (or cry)

Simply put: I am an Oracle DBA.
For more of my credentials: see the right-hand side of this blog, or just Google me

NB: No FUD here, I will not stick around to eat all of your budget: I'm booked for the last week of November. Then I'm going to UKOUG (that takes care of 1st week of December), and then I'm booked for at least one week in December. And Christmas is approaching.

After the Holidays, I already have Various part-time commitments for January and February, so that looks good (to my manager).

But November has some space.
Hence the shout.

sitemap

Here are the introductions to PdvFirstBlog and SimpleOracleDBA,

Intro - if available - This is where I started my my blogging era

Simple oracle DBA - The main topic.

Various Oracle Tips and Rants and Opinions, all to do with practicalities.

Simple Oracle DBA - Availability, Scalability, Manageability... It has to be Simple

Bitmap Indexes on an OLTP system - ORA-00060... Classic Deadlock

Backup on a different Level - in the SOA layer.

How To Pool Connections - One of the challenges

Databases Everywhwere - Systems and Databases, how many databases.

ILM, Information LifeCycle Management - another Three Letter Acronym.

Index Organized Tables - Many Benefits

txt - txt.

txt - txt.

UKOUG - I do value my usergroup events.

Various Rants, all to do with practicalities.

In times of Crisis you call the DBA - Who you gonna call...

Rationalize TOAD - Toad will find a way...

M O O W - Miracle Oracle Open World...

My blog-plug for the Conference - UK Oracle USergroup...

Travel related stuff.

Angel of the North - My most visited leasure page...

Inconvenience of Leeds Bradford International Airport.

Eurostar is Perfect - Very comfortable and reliable.

Colorado - Winter Park, actually.

Back to Normal - on the train.

Climate - Enjoy while it lasts....

Cricket - I have no clue.

Work, Dinners, Fun - and lots of miles on the train.

Angel - of the North, my most searched for picture.

UKOUG - my excuse to travel.

txt - txt.

txt - txt.

The usual links to groups etc..


my agenda (normally at the right hand side of the blog)




UKOUG main url



Miracle BV



the home of Oracle-L : Best Mailing list



link to Oracle Forum.



My own linked in profile (shameless plug)


Dont believe me ? Google

See you Somewhere, and say Hi if you feel like it!