-
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this incredibly precious thing, and as a consequence, one should always keep the amount of uncommitted changes in the database to a small size. Personally I think that is baloney (Ed-in reality, as an Australian I Read more
-
PIVOT does not work with materialized view refresh
We had an AskTOM question come in recently where our customer was very excited about the PIVOT operator in SQL which lets you transpose rows to columns. This is a very common requirement in applications that want to take data that has been modelled in “pure” relational form, and present in a more “human-digestible” form. Read more
-
All the OpenWorld 2019 downloads!
Why dig around for hours in the catalog? Here are all of the downloads registered in the OpenWorld catalog! You can pick and choose from the list below, or if you want a CURL script that will download the entire set, you can find that here. Enjoy! BOF1167 Java on Azure BOF,Reza Rahman BOF1321 Why Read more
-
Then OpenWorld mega-list
You’ve been to OpenWorld… You’ve seen the great content… Networked with the community… But now you want to keep the ball rolling and catch up with the speakers on twitter. So here is the mega-twitter list…all the speakers from OpenWorld and CodeOne that provided their twitter handles at registration. Enjoy! Abhinav Shroff https://twitter.com/abhinavshroff Ahmad Gohar Read more
-
Extending in-lists past the 1000 item barrier
A well known “limitation” of Oracle is that you can only have 1000 elements within an IN-LIST style expression in your SQL predicates. I use the quotes because I’ve always found that if you are heading into the territory where you need more than 1000 items in an IN-LIST, then it is often indicative of Read more
-
Speaker info for Perth, Australia
I have just got back from the Groundbreakers Latin America tour, and the travelling was made so much easier with the information provided by the organizers. So with the APAC tour coming up, I felt duty bound to give some hopefully useful information about my home town in Perth. Flying in/out There are two airport Read more
-
My OpenWorld!
Just a couple of weeks away, and my oh my, I am going to be busy at OpenWorld this year! Of course, first cab off the block will be the OpenWorld swim! It it September and marvellously warm in San Fran, so what better year to come along and meet new friends, and get free Read more
-
A new use for DML error logging
Many moons ago I did a short video on the DML error logging feature in Oracle. The feature has been around for many years now, and is a great tool for capturing errors during a large load without losing all of the rows that successfully loaded. You can watch that video below if you’re new Read more
-
DDL invalidates your SQL right ?
I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first before proceeding. But I wanted to show a simple demo of how management of cursors continues to improve with each version of the database. Throughout the many years and versions of using Oracle, a common Read more
-
No more stale statistics in 19c
There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the business day. Here is how that contradiction comes to be – it is in the way that we obtain and use optimizer statistics on those databases. The contradiction runs like this: To minimize service disruption, Read more
-
Plugzilla! A pluggable cloning utility
Cloning a pluggable database takes time, and for environments where you’d like to use clones as part of unit testing, or other elements of Agile development, it would be nice to be able to bring a clone into operation in the smallest time possible. One mechanism for that is sparse storage clones aka snapshot copy, Read more
-
Autonomous Transaction Processing – your slice of the pie
I grabbed the following screen shot from a slide deck I’ve been giving about Autonomous Transaction Processing (ATP). It shows the services that are made available to you once you create your database. At first glance, it looks like we have a simple tier, where the lower in the tier you are, the smaller the Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 