jump to navigation

Return of the Disasters – OUG Ireland 2015 February 23, 2015

Posted by mwidlake in conference, Presenting.
Tags: , ,
3 comments

In just under a month I’ll be off to Dublin for the 2015 OUG Ireland conference. It takes place on Thursday the 19th of March. I’m doing my favorite presentation to present, on I.T. disasters I have witnessed and what you can learn from them (so now the title of this blog makes sense and maybe is not as exciting as it suggested). It is also the talk I get most nervous about doing. I tend to put a bit of humour into any presentation I do but if it is predominantly a technical talk, it’s fine if the humour falls flat. When I am intending to be entertaining, as I do with this one, there is more at stake!

not_the_best_thing_to_drop

Back in the mid-2000’s I used to do this talk once or twice a year but these days it tends not to get accepted for conferences. I suspect it is partly as I had done it a good few times and partly as it is hard to place it under the categories Oracle Technical conferences have. Is it technical? Is it project management? Is it entertainment? It is actually a bit of all of them. They are all true stories and each one highlights how we should not do things, be it some of the pitfalls of project management or where disaster tolerant hardware turned out not to be.

I’ve mentioned this presentation a couple of times in my blog. Once early on in 2009 when no one came by here very often, where I go into why I toned down the talk {concern over impact on my career/perceived professionalism} for a while and the impact of that decision {a bland and rather poor talk}. It crops up again in a post in 2013, which I think is the last time I gave this talk. I am not sure I did a very good job of it then either, as I was not well during that trip (not helped by rough seas but I was ill for other reasons). Thus I am looking forward to giving it another airing and, as I no longer worry too much about the career, I might just let rip a little more. I have a few more disasters under my belt since I originally wrote the talk, so I might include one or two of them…

The OUG Ireland conference itself is a fair-sized event, running from 09:00 to 17:30 or so, with 7 concurrent tracks covering Applications, Cloud, BI, Database and Development. I’m astounded by the number of Oracle Aces, Oaktable members and other top knowledge sharers who will be presenting {Update – Brendan Tierney has put together a list of all ACEs presenting}. I’ll have several hard decisions about which talk I go to at any given time. I’ll certainly be at Maria Colgan’s Tech keynote at the end of the day though, I’m hoping for another offer of a date* ;-).

To my shame, I have never been to Ireland before and it’s only just over there {points West}, about 90 minutes by plane. So I am turning up Wednesday lunch time and staying to late Friday afternoon so that I can look around and spend some time with fellow presenting friends (and anyone else who I bump into).

All in all, it is a trip I am greatly looking forward to for various reasons. If you can get along I encourage you to do so. And, if you are there and see me around, come and say “hi”.

{* Note to lawyers, this is an in-joke}.

Learning for free – UK User Group Meetings Coming Up February 20, 2015

Posted by mwidlake in conference, UKOUG.
Tags: , ,
add a comment

There are a few user group meetings coming up in the UK over the next week or two.

Note, you need to register to attend any of these, follow the links.

First is Club Oracle London, which are evening sessions held in London with 3 talks plus free beer and pizza. The next meeting is Thursday Feb 26th at 103a Oxford Street, kicking off at 18:30. You can register for this free event here and also see more details. In brief, Simon Haslam is talking about Oracle Database Appliance, Martin Bach on 12C new features the marketing guys don’t push and finally Phil Brown giving a virtualisation case study, how NOT to do it.

On the 3rd March there is the 8th meeting of Oracle Midlands – again an evening event but this one is in Birmingham. Again, it’s free and samosas {lots of samosas!} turn up half way through to keep you going. Held at Innovation Birmingham near Aston University, there will be Chris Saxon on using Edition Based Redefinition to release PL/SQL to busy systems (ie the PL/SQL code is constantly being executed) and Tim Hall talking about Pluggable Database and why this new feature can “break” things. Tim is good enough to say how you fix the broken (I wonder if the single logwriter will crop up?). They give away some free stuff too!

Finally, on the 4th March and back in London there is the next next UKOUG RAC, Cloud, Infrastructure & Availability SIG. Bit of a mouthful that but we can’t come up with a snappy name that covers the remit of the SIG. We are trying a new format for this SIG, inspired by the two above events. We still have a full-day’s-worth of content but we start at 15:00 and go on into 20:00 in the evening. We hope that this will allow more people to attend without feeling they need to lose the whole working day to it. NB this event is free to UKOUG members but you can pay to come if you (or usually your employer) are not a member. We have talks by Jason Arneil on 12C ASM, Dave Burnham talking about free text searching, David Hickson presenting on linux OS resource management and Jamie Wallis from Oracle on TFA – Diagnostics for the Cloud. Plus a panel session where we discuss whatever you want to discuss!

I’ll be along to Club Oracle London and the RAC CIA SIG but sadly not Oracle Midlands – just can’t squeeze it in which is a real shame as it’s an excellent event.

If time, travel requirements and inclination allow, there are usually beers at a local pub after all the above where you can continue to talk about oracle stuff. Or not. It’s usually a mix :-)

