jump to navigation

Friday Philosophy – 3rd Normal Form, 3rd Normal People November 25, 2016

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

I was at a wedding a few months ago and one of the guests was wearing a pair of bear ears (I think – they might have been raccoon ears, they were not exactly anatomically correct). What made it a little unusual was that the guest was an adult and something like 2 meters tall (6’4″ in real units). So they were rather noticeable. But that was it. No tail, no strange mannerisms, just being there and chatting to people, wearing ears.

This is not the person, these are not the ears - but you get the idea

This is not the person, these are not the ears – but you get the idea

Later on in the day, at the afternoon reception, someone came up to me and said “what do you make of the person in the ears?”. Their whole tone said the rest of what they were indicating, which was they thought this was very odd and laughable. I looked at them for a few seconds and said “well, they took the ears off during the wedding service – but I guess you kept all that metal in your face?”.

The person making the comment had their hair dyed several primary colours and, as I indicated, had several studs in their face, a nose ring, a lip ring and a couple of other pieces of shiny stainless steel in strategic places. They were very much taken aback by my reply and went away.

For the first few minutes after the encounter I was really annoyed that someone who had so obviously decided to make a “statement” with how they appeared could be looking to share a laugh about another person who was doing similar – but in a different way. And in a less permanent way than the detractor had. I always get annoyed by people who seem to me to want to have their “thing” but be derisory about those who do their different “thing”.

Is this any less "odd" than the ears? (NB stock photo again)

Is this any less “odd” than the ears?
(NB stock photo again)

But thinking about it, there could be other factors at play. This be-metalled person may well be surrounded by people in their social circles where body piercing & extreme hairstyles are the norm. What we see as normal is very much influenced by what our peers think of as normal, even if the wider society we are in does not think of our clan’s actions as normal. You see this with each generation of youth (I’m thinking about 10 years) who have cohorts wearing daft things or take on mannerisms most of us regards as bizarre. Like trouser around your bum hole being held up by one hand whilst shuffling forward swaying from side to side. But in their world it is cool & normal and either not strange or being “strangely cool” to follow that trend. {With that particular fashion I could only see it being very inconvenient, limiting in movement and likely to lead to high washing machine use and constant danger of falling on your face, but ho-hum}. It also struck me that the detractor might have been looking for an opening to just talk about it as they were themselves a closet furry – though their demeanour was one of utter derision.

When I was in college there were various groups: The Goths; the small number of punks; the heavy metal crew (or crews, some groups seemed to really dislike other groups); the desperately dull & miserable “Smiths” fans; emos were just starting; and by far the largest group, the “I’m different” group. All of them striving to be individuals and yet all so very much the same. They were the ones with the face metal, wild hair, grungy clothes and extremely dismissive attitude. I often thought I was a member of the smallest, most exclusive club, the “normals”. No fashion sense {or care}, no desire for a tattoo, boring hair. Oh, I’m sorry, I was a nerd even then 🙂

The thing is, everyone is not-normal in some way. Not always as obviously as in the cases I have talked about above, where it is defined by attire, adornment or alteration. But if you spend time talking to and getting to know someone there is always something not-normal there. Almost none of us are 3rd normal form.

It took me a long, long time to realise this and be less scathing of people who do permanent physical things to themselves on a whim (I just do not understand why you would have tattoos or major body piercing where it is “for life” unless you do something almost as extreme to put things back). My saying “on a whim” is itself scathing and shows a lack of appreciation why people do such things. OK, it is not for me but that’s simply my opinion, it’s wrong of me to make a judgement call on people who make a different decision on these things. After all my utter lack of fashion sense or willingness to improve/change my looks will strike some people as very odd.

So, if someone looks different, they look different. And if it is a different you have never seen before (ie actually, honestly, really different) they could be a very interesting person to talk to. Or they could be not, you don’t know. But if you have changed any aspect of your own appearance, be it a tattoo, a chunk of iron-carbon-chromium through soft tissue, a pair of raccoon ears or just dying your hair, then they are fundamentally the same as you. And if they look normal. Well, there really are very few real “normal” people. Their not-normal is yet to be discovered. Now you have to chat to them to find it.

