jump to navigation

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

Posted by mwidlake in off-topic.
Tags:
3 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 :-).

Advertisements

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!