Finally, a quick plug for the OUG Ireland on 19th March. This is a full, one-day conference with more speakers than I can cover, held in Dublin. There are loads of excellent presenters, many are Oracle Aces, Oaktable members and experts in their field. I’ll be there doing my favorite talk, but I’ll do a separate blog about that.

Friday Philosophy – Want to Get On in Business? Don’t Start from Down Here February 13, 2015

Posted by mwidlake in Friday Philosophy, humour, off-topic, Private Life.
Tags: , ,
22 comments

I had a manager a few years ago, a lady. She was good at her job, knew the tech and we got on well. And she would take the piss out of me constantly about my height. One day, another member of the team suddenly said “Hey! Leave him alone! He might actually be sensitive about it and it’s wrong you should be bullying him like this”. My boss replied “Oh come on, he’s not sensitive about it! He takes the Mickey out of himself all the time!”

“Besides… He’s too short to do anything about it.”

It was bloody funny and I think all of us laughed at that – but my defender had a point. I might joke about my height and most of the time I’m fine about it, but day after day of comments and jokes? And other stuff? Crouch down here beside me for 5 minutes and I’ll show you the view…

I am small. If you have not met me, I stand five foot and two and a half inches (158.5cm) tall in my socks. Don’t forget the half inch, it’s important. I have no medical condition, no dwarfism, no biochemical challenges, nothing is wrong to make me small. My parents were small, my grandparents were small, my brothers are similar to me. I’m just small. All of me is in proportion, with one notable exception.

My Ego – That’s huge.

The Three Martins at UKOUG Tech14

The Three Martins at UKOUG Tech14

I should not complain too much. I have all my limbs and senses, everything physical works well, my brain does a pretty good job {despite a few quirks}, I have friends and a wife and I’ve done OK in my career. Actually, no. Let the positive be positive and the negative be negative – I’ve done well in my career.

But it is a Bit Shit Being a Short Man.

As my friends and colleagues are aware, I sometimes make a lot of being small. I am often the first to mention it and I can sure as hell make fun of myself about it. However, it is a defence mechanism. Don’t even think of taking the piss out of me for being small as, hey, I’m already doing it and I can do it a lot better than you – I have almost 4 decades of practice {anybody remember the nose-jokes scene by Steve Martin in Roxanne?}. If I am willing to joke about being small I rather effectively remove the ability for someone else to do so to abuse me about it and also give them permission to mention it. I’ve taken away most of the potential for someone to be directly negative about my height unless they are willing to be very, very pointed and very obviously unpleasant. Since leaving my early 20’s, very few people have been willing or inclined to do that, so it is an effective strategy. But for those who know me well, it becomes annoying. I’m constantly taking steps to establish this defence and as a result I tend to harp on about my height. Some suggest I stop doing it as it is boring and unnecessary. I should not put myself down. {Down!}. They may be right, but it is a defence mechanism that has served me well and I guess I err on the side of over-emphasising it. So I’m sorry if it bugs some of you, but allow me my oddities please.

But there is one area where humour does not help and it is an area where I probably get the most discrimination since leaving school (where the old standards of being hit, pinned down, thrown or similarly physically messed with were more popular – oh, for the sweet innocence of childhood).

As a Small Male I am often not listened to or taken seriously by people – especially management. Management is full of Alpha Males {actually, in IT mostly it’s beta males, all the Real Men are in finance, sales or other crime}. This is true even when I am a fellow manager. I can’t number the times I have been in a meeting, said something and the conversation has continued as if everyone had just taken a moment to look out the window, rather than listening to someone contributing. Many times I’ve had that galling experience of an idea I put forward being ignored until someone else, someone… more tall… says the same thing and then it is a great idea. Or of being talked over by an Alpha Male. Repeatedly. Early on I made the mistake of challenging this head-on a few times and the response was either simple denial or, worse, condescension. “Oh don’t be so sensitive Martin” or “Of course we value your input, don’t be so silly and just grow up”. Yes, I’ve had that.

I suspect most women reading this will be recognising these issues and saying “Yep, welcome to my world”. For a long time I’ve felt there is a parallel between being a small male in a working environment, especially in management, and being a women. Don’t get me wrong, small men don’t get the constant other hassles women get. I don’t get looked up {err… looked down in my case?} , I never feel like I am being hit on {or maybe I am just missing it, I’m terribly naïve}, no one has come up to me in a conference and said “my friend likes you, will you come and talk to him” {my wife has had this – she said it was like being back to school parties but with an extra element of Creepie}. But I often get ignored and my input to discussions gets downgraded. I’ve watched this happen to female colleagues year after year, it is a real issue. Some men will listen politely to women but it is simply listening politely – before they mentally rewind the meeting to before the “delightful lady said something” and continue with the proper matter in hand. They do exactly the same to my input. I’m not an alpha male, I’m a child, it’s nice that they let me be there and join in.