How much are a pair of raccoon ears? I might get a pair and a tail for the next UKOUG conference.

Gary Larson, making the complete, exact opposite to my point :-)

Gary Larson, making the complete, exact opposite to my point 🙂

Friday Philosophy – Your Experience can Keep You Ignorant November 18, 2016

Posted by mwidlake in Friday Philosophy, Knowledge, Perceptions, performance, SQL.
Tags: , , , ,
12 comments

This week I was in an excellent presentation by Kerry Osborne about Outlines, SQL profiles, SQL patches and SQL Baselines. I’ve used three of those features in anger but when I looked at SQL Patches I just could not understand why you would use them – they looked to me like a very limited version of SQL Profiles.

There is a prize for spotting Kerry without a baseball cap

There is a prize for spotting Kerry without a baseball cap

So I asked Kerry about it during his presentation (he had been encouraging us to ask questions and I was curious). The answer? They are almost identical in how they are used and the impact they have but, yes, they are more limited. You can only enter one line of hints (I think it can be more than one hint but I have not checked {update, see comment by Jonathan Lewis – it is 500 characters of hints you can add, so you can comprehensively hint most statements}) with a SQL Patch. But, and this is the crucial bit, they can be used without the tuning pack and can be used on Standard Edition. Which makes them very useful if you are limited to using a version of SE or have not paid for the extra cost tuning pack option on Enterprise Edition. Kerry told me the first part about no cost and Kamil Stawiarski the part about being available on SE.

That’s a really useful thing to know. Why did I not know it? Because nearly all my experience of performance work has been for clients who have Oracle Enterprise Edition and the tuning pack. Most companies who are willing to hire someone to do Oracle Performance work have paid for Oracle Enterprise Edition and usually for many of the options. A company who is saving money by having SE is far less likely to have the money to hire external consultants (more the pity, as I would really like to spend time working for smaller companies where you can usually get more done!)

My experience, or rather lack of it, had blinded me to the possible uses of an Oracle performance feature. I wonder how much other stuff I don’t know or appreciate about an area I claim to be knowledgeable and skilled in – because my experience is mostly for clients with a very full Oracle tool set? How true is this in all sorts of areas of my technical and personal life? Quite a lot I suspect. That can be a little dis-spiriting.

But mulling this over later that evening (with beer of course) four things occurred to me:

  • If someone claims skills in an area but does not know things you do, it could well be simply down to their personal experience to date. It does not mean you know more, it means you know different stuff.
  • How much does someone have to not know before you decide they are not the expert they claim?
  • Do we partial experts keep ourselves slightly ignorant by not asking questions – as we fear that second point?
  • I felt I did the right thing in asking a question about something I felt I should know – but did not. As now I know the answer (and two people at least got to show they know more than me).

I know I have said this before, as many others have. The more you know, the more you realise what you do not know. You just have to keep asking and remember that, we are all ignorant about something until someone tells us about it.

Top and Tailing Bulgaria. November 9, 2016

Posted by mwidlake in conference, Meeting notes, Presenting.
Tags: , ,
add a comment

Tomorrow I head off to Bulgaria for the BGOUG Autumn Conference 2016. I’ve only been to the Bulgarian user group once before, having heard from so many people what a fantastic user group conference it was – and they were right. Milena Gerova and her team do an amazing job of organising it and make everyone feel really welcome. So I am really looking forward to my return.

