Oracle 23c Free : Why start learning now?

It’s been a couple of weeks since Oracle 23c Free was released. I’ve already put out a getting started post to help people start their journey, but I wanted to say something about why, in my opinion, you should start learning 23c now, rather than waiting.

Learning stuff takes time

I’ve written some tips about learning new things, and one of the posts was about time and repetition. It’s going to take a long time to get used to using 23c. If the latest version you have used is 19c, you’ve got the 21c and 23c new features to catch up on. If you’re using something older than 19c, then you’ve got even more to do. Sure, you can use Oracle 23c like it’s Oracle 7, and for the most part things will be fine, but really you should try and get the most out of the products you are paying for.

The sooner you start, the easier it will be, and the less rushed you will feel when you eventually have to start.

I’ve already put out a lot of 23c posts, but remember I’m on the 23c beta program, so I’ve been writing these posts for over 5 months now. They didn’t happen overnight.

Feeling comfortable with a new release takes me years. There is a difference between writing a post about something, and feeling comfortable using it in my day-to-day life. It will take some time before some of this stuff is a natural part of my toolbox. I want that to happen as quickly as possible, so that means getting stuck in now, so when the full blown 23c goes GA I can hit the ground running.

It might make you change the way you do things now

Sometimes, knowing what is coming around the corner will alter the way you approach a problem today. You may use the way Oracle has implemented a new feature as inspiration for how to solve your current problem in an older release. If possible, you may code it such that you can do a straight swap when you upgrade to 23c, throwing away your code and replacing it with built in functionality.

You don’t know what you don’t know

My initial reaction to new releases is often, “there’s nothing there I care about”. Then I start working through the new features and things jump out at me. The more I work with it, the more interesting it gets. I already feel like I can’t live without the IF [NOT] EXISTS DDL clause. On the surface it seems so trivial, but it makes a massive difference. 🙂

The Oracle 23c Free release contains mostly developer focused new features. We won’t see some of the administration features publicly until we get the full release, but there is still a lot to work through.

23c is new to everyone

I say this with each new release, but remember there are no Oracle 23c experts. Even Oracle staff and people in the beta program haven’t got something I would consider as significant production experience. Just remember this when you are reading posts about the 23c new features. We are all noobs! That doesn’t mean there is no value in these posts, but just remember what they represent.

It’s your choice

You are going to have to learn this stuff eventually, so you have two choices.

  • You can wait until the last minute, try to cram, and inevitably make mistakes when you are doing something real in your job.
  • You can start now and coast into the new release, so when you have to do something real with 23c, it’s not a problem.

It’s up to you, but you know what I think you should do. 🙂

Cheers

Tim…

As a DBA, what do I need to learn next?

Arup Nanda did a talk on Big Data as part of the OTN APAC Tour and one of the points he made was DBAs need to get involved in all this new tech or they will get left behind and be out of a job. Someone came up to me and asked me my opinion, basically saying, “What do I need to learn next?” That’s a very difficult question to answer for a number of reasons.

The DBA job continues to evolve and you need to evolve with it. A few years ago I was able to be an Oracle database specialist. Now I need to look after SQL Server and MySQL as well. I’m also expected to know about assorted application server and web server products, as well as operating systems etc. You can’t be a specialist at everything, so as a DBA we are now forced to be generalists. What’s more, most companies don’t really want a specialist anymore. They want someone that can turn their hand to anything. The role will almost certainly include some of these big data pieces as we move forward.

Do a bit of Googling and you will see the Hadoop ecosystem is huge. There are loads of pieces from loads of projects and they are all changing rapidly. The chances are, what you learned 2 years ago has been almost completely replaced now. This is often the case when something “new” comes to the forefront. Over time things evolve, some projects win and some projects lose. Eventually things stabilise and life gets a little easier. This is not to say you shouldn’t get involved now, but just remember it is a moving target. Everything you learn about it will be useful, but not necessarily exactly what you need for your next project.

I’m not a big data guy, so my opinion is rather uneducated, but following on from the previous points, it seems to me there is no such thing as a “big data expert”. You probably need to be a “big data generalist”, that doesn’t know everything about any of the pieces, but knows enough about each of them to string them together to do something useful. This is an important skill in itself.

As for me personally, my website is a reflection of one part of my work life. The Oracle bit. I have an ever growing to-do list that is mostly made up of Oracle stuff, but also includes big data, docker, IoT and …

It’s difficult enough to keep on top of the stuff you need for your day job, not to mention the new stuff needed to position yourself for the future. So when you ask me, “What do I need to learn next?”, I will probably answer, “When you find out, can you please tell me?” 🙂

Cheers

Tim…

Learning, Career Development and Mentoring

glasses-272399_1280-smallYesterday I received pretty much the same question from three different people, or maybe one person pretending to be three people. 🙂 The questions went something like this.

I want to get good at RAC. Will you teach me?

One of the three suggested I might want to use my Sundays teaching them. 🙂