But unlike sexual or most other forms of discrimination I also have no real recourse to… Anything. There is of course no legal position on heightism. There is also no social pressure on or condemnation of heightism. In fact , if anything it’s the opposite. “You silly little man”, “Grow up” and a whole catalogue of insults with the word “little” or “small” or “tiny” thrown in for emphasis. There are plenty of sitcoms where the small guy is the dweeb or the butt of the jokes. Not many films where the action hero is played by someone like Danny DeVito. And if the actor is small, efforts are taken to hide that (how many of you are thinking Tom Cruise? – who is all of 4 inches below average! He’s not small!!! He’s in the normal 60-70%!). If I challenge the attitude directly it rarely goes well, especially if I am angry. Apparently, there are few things funnier than a small bloke jumping up and down with a red face squeeking “Take me Seriously!!!”. It’s also very tiring. I have to jump quite high to be seen past the desk. And suggesting I am acting like a child is just more damned height discrimination you… dickhead.

Even when people are trying to be nice to short men they often just continue the discrimination without noticing, thinking it’s some sort of complement. Think about it, how often when someone small is being praised do they say something like “He may only be small but inside there is a giant” or “Dave may not be the tallest guy but, in respect of {blah}, he towers above us”. They are still saying short is bad and tall is good! You would not say of someone who’s fat “Derek may be obese but inside he has the physique of a Greek God”. And you would certainly not ever, ever say “Mike may be black but inside there is a white guy trying to get out”!!!

Do you think I’m making too much about this? I am being overly sensitive to a problem that does not really exist? Well, stay crouched with me and do a quick web search on the correlation between height and pay, height and political success, height and business success {NB three different links, just to “google.uk” really}. Again, women will recognise all this. And of course, I don’t have issues with my height all the time. Many people listen to me, I have managed to function as a manager and sometimes when I make a side reference to it, people will stop and go “oh. Yes, I see what you mean”. But it is a constant background bloody maddening annoyance.

Interestingly, I mentioned this all to a friend a while back when we were discussing the hard time women and ethnic minorities can have and at first I think he just listened politely. A couple of months later we were chatting again and he said something like “you know, I’ve been thinking about what you said. I’ve never had a short manager, most senior people I come across are at least average or tall. The small men I come across are technicians”.

So thanks for crouching down here with me for a few minutes to take in the view, you better stand up again before your knees give you hell.

There is nothing I can really do about the above, it’s just a fact of life that heightism is there and at least it is not a type of discrimination that is aggressive of hateful, unlike the serious ones that society does or is starting to tackle. But I just wanted to mention it, to get it off my chest. It’s been weighing me down.

Remember that half inch of height I said was important? Well, it is but not maybe in the way you might think. When I was personally hung up about my height, especially when I was in my teens {and actually just into my 20’s} and still growing, then every half inch of height was significant as it was me “improving”. When I stuck at 5’2.5” the .5 was important as it pushed me into the normal 5th-95th percentile for height – or it did if you were looking at a graph from a pretty old encyclopaedia, like I was. Average height has risen by a couple of inches in the last 50 years and varies from country to country and I’m not even close to the normal range now. It’s really mean of you guys to have moved the goal posts by growing even more. But the 0.5 inch took on a new significance in my late-20’s as I stopped worrying about it or mentioning it if anyone asked my height. I’m small, that’s not going to change and it’s fine. I mention the half more now than I did then, as it makes me smile when I say “5 foot 2…and a half”.

iTunes 12.1 skips after recent update February 9, 2015

Posted by mwidlake in off-topic.
Tags: ,
6 comments

iTunes started skipping on my PC after a recent update (end of Jan 2015). It is version 12.1 of iTunes.

iTunes skips when using Chrome, mostly.

That’s enough search-friendly lines to help the web crawlers get here. Apologies to my normal visitors, this is obviously nothing to do with Oracle databases, development or my usual ramblings. Go read something else unless you landed here looking for help with skipping iTunes playback.

iTunes on my laptop wanted to update a few days ago so I let it. Next time I fired iTunes up, I was annoyed to discover that a track I had recently uploaded, from a compilation CD I have of 60’s classics, was poor quality and skipping. Except that the next few tracks also skipped a little, old favorites I knew were fine. I did a quick web search but most of the references were 4 or 5 years old. The skipping was getting worse so I shut down iTunes and used a…. CD player.

A few days later I was working on the machine and wanted some music to ease the task in hand, fired up iTunes and it was soon skipping again. I then fired up a few extra Chrome windows (for unrelated reasons) and the skipping got a lot worse. I shut down Chrome and the skipping stopped. A bit of testing revealed that iTunes did not skip for me on an, admittedly, lightly loaded machine – but did when Chrome was up and running. Anything constantly updating in Chrome (Twitter feed or live sports update) made it worse.

My machine is quite powerful, it’s an MSi gaming machine with an Intel i7-4700 processor, 8GB of memory and a dual SSD/HDD with the OS and applications sitting on the SSD. It’s not lack of grunt that was causing the issue but something crap in what iTunes is doing.

I found a solution – This apple.com discussion – which itself links to this download for a 64-bit version of iTunes 12.1 supporting “older video cards”. My video card is not that old in the scheme of things, being a GeForce GTX 765M which was a pretty reasonable card 12 months ago.

