Category Archives: Oracle

On my way to NZOUG…

Today is the day I fly to New Zealand to present at the NZOUG conference.
I got to the airport 2 hours before the flight as usual, but I’ve been here 3 hours already and I’ve still not boarded the plane. I have a long wait at Dubai, so this delay shouldn’t affect my connection. It’s 7 [...]

DBMS_PARALLEL_EXECUTE…

I’ve been having a play around with the DBMS_PARALLEL_EXECUTE package introduced in 11gR2. It seems pretty neat, but I can’t help thinking the suggested usage (updating large tables) would probably be better done with a table redefinition or CTAS.
It’s worth knowing about though.
Cheers
Tim…

Becoming Steven Feuerstein…

Boneist just informed me that links from my site to my Oracle ACE profile were linking through to Steven Feuerstein’s profile.
Here’s the link I’ve always used for this profile. It’s been on my blog, website and forum for years and worked just fine when I’ve clicked the links in the past.
http://apex.oracle.com/pls/otn/f?p=19297:4:3351497719856466::NO:4:P4_ID:43
If you click [...]

Let me search the Oracle documentation for you!

You sometimes get questions that are easily answered by a Google search, so you give people a link to lmgtfy.com, like this.
http://lmgtfy.com/?q=Oracle+11gR2
As a homage to lmgtfy.com I’ve created a documentation search.
http://www.oracle-base.com/search/
If you specify your search it gives you a URL you can pass to others. When they use the URL it shows them what they [...]

Data Guard Setup using Oracle Grid Control

Just a point-and-click guide to Data Guard setup using Grid Control.

Oracle Database 11g Release 2 Data Guard Setup using Oracle Grid Control

Cheers
Tim…

Red Hat heading for Oracle buyout?

I know it’s been said before, but I read this and thought, once Red Hat’s market value starts to drop Oracle could get a really good deal.
I thought the reference to the quality of Red Hat’s support was quite comical. I’ve always found their support to be terrible. To be more specific, you raise a [...]

Real DBAs use Grid Control…

Hopefully the title got your attention. Of course it could have read, “Real Linux Sysadmins use Cobbler and Puppet…”, or any number of comparable statements and products. The point being, there is a gradual evolution in the way we approach tasks and if we don’t move with them we marginalize ourselves to the point where [...]

Grid Control (10.2.0.5) on OEL 4.8 x86_64…

I recently managed to screw up my Grid Control VM, so I was forced to reinstall it. I’d not written an article on it since 10gR2, as I’ve just been applying patches since then. Faced with a new install I decided to go x86_64 and do clean install direct to 10gR5.

Oracle 10g Release 5 Grid [...]

Oracle Database File System (DBFS) PL/SQL APIs…

My previous article discussed the DBFS. This article gives an overview of the PL/SQL APIs for managing and interacting with the DBFS.

Oracle Database File System (DBFS) PL/SQL APIs

There’s a lot in there, so this is just skimming the surface.
Cheers
Tim…

Oracle Database File System (DBFS) in 11gR2…

I’ve been having a play with the DBFS functionality in 11gR2.

Oracle Database File System (DBFS) in Oracle Database 11g Release 2

For the most part it is extremely simple. If you are working on Linux then it’s a really neat solution. On any other platform you are limited to using the dbfs_client tool, which is currently [...]