Bryn always gets a good crowd but this was typical for  Bulgaria (sorry it's blurry)

Bryn always gets a good crowd but this was typical for Bulgaria (sorry it’s blurry)

In one of those strange quirks of fate, I’m “opening” the conference and also “closing” it. I.e. my first session is in the first slot on the first day and my last is, well, the last slot on the last day. In between I’ll be enjoying the other talks, doing a third session myself and trying to avoid repeating the “6am with the crazy Ukrainians” experience of last time!

Having the first slot on the first day is just perfect for the session I am doing “The heart of Oracle – How the Core RDBMS Works”. A while back I realised that there are a lot of experienced and highly capable Oracle practitioners who do not actually know some of the basics of how the database software works {if I look in the mirror I see one of them}. That is, why redo is so important, what goes into the redo stream, that all table and index data is accessed via blocks (until you get to that fancy engineered systems stuff) and it is blocks that go into the SGA buffer ache, what a consistent get is or how Oracle finds a block of data in memory. That last one I had no clue about until about 6 years ago, I had made some stupid assumptions.

When you discover these things or tell someone about them, a common response is “Oh! That makes so many things make more sense! I wish I had known that from the start…”. So this talk tells people about these things and, though it understandable by anyone who has only got as far as writing their first SELECT statement and was originally aimed at those new to Oracle, most experienced people take something new from it that helps make all those more detailed talks make sense. It really suits all levels. Thus having it at the start of the conference will hopefully help give them a better understanding of the core framework of the Oracle RDBMS into which knowledge of specific areas can slot into.

The location in Pravets is lovely

The location in Pravets is lovely

The final session is equally suitable for everyone. Which is good as it is the only session available at that time! It is a “Discussion Over Beers About Oracle Database” – beers are available to all. It’s a fun and relaxed way to round off the event, with questions coming from the audience. I loved the session last year and this time I’m up on the panel. Bryn Llewellyn was sniping from the audience last year (as only Bryn can) so they are doing what you should do with any troublemaker, which is to put them in charge :-). So Bryn is also on the panel, along with Joze Senegacnik and Tim Hall.

Sometime in between those two bookends I’ll do my talk on clustering data for better SQL and overall database performance but more importantly I’ll be listening to many of the other great talks. I’ve looked over the agenda and I know I will have the complaint common in any conference with good contents – more than one talk I want to see at most points in the day. Thankfully, having been a bit of a conference tart this last few months, I have seen some of them already which makes my decision making easier.

Traditional Dancing is a Traditional Entertainment (and my shot is traditionally blurry!)

Traditional Dancing is a Traditional Entertainment (and my shot is traditionally blurry!)

Another thing I am looking forward to is enjoying the hospitality & entertainment that BGOUG is so famous for. The conference is in a hotel that is not that near many other things, which could be a problem. But the organisers make sure that we are entertained in the evening and the food last year was great. This made even better by spending time talking with the delegates and other speakers in the evening. Last year I was struck by how engaged the audience was during sessions and how enthusiastic they were to learn & share outside of them.

Just like The Polish user group conference I went to in October, BGOUG has the three things a great conference needs: Excellent presentations; good organisation; an engaged audience. For some people there, this will be their 10th or 20th time (or even more) at the BGOUG conference. Nothing says more than that.

From Forms to DB v12.2 via Ask Tom, the Real World Performance Team, & The Optimizer Lady – UKOUG TECH16 next month November 7, 2016

Posted by mwidlake in conference, UKOUG, User Groups.
Tags: , ,
2 comments

In just under 1 month the annual UKOUG conferences are happening – Tech16, Apps16 and JDE16

screenhunter_124-nov-07-13-05

All three run from Monday the 5th December through to Wednesday the 7th in the centre of Birmingham, at the International Conference Centre – and if you are registered for the main conference you can register for free for Super Sunday the day before the main conference kicks off. Places on Super Sunday are limited and are allocated on a first come first served basis.

{I do not usually sat this but -this post is my opinion, not sanctioned by UKOUG. I may do a lot for the UKOUG but I’m just a volunteer not a member of the board or employee}.