After I downloaded the alternative version of iTunes and let it install, the skipping seems to have stopped. I’ve tested having a dozen Chrome tabs open with a couple of them being interactive and my chosen 80’s music selection was skip-free.

I hope that helps people. If you came here for the iTunes hint, don’t look at the rest of the blog, you will be sadly disappointed :-)

Friday Philosophy – How Much does Social Media Impact your Career for Real? February 6, 2015

Posted by mwidlake in Blogging, Friday Philosophy, humour, Perceptions.
Tags: , , ,
10 comments

Does what you tweet impact your chances of getting that next interview?
Do people check out your Facebook pictures before making you a job offer?
Does my Blog actually have any impact on my career?

We’ve all heard horror stories about people losing their job as a result of a putting something “very unfortunate” on their facebook page, like how they were on holiday/at a sports event when their employer was under the illusion they were off sick, or the more obvious {and pretty stupid} act of denigrating their boss or employer. But how much does general, day-to-day social media impact your career? {“Your” as in you people who come by this blog, mostly professionals in IT. I know it will be different for people trying to get a job in media or….social media :-) }.

Two things recently have made me wonder about this:

  • The first is that I’ve been in or watched a few discussions recently (via social media!) where people are suggesting that their social media output is part of who they are seen as professionally and they make efforts to ensure they give the right impression, or have even sought professional help to improve their social media standing in respect of employment.
  • The second is that I recently was involved in some hiring and I never even thought to look at their social media. Maybe that is just because I’m over {picks an age} 30 and social media is not a massive thing to me. Most of my hiring experience was before the likes of Facebook and though I would check out a blog if it was mentioned on a CV, I would not have thought to check them out.

When I initially thought about that second point I assumed that most people hiring in the world of IT are similarly a bit ancient like myself and maybe not that attuned to social media. But perhaps I am wrong as it’s people similar to me out there on Twitter who have been worrying about such things. Maybe social media is considered by potential employees than I think? I’d like to know what anyone else thinks.

I should add that I don’t see all Social Media as the same when it comes to it’s impact on your career. I think their is Friends Social and Business Social. Something like LinkedIn is aimed fair and square at business and professional activity and is Business Social. You would really expect it to be looked at and, in fact, most people who use it would hope it is! {Mine isn’t, I get about 3 or 4 views a week and only once, 5 or 6 years ago, was I approached via it for a work opportunity}. If you blog about a work topic or tweet as an expert in your field (so your tweets are mostly about your day job, not just the odd reference) and especially if you are doing either under a company banner then, yes, I’d expect that to be taken into account when prospective employment comes up.

Social Media is most people’s twittering, personal Facebook, private blogs, Pinterest and all those dozens of things I know nothing about as I am too old and too antisocial. Do these really have much impact on your career?

I would suggest not, again for two reasons:

  • I don’t think most employers are going to look at your Friends Social Media until they have at least interviewed you, as when you are hiring you barely have enough time to check over the CV’s, let alone research each candidate’s personal history. Once you have interviewed them, then they have become a real person rather than a name and if you do check out their Friends Social Media then you will look at it in light of them being a human being, which is point 2:
  • Unless you are saying things that would make anyone think you are a bit odd or unpleasant, I can’t see that discussions of football, insulting your friends, making double entendra comments or (one of my favorites) pointless drivel about your cat is going to make anyone who you would want to work for worry about you. Some people might put up things that could be offensive to others – but then, if you really do think immigrants are ruining the UK, we are not going to get on so working together is a mistake for both of us. So maybe even stating your strongly held opinions is long-term beneficial as well. Some people take my strong dislike of children as a real reason to not like me very much. Best we don’t spend 8 hours a day, five days a week together. You’ll only bang on about your bloody kids.

What I think is a shame is that I suspect some people {many people?} self-censor themselves on all Social Media due to a concern to always be seen as professional. As good worker material. We all know that almost everyone we work with have unprofessional moments and, in fact, those few who are professional all the time tend to be… staggeringly dull.

So maybe being mindful of your professional standing is totally correct on Business Social Media but a bit of a shame if you let it impact your Friends Social Media.

But remember, on all social media there are limits. There are some things about you, Dave, that you should simply not share. Or at least, only at the pub when we are all too drunk to care.

An Oracle Instance is Like An Upmarket Restaurant January 28, 2015

Posted by mwidlake in Architecture.
Tags: ,
11 comments

I recently did an Introduction to Oracle presentation, describing how the oracle instance worked – technically, but from a very high level. In it I used the analogy of a restaurant, which I was quite happy with. I am now looking at converting that talk into a set of short articles and it struck me that the restaurant analogy is rather good!

Here is a slide from the talk:

Simple partial overview of an Oracle Instance

Simple partial overview of an Oracle Instance

As a user of the oracle instance, you are the little, red blob at the bottom left. You (well, your process, be it SQL*Plus, SQL*Developer, a Java app or whatever) do nothing to the database directly. It is all done for you by the Oracle Sever Process – and this is your waiter.

Now, the waiter may wait on many tables (Multi-threaded server) but this is a very posh restaurant, you get your own waiter.

