Skip navigation.

Tim Hall

Syndicate content
Oracle related rants (and lots of off-topic stuff)...
Updated: 8 hours 22 min ago

Video : Indexing JSON Data in Oracle Database 12c

Sun, 2016-05-22 03:25

Following on from last week’s post, today’s video is about indexing JSON data in Oracle Database 12c.

If videos aren’t your thing, you might want to read these articles, which the videos are based on.

The cameo in this video comes courtesy of Bertrand Drouvot, who was a silent extra in the previous video too. 

Oracle Midlands : Event #15 – Summary

Wed, 2016-05-18 02:46

Last night was Oracle Midlands Event #15 with Joel Goodman and Martin Widlake.

First up was Joel with a session called, “Oracle Storage Fragmentation”, where he discussed the potential fragmentation issues possible in tablespaces, tables and indexes. If you’ve been a DBA for a long time it’s easy to think everyone knows this stuff, but I get asked questions about this stuff a lot! The session had a good mix of content, with something to keep everyone happy from beginner to old timers. Joel is like a walking encyclopedia of Oracle, so it’s always good to hear him present.

Next up was Martin with a session called, “Performance of PL/SQL functions called from SQL”, where he discussed the pros and cons of calling PL/SQL functions from SQL statements. I like Martin’s presentation style. He’s very self-deprecating and amusing. Of course I am biased because he’s part of the family.

Video : JSON Support in Oracle Database 12c

Sat, 2016-05-14 08:58

Today’s video is a sprint through some of the JSON support in Oracle Database 12c.

If videos aren’t your thing, you might want to read these instead.

The cameo in this video comes courtesy of Yves Colin, who I’ll see again in a couple of weeks at the Paris Province Oracle Meetup. A couple of extras (Bertrand Drouvot and Osama Mustafa) wanted to get in on the act too.

Email, where art thou?

Sat, 2016-05-14 04:17

email-at-1020116_640Followers of the blog will know I’ve recently migrated the website to AWS. Yesterday I bit the bullet and cancelled my dedicated server.

As part of that process I had to move my email account from that service too. I always pull all my emails into Gmail, so there is no point paying for something cool. A little POP account is fine.

I started the process yesterday afternoon/evening, thinking it would be a quick drop on the old service and recreate on the new one. Unfortunately the old service held on to the domain reference overnight, so it was a quiet evening on the email front.

Oracle Midlands : Event #15

Wed, 2016-05-11 07:42

Don’t forget Oracle Midlands Event #15 next week!

om15

Please show your support and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…

Oracle Midlands : Event #15 was first posted on May 11, 2016 at 2:42 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

MobaXterm 9.0

Wed, 2016-05-11 07:21

Another recent release that I managed to miss was

KeePass 2.33

Tue, 2016-05-10 02:30

I just noticed KeePass 2.33 was released a couple of days ago. You can download it here.

You can read about how I use KeePass and KeePassX2 on my Mac, Windows and Android devices here.

Cheers

Tim…

KeePass 2.33 was first posted on May 10, 2016 at 9:30 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

A week in the cloud… (Just to clarify)

Tue, 2016-05-10 02:04

AWSA comment on yesterday’s post by Andy C makes me think I should clarify a couple of things I mentioned in yesterday’s post.

“Infrastructure as a Service (IaaS), not really what I consider the cloud.”

For *me* the definition of cloud must include some value-add in relation to ease of use. I’ve used IaaS on Azure, AWS and Oracle Cloud. In all cases I’m left to do the same administration stuff I had to when I was on a physical box or a VM on a local virtual machine. For *me* it only becomes cloud when I have Platform as a Service (PaaS) or Software as a Service (SaaS), where the administration is simplified greatly through tooling. IaaS is just another hosting provider. It’s not really cloud in *my* book. That’s not to say it’s not cool or useful. It’s just not cloud to *me*.

Notice the heavy use of *me* and *my*. This is not the law or even some text book definition. It’s just the way I feel about it, having used a number of hosting companies for business and personal use prior to “the cloud”. You are allowed to think differently, and certainly cloud providers do.

A week in the cloud…

Mon, 2016-05-09 03:42

cloudIt’s been just over a week since I moved my website over to “the cloud”. Well, an EC2 virtual machine on Amazon Web Services, so it’s Infrastructure as a Service (IaaS), not really what I consider the cloud.

Fixing broken links to Oracle documentation… Again…

Mon, 2016-05-09 02:59

Broken-LinkWith my recent website move I thought I better check for broken links, in case I had screwed anything up during the transfer. The last few times I’ve done this I’ve used SiteCrawl, which seems to do a decent job.

After the scan had finished I looked through the results and had a couple of broken internal links and 171 broken external links. Can you guess where the vast majority of the broken external links were pointing to? Yes, it was Oracle documentation. A quick search on my blog reveals about six rants I’ve posted about this over the years. There have been many more incidents of course.

