Search

Top 60 Oracle Blogs

Recent comments

August 2015

(X)Query OPatch Information From The Database

There are cool posts out there regarding querying the OPatch info in Oracle 12 which…

A couple of up-coming user group meetings

There are a couple of user group meetings in the UK that I’ll be attending (and talking at) in September.

On the 15th September I’ll be presenting at the UKOUG Database Server SIG in the Oracle London City office, talking about PL/SQL & SQL performance. I’m not exactly sure what I’ll be covering yet, I have a few areas I’d like to talk about so I’ll have to pick one to do it justice. The meeting starts at 09:30 and is of course free to anyone with UKOUG membership (excepting the Bronze membership which only a few people have) – anyone can pay a small fee to come along. Contact the UKOUG or ask me if you want details. I’m pretty sure there will be some of us in a nearby public house after the event too.

Oracle 12.1.0.2.x – JSON Database Patch Bundle(s)

It has been a while I patched a local development database, but nowadays stuff gets…

Emulating a Raspberry Pi on Virtualbox

So I’m working on a lot of posts for Enterprise Manager, but I can’t post them just yet, so here’s some more Raspberry Pi love to keep you busy until then… :)

PeteWhoDidNotTweet returns from the dead!

If you attempted to get to PeteWhoDidNotTweet over the past few days, you would have noticed it was down. The reason for that is I finally found the time to do something that I’ve wanted to do for some time – perform a major update of the entire website.

A few weeks back, I finally managed to get on a WordPress course (WordPress is the software that the site runs on, of course). I had been booked to attend the course last year, but then some pesky customer work got in the way as higher priority, and it has taken me a long time to be able to reschedule the course.

Index Usage

The question of how to identify indexes that could be dropped re-appeared (yet again) on the OTN database forum last week. It’s not really surprising that it recurs so regularly – the problem isn’t an easy one to solve but new (and even less new) users keep hoping that there’s a quick and easy solution.

There are, however, strategies and pointers that can help you to optimise the trade-off between effort, risk, and reward. Broadly the idea is to spend a small amount of effort finding a relatively small number of “expensive” indexes that might be safe to drop, so that when you do the detailed analysis you have a good chance that the time spent will be rewarded by a positive result.

Before we get to some results posted on OTN, it’s worth thinking about the global impact and what we’re trying to achieve, and the threats that go with our attempt to achieve it.

MobaXterm 8.1

MobaXtermcommand-prompt 8.1 has been released.

The downloads and changelog are in the usual places.

If you are a Windows user and you use SSH and X Emulation, you need this in your life!

Cheers

Tim…

KeePass 2.30

KeePass 2.30 was released about a week ago. This passed me by as I was distracted with the whole tour thing. :)

The downloads and changelog are in the usual placed.

You can read how I use KeePass (Windows & Linux) and KeePassX2 (Mac) here.

Cheers

Tim…

Loading file data … easier than you think

So a request comes in from a colleague…

”Hi Connor.  I’ve created this new table, and I need to populate it with some data.  I’ve got it in Excel – can you help me load it”

Now, at this point, my heart normally sinks, because whilst the Oracle tools to load flat file data are comprehensive, I know that I now have to

  • go find out the table definition, column names and data types
  • write up a SQL Loader control file, or
  • write up an external table definition script
  • repeat this 10 times until I get the syntax right

all of which is going to be a drain on my time…

What I really would like, is to do this:

1) Check that my table is ready for loading

Hyper-Extended Oracle Performance Monitor 7.0 Beta

August 16, 2015 Three and a half years ago I offered the Hyper-Extended Oracle Performance 6.0 Beta for download – that Beta version expired a year later.  This program has been somewhat of a pet project for the last 13 years (almost 10 years at the time of the previous Beta offering), so I was […]