You ask the waiter for food and the waiter goes off and asks the restaurant to provide it. There are many people working in the restaurant, most of them doing specific jobs and they go off and do whatever they do. You, the customer, have no idea who they are or what they do and you don’t really care. You don’t see most of them. You just wait for your food (your SQL results) to turn up. And this is exactly how an Oracle Instance works. Lots of specific processes carry out their own tasks but they are coordinated and the do the job without most of us having much of an idea what each bit does. Finally, some of the food is ready and the waiter delivers the starter to you – The server process brings you the first rows of data.

Let’s expand the analogy a bit, see how far we can take it.

When you arrived at the restaurant, the Maître d’ greets you and allocates you to your waiter. This is like the Listener process waiting for connection requests and allocating you a server process. The Listener Process listens on a particular port, which is the front door to the restaurant. When you log onto an oracle database your session is created, ie your table is laid. If someone has only just logged off the database their session might get partially cleared and re-used for you (you can see this as the SID may well get re-used), as creating a session is a large task for the database. If someone had just left the restaurant that table may have a quick brush down and the cutlery refreshed, but the table cloth, candle and silly flower in a vase stay. Completely striping a table and relaying it takes more time.

The restaurant occupies a part of the building, the database occupies part of the server. Other things go in the server, the restaurant is in a hotel.

The PMON process is the restaurant manager or Head of House maybe and SMON is the kitchen manager, keeping an eye on the processes/staff and parts of the restaurant they are responsible for. To be candid, I don’t really know what PMON and SMON do in detail and I have no real idea how you run a large kitchen.

There are lots of other processes, these are equivalent to the Sous-chef, Saucier, commis-chef, Plonger (washes up, the ARC processes maybe?), Ritisseur, Poissonier, Patissier etc. They just do stuff, let’s not worry about the details, we just know there are lots of them making it all happen and we the customer or end user never see them.

The PGA is the table area in the restaurant, where all the dishes are arranged and provided to each customer? That does not quite work as the waiter does not sit at our table and feed us.

The SGA is the kitchen, where the ingredients are gathered together and converted into the dishes – the data blocks are gathered in the block buffer cache and processed. The Block Buffer Cache are the tables and kitchen surfaces, where all the ingredients sit. The Library cache is, yes, the recipes. They keep getting re-used as our kitchen only does certain recipes, it’s a database with a set of standard queries. It’s when some fool orders off-menu that it all goes to pot.

Food is kept in the larder and fridges – the tablespaces on disc. You do not prepare the dishes in the larder or fridge, let alone eat food out of them (well, some of the oracle process might nick the odd piece of cooked chicken or chocolate). everything is brought into the kitchen {the SGA} and processed there, on the kitchen tables.

The orders for food are the requests for change – the redo deltas. Nothing is considered ordered until it is on that board in the kitchen, that is the vital information. All the orders are preserved (so you know what was ordered, you can do the accounts and you can re-stock). The archived redo. You don’t have to keep this information but if you don’t, it’s a lot harder to run the restaurant and you can’t find out what was ordered last night.

The SCN is the clock on the wall and all orders get the time they were place on them, so people get their food prepared in order.

When you alter the ingredients, eg grate some of the Parmesan cheese into a sauce, the rest of the cheese (which, being an ingredient is in the SGA) is not put back into the fridge immediately, ie put back into storage. It will probably be used again soon. That’ll push it up the LRU list. Eventually someone will put it back, probably the Garçon de cuisine (the kitchen boy). A big restaurant will gave more then one Garçon de cuisine, all with DBW1 to x written on the back of their whites, and they take the ingredients back to the larder or kitchen when they get around to it – or are ordered to do so by one of the chefs.

Can we pull in the idea of RAC? I think we can. We can think of it as a large hotel complex which will have several restaurants, or at least places to eat. They have their own kitchens but the food is all stored in the central store rooms of the hotel complex. I can’t think what can be an analogy of block pinging as only a badly designed or run restautant would for example only have one block of Parmesan cheese – oh, maybe it IS a lot like some of the RAC implementations I have seen :-)

What is the Sommelier (wine waiter) in all of this? Suggestions on a post card please.

Does anyone have any enhancements to my analogy?

The BBC has “Stolen” my Interesting Shortest Day Facts December 21, 2014

Posted by mwidlake in off-topic.
Tags:
2 comments

Today, the 21st December 2014, is the “shortest day” in the Western Hemisphere this year, the day in which the period of daylight is shortest (it’s the 22nd if the last Leap Year is more than 2 years ago).

I’ve blogged before about how the evenings start drawing out BEFORE the shortest day and, despite it not being an Oracle technical post and was also one of my first posts {when almost no one came by}, it gets a modest but interesting number of hits. If you look at the below graphs (sorry, it’s not as clear as it could be unless you click on the image), you will see there is a burst of hits at the end of the year and a smaller rise in interest at the middle of the year.

Evenings_post_stats

These hits are all via search engines, mostly on the phrase “Evenings drawing out”. Obviously there is a correlation with people both in the Northern (for the December hits) and Southern (for the June hits) hemispheres getting sick of the longer periods of dark and googling about when it will start to change. And finding this strangely relevant post on what is otherwise a nerdy IT site.