I’m not mad at people for asking this and I don’t want to offend anyone by mentioning this, but it goes back to a recurring theme on this blog. Some people have a very passive approach to learning and want everything given to them on a plate. The education systems in some parts of the world actively encourage this model of learning. If there’s one thing I’ve learned over the years, it’s that people who have this passive approach to learning never get good at anything!

This links into another topic I have a strong opinion of, which is mentoring. I know some people are really into this and maybe I just don’t understand it properly, but I hate the idea of mentoring. I’ve seen it done several times and it seems to be more about blowing smoke up the arse of the mentor than helping the person being mentored. Maybe I’ve just witnessed bad examples of mentoring. If it is done badly, it perpetuates the passive approach to learning. The, “I don’t know what to do. Will you tell me?”, attitude.

I think it’s really important that people follow their own path and learn to learn for themselves. Part of that is making mistakes and learning from them. You will invariably gravitate to individuals that you look up to and inspire you, but it’s not up to them to guide you and you definitely shouldn’t try to turn yourself into a pale imitation of them.

Some of the most interesting and useful people I’ve met have come from non-science backgrounds, where free thought and creativity are encouraged. Bad science teaching, of which there is a lot, is prescriptive and discourages innovative thought in favour of learning facts.

Every time you feel you need help from someone regarding learning something new or career development, ask yourself the question, “Is there something I can I do about this?”, before you look for someone else to answer it for you.

Here are some related posts I’ve written over the years.

Like I said before, this is not about offending people. It’s about trying to encourage personal development, and of course, my opinion could be completely wrong from your standpoint, in which case I’m not the mentor for you. 🙂

Cheers

Tim…

Learn it or don’t. The choice is yours.

glasses-272399_1280-smallTechnology is scary for a lot of people, but the biggest problem I see out there is denial (It’s not just a river in Africa! 🙂 ).

Newbies

For people who are new to technology, the biggest problem I see is they refuse to actually read what is on the screen. I’m not talking about those stupid End User License Agreement (EULA) screens that nobody reads. I’m talking about basic instructions. If a screen says,

“Enter your username and password, then click the Login button.”

I don’t think that should be a taxing problem for anyone, but for the less computer literate, if something doesn’t go *exactly* as they expect, they go into total melt down. People just have to take a deep breath and read what is in front of them.

Techies

The situation is not always much different for many techies when they are faced with learning new skills. All those lessons you learned in your core skill-set seem to go out of the window. Things like:

  • Read the manuals.
  • Check the log files.
  • Check the vendor support website.
  • Google it.
  • Raise a support call.

Instead, people throw their toys out of the pram and decide the product/feature is rubbish and give up.

This is exactly what happened to me when I started playing with the Multitenant option. I was in total denial for ages. When I finally made the decision to sit down and figure it out it wasn’t so bad. It was just different to what I was used to.

Learning is not a spectator sport!

(Shameless use of the title of Connor McDonald’s blog, which is in itself credited to D. Blocher.)

Learning stuff is all about time. The optimizer fairy didn’t visit Jonathan Lewis one day and tell him “the secret”. If you don’t spend the time, or you give up at the first hurdle, you are never going to get anywhere. You will probably start to make excuses. I’m too old. It’s too complicated. I’ve always been rubbish at learning new stuff. I don’t have time. My company doesn’t support me. We won’t use it for another 3 years, so I’ll leave it until later. The list is endless.

Next time you are sitting in front of the TV watching some trash, ask yourself what those “smart kids” are doing at the moment?

I don’t care what you do with your life. Your choices are no more or less valid than mine. Just don’t fool yourself. Be honest. If you wanted to learn it you would. The fact you haven’t means you really can’t be bothered. 🙂

Cheers

Tim…

Learning to learn…

One of the things that disappoints me about all my time in education is that nobody actually taught me how to learn. Instead I had to stumble along, gradually trying to pick up what works for me. I guess I finally discovered how to learn during my PhD. What did I discover? That I learn in pretty much the same way as everyone else. Pity someone didn’t save me a few years and give me the heads-up a bit earlier. I read this quote from Dune recently,

“… because his first training was in how to learn. It’s shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult.”

It’s actually pretty simple to push stuff from your short term to long term memory. All you have to do is,

  1. Read/revise a subject. Make sure you get a good understanding of the basic principles and some of the important facts surrounding the subject.
  2. About 2-3 days after learning something new, run quickly through that subject again. You don’t have to slave over it. You just have to do a quick pass through to jog your memory.
  3. After about a week of the second pass, do a third pass through the information.

In doing this, you’ve taken a very big step toward transferring that knowledge from your short term memory to your long term memory. It’s simple, but it takes effort!

But that’s just facts right? Yes, but as you learn more stuff you start to notice patterns and build relationships between those items, which help you to draw conclusions that others see as leaps of faith or moments of inspiration. Those gurus you look up to aren’t any cleverer than you. They’ve just made all the same mistakes you did, but a few years before you!

Just some idle thoughts before bed…

Cheers

Tim…

PS. If you dislike formal approaches to learning, just offer to teach a class on a topic. If you are a conscientious teacher, you will make so many passes through the information before stepping in front of your students, it will be burnt into your brain forever. 🙂