Search

Top 60 Oracle Blogs

Recent comments

October 2015

Why I love working on AskTom

Today a question came in, and Swapnasis provided a nice simple test case, which makes my job so much easier.  Here’s a snippet from it


SQL> create table TTT(
  2    testid integer not null,
  3    value integer not null,
  4    time timestamp not null,
  5    unique(testid, time)
  6  );

Table created.

See line 5 ?

I’ve been working with Oracle for (well…I’d rather not say Smile) but lets just says “a number of years” dating back to version 6 of the database.  But in all of that time, I never knew that you could just write “unique”.  I have always done “constraint MY_CONSTRAINT unique (col1, col2)”.

PL/SQL Functions

Assuming everything else has been tuned to perfection, what’s the best you can do while calling PL/SQL functions from SQL ? Here’s a little code to create a table with some data, and a function that we can use to start an investigation:

IT operations made easier!

What kinds of things keep a IT ops person up at night?

What kinds of things make IT Ops people have to work over the weekends?

What keeps me up:

  • outages
  • performance problems
  • running out of disk space
  • corruption requiring recovery

These things are stressful.

One the most stressful things is recovering from corruption. Usually when there is a corruption, some important data and/or system is not accessible and won’t be until I recover the data. Now data recovery is not something I typically do everyday, so when I have to so it under pressure and using backups that probably haven’t even been tested for viability, then it’s a hugely stressful situation.

Characterset Changes

October 9, 2015 In 2006 I did a bit of experimentation with an Oracle characterset that supports Unicode (AL32UTF8 if I remember correctly) using Oracle Database 10.2.0.2.  That test, performed on a desktop computer with a bit less than 1GB of RDRAM (Rambus) memory, was a huge failure, and not just because the computer did not […]

Friday Philosophy – Be Moral or Be Sacked?

How far will you bend your moral stance to keep your job?

Advanced Oracle Troubleshooting v2.5 (with 12c stuff too)

It took a while (1.5 years since my last class – I’ve been busy!), but I am ready with my Advanced Oracle Troubleshooting training (version 2.5) that has plenty of updates, including some more modern DB kernel tracing & ASH stuff and of course Oracle 12c topics!

The online training will take place on 16-20 November & 14-18 December 2015 (Part 1 and Part 2).

The latest TOC is below:

Seminar registration details:

Advanced Oracle Troubleshooting v2.5 (with 12c stuff too)

It took a while (1.5 years since my last class – I’ve been busy!), but I am ready with my Advanced Oracle Troubleshooting training (version 2.5) that has plenty of updates, including some more modern DB kernel tracing & ASH stuff and of course Oracle 12c topics!
The online training will take place on 16-20 November & 14-18 December 2015 (Part 1 and Part 2).
The latest TOC is below:

Advanced Oracle Troubleshooting v2.5 (with 12c stuff too)

It took a while (1.5 years since my last class – I’ve been busy!), but I am ready with my Advanced Oracle Troubleshooting training (version 2.5) that has plenty of updates, including some more modern DB kernel tracing & ASH stuff and of course Oracle 12c topics!
The online training will take place on 16-20 November & 14-18 December 2015 (Part 1 and Part 2).
The latest TOC is below:

My sessions at OpenWorld 2015

OpenWorld is just around the corner, and I’m thrilled to be there again this year – it’s my first year as an Oracle employee, so it will be interesting to compare and contrast with previous years as an Ace Director.  I’ve got three conference sessions – I hope you can be there, and please feel free to come up and say “Hi”.

Click here if you’re using Schedule Builder, or just make a note of the details below

 

image

Indianapolis, ECO, IOUG and Oracle Education Foundation, Ohm My!

I’ve been a bit busy traveling and speaking, but I wanted to discuss the great events I’ve been lucky enough to be part of the last couple weeks.