{Isn’t this an example of what all the IT blather about Big Data and the cloud is about? Finding patterns in search engine data etc? My blog is not exactly Big Data though :-) }

Well, The BBC is probably going to steal my thunder, this year at least, as they have done an article on the phenomena, though concentrating more on the mornings continuing to get darker after the “shortest day”. It’s not a very good article in one respect, though, as it has the phrase “perceived a curious development” as though this mismatch between the shortest day and mornings/evenings getting later is a recent change. I’m pretty sure that the tilt of our planet and it’s orbit around the sun has not changed enough in my lifetime to alter this situation! In fact, I checked – evenings started drawing out on around the 13th December 50 years ago, exactly the same as this year and exactly the same as is expected in 50 years too. It does describe well, however, how it is our shifting clock (due to the longer day length around now) that causes the shift.

Another little oddity about shortest day and our planet is in respect of when you think the earth is furthest from the sun. Most of us in the Northern hemisphere assume it is on the shortest day, because it is colder and darker. But it is not. we are actually nearest to the sun, at “perihelion”, on the 3rd Jan. So not even “shortest day” but just after :-).

Friday Philosophy – my Funniest “PC Support” Call in Years December 19, 2014

Posted by mwidlake in Friday Philosophy, humour, Private Life.
Tags: , ,
add a comment

Those of us who work in IT often find ourselves being called by friends and relatives to help with issues they have with their home computer. No matter what branch of IT we work in, it’s IT {they figure} so of course we can fix their PC problems. It’s like any scientist can probably explain what the Higgs Boson really is and reverse the polarity of the neutron flow.

Mothers and other elderly relatives are probably the most baffling when it comes to such requests, but this week I had a wonderful call-out from one of my neighbours.

The neighour in question is a slightly dotty, jolly posh but well meaning Lady (we live in the cheap house around here, she lives at the other end of things).

“Oh Martin, it’s AWE-full! My computer is full of p3nises and other horrible things!!! Please help me get rid of all the p3nises!!!”

Ahhh… I wonder what sites she’s been looking at…must be a virus or something. “It’s OK Tabitha, I’ll pop down now and have a look for you” I say. “Oh, that is so decent of you, your such a helpful young man!” {Young?!?}

So I tell my wife I’ve off over to Tabitha’s to help her with p3nises – and leave her sniggering on the sofa. When I arrive Tabitha opens the door and exclaims, quite loudly “oh thank you for coming to help me with these p3nises and things!”. Thanks, Tabitha, I’m sure John and Elaine could hear that.

It takes ages to get to the bottom of what her issue is as she is talking non-stop, wandering off track and saying how they must think she’s a man as they want her to buy certain drugs and she keeps describing the p3nises and naked people “doing very rude things” she has seen – and each time I try and do anything on her tablet she’ll suddenly lean over and tap on any icons or links. It’s like a Pavlovian response. This could be the root of all her IT woes…

It turns out her virus scanner is running (I set her up with that), up to date and there seems to be no infection. The problem is simply the spam email she (and we all) get. She has her mail application set to preview and also download any images in the email. And she checks each spam email before deleting each one. I suspect sometimes she checks in detail…

We then have a long and sometimes surreal conversation about why they think she should want to buy viagra, enhancement creams or meet Tanya who is local, fun, vivacious and wants some company. {“Well she sounds like she just wants some friends to me” – “DON’T CLICK ON THAT LINK!!!!”}. At least she knows to never respond to emails about bills, banks, missed messages or vast sums of money – we had that conversation when I helped her sort out the Laptop a year or two back. I did not bring up sex as, well, you don’t talk to nice ladies like Tabitha about sex… Tabitha did ask if she should respond to ask them to just stop sending her these pictures but I assured her it would only get worse if we did. These are not nice people we are dealing with.

We could not sort out better filtering at her mail server end for various reasons so in the end I showed her how to turn off the preview and delete all spam with one click. That mollified her and I was allowed to leave.

There was one small knock-on effect. Now apparently, according to her (other neighbours tell me she has said this) I “am wonderful with p3nises”.

Nice to know.

Thank you for letting me share that one…

If anyone has other tails of enforced PC support which might amuse, please share – T’is the season to be Jolly after all. But please changes names! This is a public blog, Tabitha may never come across my posts but at least she will know she is not called Tabitha.

UKOUG Tech14 Suggestions for Intro Talks and My Picks of the Rest December 4, 2014

Posted by mwidlake in conference, Meeting notes, UKOUG.
Tags: , ,
1 comment so far

As I mentioned in my last post, we tried to organise a thread of intro talks into day one and two of this year’s UKOUG Tech14 conference (you can see the agenda grid here). It was not complete but I thought I should pull it into it’s own post and add in what I would recommend from the overall agenda for people who are relatively new to Oracle RDBMS.

