Search

Top 60 Oracle Blogs

Recent comments

February 2014

GITHUB_UTL Tutorial 6: Comparing database code with GitHub code.

In this tutorial I will show you how to compare live code with the code you have in your github repository. We can use tis to verify that what we have running in our database, is also what we have checked into our Git repository.

GITHUB_UTL Tutorial 6: Comparing database code with GitHub code.

In this tutorial I will show you how to compare live code with the code you have in your github repository. We can use tis to verify that what we have running in our database, is also what we have checked into our Git repository.

Full free day of performance class at Oracle Corp

This Thursday, Feb 20, I will be giving a full day of free Oracle performance classes.  Remember the serve the best lunch ever at the Oracle conference center . It’s top class!

Register here

Here is the write-up from NoCOUG on the day:

RAC and Pluggable Databases

In preparation of the OUGN Spring Seminar and to finally fulfill at least a part of my promise from July I was getting ready to research RAC, PDBs and services for my demos. It turned out to become a lot more interesting than I first assumed.

RAC and Multi-Tenancy

So the first attempt to really look at how this works has started with my 2 node cluster where I created a RAC database: RAC12C, administrator managed with instance RAC12C1 and RAC12C2. The database is registered in Clusterware. Clusterware and RDBMS are patched to the January PSU, i.e. 12.1.0.1.2.

Active Data Guard – what does it mean?

There are misconceptions and half-truths about that term that I see time after time again in forums, postings and comments.

Some people think that Active Data Guard is a fancy marketing term for Standby Databases in Oracle. Wrong, that is just plain Data Guard :-)

Most people think that Active Data Guard means that a Physical Standby Database can be used for queries while it is still applying redo. Not the whole truth, because that is just one featureReal-Time Query – which is included in the Active Data Guard option.

Active Data Guard is an option, coming with an extra charge. Active is supposed to indicate that you can use the standby database for production usage – it is not just waiting for the primary database to fail.

In 11g, Active Data Guard includes three features:

12c Enhanced Online Index DDL Operations (Lady Godiva’s Operation)

In my last couple of posts, I discussed how table partitions can be moved online since 12c, keeping all indexes in sync as part of the process. 12c also introduced enhancements to a number of index related DDL statements, removing blocking locks and making their use online and far less intrusive. The following commands now have a new ONLINE […]

Recursive subquery factoring

This is possibly my longest title to date – I try to keep them short enough to fit the right hand column of the blog without wrapping – but I couldn’t think of a good way to shorten it (Personally I prefer to use the expression CTE – common table expression – over “factored subquery” or “subquery factoring” or “with subquery”, and that would have achieved my goal, but might not have meant anything to most people.)

If you haven’t come across them before, recursive CTEs appeared in 11.2, are in the ANSI standard, and are (probably) viewed by Oracle as the strategic replacement for “connect by” queries. Here’s a simple (and silly) example:

GITHUB_UTL Tutorial 5: Selecting information from GitHub.

How do you use the GITHUB_UTL package to select information from your github.com account? You can use the github_tables package, which is basically a collection of pipelined functions that uses the rest of the api to get information out in a row based fashion.

In Memoriam

My placeholder page to remember him by, my eldest brother Guido, as he was: caring, an example, a human for humans, helping, sharing… Guido Bernardus...
class="readmore">Read More

GITHUB_UTL Tutorial 5: Selecting information from GitHub.

How do you use the GITHUB_UTL package to select information from your github.com account? You can use the github_tables package, which is basically a collection of pipelined functions that uses the rest of the api to get information out in a row based fashion. So fire up your sqlplus and login as the user that installed the github packages.