Search

Top 60 Oracle Blogs

Recent comments

April 2014

Centering Squarespace Buttons

Centering just one call to action button is easily done in Squarespace. But
what if you have multiple buttons, and you want them in a row and centered
as a group. That's a harder task, and I...



Read the full post at www.gennick.com/database.

Centering Squarespace Buttons

Centering just one call to action button is easily done in Squarespace. But
what if you have multiple buttons, and you want them in a row and centered
as a group. That's a harder task, and I...



Read the full post at www.gennick.com/database.

Closing Out Collaborate 2014

Well. It’s the end to yet another Collaborate. It’s been fun. I’m thankful to IOUG for accepting my submission, “Optimizing Database Network Protocols,” which covered the basics of networking, the OSI model, Oracle/MySQL protocols, and their optimization. Likewise, after such a long hiatus, it was great to see a few of my Collaborate cronies, such as […]

The Amazing Spider-Man 2

I’ve just got back from watching The Amazing Spider-Man 2.

Wow, that is one seriously long film! At 2 hours and 22 minutes, it’s a good 1 hour and 22 minutes too long…

I guess there are two sides to this film:

  1. Action Scenes: During the action this films it is brilliant. Really over the top stuff. Bright, flashy and really cool.
  2. Everything Else : I don’t give a crap about character development in an action film. This re-imagining of the franchise is turning out to be even more whiny than the Toby Maguire version.

The film really could have been edited down massively and I would have come out agreeing with the film title. As it was, it’s “The Amazingly Long and Whiny Spider-Man Too!”

Cheers

Tim…

Running scripts in CDBs and PDBs in Oracle Database 12c

You’ve been sold on the whole concept of the multitenant option in Oracle 12c and you are launching full steam ahead. Your first database gets upgraded and converted to a PDB, so you start testing your shell scripts and bang! Broken! Your company uses CRON and shell scripting all over the place and the multitenant architecture has just gone and broken the lot in one fell swoop! I think this will end up being a big shock to many people.

Coincindences

I had another of those odd timing events today that make me think that Larry Ellison has access to a time machine. I found (yet another example of a) bug that had been reported on MoS just a few days before it appeared on an instance I was running. How is it possible that someone keeps doing things that I’m doing, but just a few days before I do them !

For no good reason I happened to browse through a load of background trace files on an 11.2.0.4 instance and found the following in an “m000″ file:

REPVFY Diagnostics, Part I of…Well, A Zillion

There are a number of Verification Utilities for Enterprise Manager 12c, (EM12c) and I’ve written about them before, but today I’m going to start on the Repository Verification Utility, (REPVFY).  This will be an ongoing series, as there are so many valuable features rolled into the utility and new ones that will b

Bitmap loading

Everyone “knows” that bitmap indexes are a disaster (compared to B-tree indexes) when it comes to DML. But at an event I spoke at recently someone made the point that they had observed that their data loading operations were faster when the table being loaded had bitmap indexes on it than when it had the equivalent B-tree indexes in place.

There’s a good reason why this can be the case.  No prizes for working out what it is – and I’ll supply an answer in a couple of days time.  (Hint – it may also be the reason why Oracle doesn’t use bitmap indexes to avoid the “foreign key locking” problem).

Answer

As Martin (comment 3) points out, there’s a lot of interesting information in the statistics once you start doing the experiment. So here’s some demonstration code, first we create a table with one of two possible indexes:

Automatically Add License Protection and Obfuscation to PL/SQL

Yesterday we released the new version 2.0 of our product PFCLObfuscate . This is a tool that allows you to automatically protect the intellectual property in your PL/SQL code (your design secrets) using obfuscation and now in version 2.0 we....[Read More]

Posted by Pete On 17/04/14 At 03:56 PM

OSP #3a: Build a Standard Cluster Platform

This is the fifth article in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

We’ve looked in some depth at the process of defining a standard platform with an eye toward Oracle database use cases. Before moving on, it would be worthwhile to briefly touch on clustering.