I’ve been coming to the UKOUG Tech conference for pretty much the whole of this century. I think I started in 2002 and I have only missed one year since then and I come for the whole event every time. Why am I so keen to make it to this particular conference? Because it has a huge breadth of technical content and the UKOUG is independent of Oracle – that last point is vital and some people do not realise that UKOUG is an independent user group. They are not financially supported by Oracle and they can put on whatever talks they want to. I like to think we have a mutually beneficial relationship with Oracle but it is not a marriage!

As a result of that independence we (and I can & should say “we” as I am involved in organising the conference) do not have to follow the current sales and marketing direction of Oracle Corporation. If you have seen any Oracle marketing activity over the last 2 years you would have picked up on a slight “cloud” bias from them. If you went to Oracle Open World 16 then you would have had 5 days of being force-fed cloud, cloud and more cloud. Cloud is going to save the world it would seem.

Only Cloud is not everything. Many companies that use Oracle are not going to cloud-based systems yet, some have no interest in cloud offerings and though only a fool would ignore Cloud, most technicians are here and now still mostly dealing with traditional services that are hosted somewhere on your premises.

So what do we have at Tech16? Up to 14 concurrent sessions running through each day. Have a look at the agenda here. There are 3 or 4 database streams on each day, at least two streams covering development and pretty much 3, at least one whole stream dedicated to Systems (including engineered solutions like Exadata), Big Data and Business Analytics, plus other streams on each day.

The 12.2 version of the database is out. But it isn’t. It’s in the cloud but it is not in OTN to download. So where exactly is it? Even now, that is not clear and Oracle Corp is not helping to make it clear. But it will be at the conference. We have talks on 12.2, what is in it, what is new. So if you want to know the latest, you will be able to get a lot of information about it at UKOUG Tech16. It’s not 100% clear if it will just be called “next generation” or not. After all, when it is generally available maybe Oracle will call it something else. I’m hoping for Oracle Twelveteen.

A complaint I hear from people over and over again every year is that there is nearly always 2 or more talks of interest at any time, for almost any point in the conference. Whilst I sympathise with how annoying that is, what this indicates is that we get so many excellent talks submitted to the conference that we are able to pick only good ones :-).

This is not to say we get the scheduling totally right. With so many streams, with each delegate’s sphere of interest being different and with the juggling that happens as some speakers have to ask for slot changes or pull out (stuff happens, sometimes a speaker cannot make the event no matter how much they would like to), the ball is occasionally dropped and talks on very similar topics occur at the same time that would have been better spread apart. If this happens, please let one of the organising staff know so we can track how often we get it wrong and learn for next year. (But please, don’t shout at anyone – a lot of people put a lot of effort into this).

As for the content, it is across the board. We have talks on Forms as we realised is was a missing area and is still used by lots and lots of people. We have our introductory pathways that are explained in the conference brochure – a recommended itinerary of talks for people new to that area of tech. We had deep dive stuff for the ner… very technical people. And we have some of the best speakers in the business plus the official word from Oracle. Connor McDonald is doing the Database keynote and a couple of other sessions and the other half of “Ask Tom”, Chris Saxon, is presenting too – and both will be taking questions. “SQL Maria” Colgan will be talking about in-memory and the Real World performance team is represented by the evergreen Graham Wood. I know I’ve concentrated there in the DB part of the conference but it’s the area I know best and the one the majority of you looking at this blog will be interested in.

This did not happen at one of the socials. You did not see this

This did not happen at one of the socials. You did not see this

There is another reason I come to the conference (overlooking the slight issue that as I help organise it I am not going to miss it!) which is the social side. Other conferences have social events that secretly we at the UKOUG are envious of – but the larger you get the harder it is to organise special events but we try to ensure there is plenty of stuff going on after the talks. We make sure there are a couple of events each evening that we can all get together at – Exhibition Drinks, Community Drinks and the Tuesday party. Drinking is not obligatory but meeting people is!

Or this - move along, nothing to see

Or this – move along, nothing to see

I go to UKOUG TechXX for the content. I stay up until late for the social. If you have never been before and you have the opportunity, well I’ve been coming along for 13 or 14 years. I must think it’s worth it.