Monday 8th

  • 08:50 – Welcome and Introduction
    • Get there in time for the intro if you can, as if you are newish to the tech you are probably newish to a conference.
  • 09:00 RMAN the basics, by Michael Abbey.
    • If you are a DBA type, backup/recovery is your number one concern.
  • 10:00 – How Oracle Works in 50 Minutes
    • My attempt to cover the basic architecture in under an hour.
  • 11:30 – All about Joins by Tony Hasler
    • Top presenter, always good content
  • 12:30 – Lunch. Go and talk to people, lots of people, find some people you might like to talk with again.
  • 13:20 – Go to the Oracle Keynote.
    • The keynote itself is shorter than normal and afterit there is a panel discussion by technical experts.
  • 14:30 is a bit tricky. Tim Hall on Analytical Functions is maybe a bit advanced, but Tim is a brilliant teacher and it is an intro to the subject. Failing that, I’d suggest the Oracle Enterprise Manager round table hosted by Dev Nayak as Database-centric oracle people should know OEM.
  • 16:00 – Again a bit tricky for someone new but I’d plump for The role of Privileges and Roles in Oracle 12C by Carl Dudley. He lectures (lectured?) in database technology and knows his stuff, but this is a New Feature talk…
  • 17:00 – Tuning by Explain Plan by Arian Stijf
    • This is a step-by-step guide to understanding the most common tool used for performance tuning
  • 17:50 onwards – go to the exhibition drinks, the community drinks and just make friends. One of the best thing to come out of conferences is meeting people and swapping stories.

Tuesday 9th

  • 09:30 Maria ColganTop 5 things you need to know about Oracle Database in-Memory Option
    • This is actually the Database technical keynote, about one of the key new technologies.
  • 10:30 Introduction to Oracle Application Express by Joel Kallman
    • APEX, as it is often called, is a simple but powerful way to develop applications. It’s probably THE most common thing that DBA-types don’t know and  wish they did?
  • 12:00 If you know any Java then Jacob Landlust on What all DBAs need to understand about JDBC Configuration or else Pete Finnigan on Secure, Review & Lock Down your Oracle Database.
  •  14:00 Chris Lawless on Zero Downtime Migrations using logical Replication
    • Good as he covers the principals of such things which teachers you a lot
  • 15:00 A bit of a struggle for a general Intro talk so I will plump for…Tim Gorman on RDBMS Forensics: Troubleshooting Using ASH as I know Tim will explain why understanding and solving performance issues is a science, not an art
  • 16:30 Tom Kyte on SQL is the best Development Language for Big Data
    • If you are new to Oracle, you pretty much have to go to at least one Tom Kyte presentation.
  • 17:30 Jonathan Lewis Five Hints for Efficient SQL
    • If you are new to Oracle, you pretty much have to go to at least one Jonathan Lewis presentation :-)

Oh, what the heck…

Wednesday 10th

  • 09:00 Jonathan Lewis Fundamentals of trouble shooting Pt1
  • 10:00  Jonathan Lewis Fundamentals of trouble shooting Pt2
  • 11:30 Tim Gorman on three types of table compression
  • 12:30 Tom Kyte More things about Oracle Database 12C
  • 14:30 Alex Nuijten Oracle 12C for developers
  • 15:30 Neil Chandler Goldengate – Migrating my first TB

 

Each year I struggle more and more to get to all the talks I want to, partly as there are so many clashes of good talks but also I end up in interesting conversations with old friends and suddenly realise I’ve missed a talk. Or my brain hits “full” and I have to take a breather.

However, my intended agenda is:

  • 08:50 Welcome and Intro to delegates prior to…
  • 09:00 Martin Bach on Oracle 12C features that didn’t make the marketing top 10
  • 10:00 Myself, HOw Oracle works in 50 minutes
  • 11:00 Coffee and recovering!
  • 11:30 Hmm, I want to go to four… Maybe Robyn Sands, Why Solid SQL still delivers the best ROI.
  • 13:30 Oracle Keynote panel
  • 14:30 Tom Hall on Analytical Functions..Or maybe Larry Carpenter on Active Data Guard…
  • 16:00 Antti Koskinen , Undocumented 11g.12c Features Internals
  • 17:00 Graham Wood, AWR: looking Beyond the Wait Events and Top SQL

Tuesday

  • 09:30 I have the pleasure of chairing Maria Colgan’s Database Keynote, Top Five Things you need to know about Oracle Database in-Memory option
  • 10:30 Joze Senegacnik, Most common Databse Configuration Mistakes
  • 12:00 Richard Foote, Oracle database 12XC New Indexing Features
  • 14:00 Damn… I’ll plump for Maria Colgan on IN-memory and the optimizer. Sorry Tim and Chris
  • 15:00 Now Tim, on RDBMS Forensics and Ash
  • 16:30 Chris Antognini on adaptive query optimization
  • 17:30 it better be Pete Sharman, hot over from Aus, doing deployment best practices for Private cloud, as I am chairing him

Wednesday

  • 09:00 Patrick Hurley, Adventures in Database Administration.
  • 10:00 Me, on boosting performance by clustering data
  • 11:30 Richard Foote, indexing in Exadata
  • 12:30 Tom Kyte, More things about Oracle 12C
  • 14:30 chairing Ganco Dimitriov on the importance of having an appropriate data segmentation
  • 15:30 Last one, 3 to chose from… Neil Chandler on Goldengate I think