Fixing this stuff is very time consuming and boring. What’s worse, it robs me of time I could spend on creating new content.

I’m guessing most content producers don’t go back and check for broken links. Oracle certainly don’t because I see them all the time in whitepapers, articles and forum entries. The result of this is a sea of helpful content produced by the community that are littered with broken links to Oracle content. It lowers the value of the community content, through no fault of the content producer.

Oracle. Please stop doing this! You are constantly devaluing the content produced by us in the community!

Cheers

Tim…

Update: You should probably read this by Kim Berg Hansen.

Fixing broken links to Oracle documentation… Again… was first posted on May 9, 2016 at 9:59 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

WordPress 4.5.2

Sat, 2016-05-07 03:45

I woke up to find all my WordPress installations had automatically updated to WordPress 4.5.2 overnight.

It’s a security release, so if it’s not already auto-updated for you, you might want to log into your dashboard and give it a nudge.

Video : Flashback Table

Mon, 2016-05-02 06:51

Today’s video gives a quick run through of flashback table.

If you prefer to read articles, rather than watch videos, you might be interested in these.

The clip in today’s video comes courtesy of Deiby Gómez, an Oracle ACE Director, OCM 11g & 12c and consultant at Pythian.

Cheers

Tim…

Video : Flashback Table was first posted on May 2, 2016 at 1:51 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Server Problem : A Resolution?

Fri, 2016-04-29 08:09

AWSIt’s been a pretty annoying couple of days on the website server front.

The server locking up intermittently is one thing, and for all I know, maybe my fault? The incompetence of the hosting company is quite something else.

Just so you are aware why I was doing my nut yesterday, the hosting company had disabled my ability to force a power cycle of my dedicated server while they did a hardware test. They forgot to re-enable it when they finished. I rang to ask them to re-enable it and also power cycle to server. It took them over 70 minutes to achieve the power cycle and it was the following day before the interface to allow me to force a power cycle was enabled again. Amateurs!

They offered to give me a free month of hosting, but I refused. Last night I moved the whole thing to Amazon Web Services so that’s the new home for the website. I finished the build and testing, then flipped the DNS and went to bed, figuring the DNS propagation can take up to 24 hours, so why hang around.

VirtualBox 5.0.20

Fri, 2016-04-29 07:32

It’s been 10-ish days since VirtualBox 5.0.18 was released and the world is screaming out, “Where is 5.0.20 already? We want to update all out Guest Additions!” Well, it’s here…

Server Problems : Update

Thu, 2016-04-28 01:08

hard-disk-42935_640This is a follow on from my server problems post from yesterday…

Regarding the general issue, misiaq came up with a great suggestion, which was to use watchdog. It’s not going to “fix” anything, but if I get a reboot when the general issue happens, that would be much better than having the server sit idle for 5 hours until I  wake up.

Server Problems : Any ideas?

Wed, 2016-04-27 02:54

I’m pretty sure last night’s problem was caused by a disk failure in the RAID array. The system is working now, but it might go down sometime today to get the disk replaced. Hopefully they won’t do what they did last time and wipe the bloody lot!

Please be patient!

Tue, 2016-04-26 01:46

angry-1300616_640It’s extremely nice to have a big audience. It’s very flattering that people care enough about what I say to be bothered to read it. The problem with having a large audience is people can get a very demanding at times.

Video : Flashback Version Query

Sat, 2016-04-23 09:15

Today’s video gives a quick run through of flashback version query.

If you prefer to read articles, rather than watch videos, you might be interested in these.

The star of today’s video is Tanel Poder. I was filming some other people, he saw something was going on, came across and struck a pose. I figured he knew what I was doing, but it’s pretty obvious from the outtake at the end of the video he was blissfully unaware, but wanted in on the action whatever it was! A true star!

Learning to answer questions for yourself!

Thu, 2016-04-21 00:56

notes-514998_640It’s not important that you know the answer. It’s important you know how to get the answer!

I’m pretty sure I’ve written this before, but I am constantly surprised by some of the questions that come my way. Not surprised that people don’t know the answer, but surprised they don’t know how to get the answer. The vast majority of the time someone asks me a question that I can’t answer off the top of my head, this is what I do in this order.

  1. Google their question, often using the subject line of their post or email. A lot of the time, the first couple of links will give me the answer. Sometimes it’s one of my articles that gives me the answer.

VirtualBox 5.0.18

Tue, 2016-04-19 08:22

VirtualBox 5.0.18 has been released.

The downloads and changelog are in the usual places.

So far I’ve only installed it on Windows 7, but I’ll no doubt be doing an install on OS X El Crapitan and Oracle Linux tonight.