Drive home and sleep

 

How do you Explain Oracle in 50 Minutes? December 2, 2014

Posted by mwidlake in Architecture, conference, UKOUG.
Tags: , ,
10 comments

I’ve done a very “brave”* thing. I’ve put forward a talk to this year’s UKOUG Tech14 conference titled “How Oracle Works – in under 50 minutes”. Yes, I really was suggesting I could explain to people how the core of Oracle functions in that time. Not only that, but the talk is aimed at those new to Oracle technology. And it got accepted, so I have to present it. I can’t complain about that too much, I was on the paper selection committee…

* – “brave”, of course, means “stupid” in this context.

As a result I am now strapped to the chair in front of my desk, preparing an attempt to explain the overall structure of an Oracle instance, how data moves in out of storage, how ACID works and a few other things. Writing this blog is just avoidance behaviour on my part as I delay going back to it.

Is it possible? I’m convinced it is.

If you ignore all the additional bits, the things that not all sites use, such as Partitioning, RAC, Resource Manager, Materialized Views etc, etc, etc, then that removes a lot. And if not everyone uses it, then it is not core.
There is no need or intention on my part to talk about details of the core – for example, how the Cost Based aspect of the optimizer works, Oracle permissions or the steps needed for instance recovery. We all use those but the details are ignored by some people for their whole career {not usually people who I would deem competent, despite them holding down jobs as Oracle technicians, but they do}.

You are left with a relatively small set of things going on. Don’t get me wrong, it is still a lot of stuff to talk about and is almost certainly too much for someone to fully take in and digest in the time I have. I’m going to have to present this material as if I am possessed. But my intention is to describe a whole picture that makes sense and will allow people to understand the flow. Then, when they see presentations on aspects of it later in the conference, there is more chance it will stick. I find I need to be taught something 3 or 4 times. The first time simply opens my mind to the general idea, the second time I retain some of the details and the third or forth time I start integrating it into what I already new.

My challenge is to say enough so that it makes sense and *no more*. I have developed a very bad habit of trying to cram too much into a presentation and of course this is a real danger here. I’m trying to make it all visual. There will be slides of text, but they are more for if you want to download the talk after the conference. However, drawing pictures takes much, much, much longer than banging down a half dozen bullet points.

One glimmer in the dark is that there is a coffee break after my session. I can go right up to the wire and then take questions after I officially stop, if I am not wrestled to the ground and thrown out the room.

If anyone has any suggestions or comments about what I should or should not include, I’d love to hear them.

This is all part of my intention to provide more conference content for those new to Oracle. As such, this “overview” talk is at the start of the first day of the main conference, 10am Monday. I have to thank my fellow content organisers for allowing me to stick it in where I wanted it. If you are coming to the conference and don’t know much Oracle yet – then I am amazed you read my blog (or any other blog other than maybe AskTom). But if you have colleagues or friends coming who are still relatively new to the tech, tell them to look out for my talk. I really hope it will help them get that initial understanding.

I had hoped to create a fully fledged thread of intro talks running through all of Monday and Tuesday, but I brought the idea up too late. We really needed to promote the idea at the call for papers and then maybe sources a couple of talk. However, using the talks that were accepted we did manage to get a good stab at a flow of intro talks through Monday. I would suggest:

  • 08:50 – Welcome and Introduction
    • Get there in time for the intro if you can, as if you are newish to the tech you are probably newish to a conference
  • 09:00 RMAN the basics, by Michael Abbey.
    • If you are a DBA type, backup/recovery is your number one concern.
  • 10:00 – How Oracle Works in 50 Minutes
    • I think I have said enough!
  • 11:30 – All about Joins by Tony Hasler
    • Top presenter, always good content
  • 12:30 – Lunch. Go and talk to people, lots of people, find some people you might like to talk with again. *don’t stalk anyone*
  • 13:20 – Go to the Oracle Keynote.
    • Personally, I hate whole-audience keynotes, I am sick of being told every year how “there has never been a better time to invest in oracle technology” – but this one is short and after it there is a panel discussion by technical experts.
  • 14:30 is a bit tricky. Tim Hall on Analytical Functions is maybe a bit advanced, but Tim is a brilliant teacher and it is an intro to the subject. Failing that, I’d suggest the Oracle Enterprise Manager round table hosted by Dev Nayak as Database-centric oracle people should know OEM.
  • 16:00 – Again a bit tricky for someone new but I’d plump for The role of Privileges and Roles in Oracle 12C by Carl Dudley. He lectures (lectured?) in database technology and knows his stuff, but this is a New Feature talk…
  • 17:00 – Tuning by Explain Plan by Arian Stijf
    • This is a step-by-step guide to understanding the most common tool used for performance tuning
  • 17:50 onwards – go to the exhibition drinks, the community drinks and just make friends. One of the best thing to come out of conferences is meeting people and swapping stories.

I better get back to drawing pictures. Each one takes me a day and I need about 8 of them. Whoops!

Follow

Get every new post delivered to your Inbox.

Join 181 other followers