I put out a post yesterday called The Future of PL/SQL : My Opinion.
For an Oracle-related blog, putting something out at the weekend is a sure fire way to get nobody reading it. If I look at my website, the hit rate at the weekend is about 1/5 of that of a week day. By the time most people get back to work on Monday they have a stack of blog posts to read and yours will probably fall into the “mark as read” pit of their RSS reader. In a similar fashion, people’s timelines on social media are generally so crowded, your “look what I’ve just written” tweet will probably be lost amongst the talk of alcohol, bad food and photos of the kids…
In case you hadn’t noticed it, partitioning has finally reached clusters in 12c – specifically 126.96.36.199. They’re limited to hash clusters with range partitioning, but it may be enough to encourage more people to use the technology. Here’s a simple example of the syntax:
Although a lot of my effort at the moment is focused on DBA features, I have written some articles on PL/SQL enhancements. There are a few neat new features for PL/SQL developers in 12c, but you could be forgiven for thinking it is a little underwhelming. There are two ways to look at this:
From a base language perspective, I think option 2 is closer to the mark. PL/SQL is a really stable, fast and mature language. There really isn’t very much that you can’t do with PL/SQL these days. So what is the future of PL/SQL in my opinion?
This may not come up very often, but for some reason, an administrator might have to reconfigure an EM12c environment to NOT use load balancers.
This could be due to:
“Hurd’n’Catz” – I’ve always liked Larry, and especially in the old unscripted public discussions of technology. The best one I was at was at the Fairmont in 1994, but I’m biased because I was the MC. Larry and Ron Wohl were on hand for a general question and answer session instead of having a keynote talk at a particularly robust OAUG conference. After a few questions from the audience it turned into a snappy debate between Ron and Larry about how the future of some pretty doggone important things to the entire audience were going to go. I barely had to egg them on. It was real and it was useful. I think Larry was genuinely disappointed we had to stop when it was time for the vendor sponsored cocktail reception. I wish Larry well and I would not begrudge him for a second letting go of pain in the butt day to day control.
When: Mon-Tue, 29-30 September, 08:30 – 17:00 PDT
Ever since I was asked to improve the throughput of an actual general ledger posting job involving Oracle in December 1993 on some hardware where solid state disk (SSD) was available (at high cost relative to “spinning rust” or hard disk drives [HDD]), I have been trying to explain the overall advantage of placing different types of the different Oracle storage selectively on SSD.
When FLASH SSD arrived on the scene, studies quickly arose that writing to FLASH SSD is often not as fast as writing to disk drives dedicated to receiving those writes.
Today I’ll try to explain why I don’t care.
While there was some advantage to writing to SSD in my tests (which were to RAM based SSD on a VAX), the write speed to online REDO was not a significant part of the advantage of placing online REDO on SSD.
A recent question on the OTN database forum raised the topic of returning free space in a tablespace to the operating system by rebuilding objects to fill the gaps near the start of files and leave the empty space at the ends of files so that the files could be resized downwards.
This isn’t a process that you’re likely to need frequently, but I have written a couple of notes about it, including a sample query to produce a map of the free and used space in a tablespace. While reading the thread, though, it crossed my mind that recent versions of Oracle introduced a feature that can reduce the amount of work needed to get the job done, so I thought I’d demonstrate the point here.
Yet again the monster that is Oracle Open World is about to take over San Francisco. I won’t be making it this year, but considering we had something like 60,000 attendees last year I’d hate to see what the numbers are gonna be this year!
To try and make it a little easier for you to find all the Private Cloud and Lifecycle Management with EM12c material, here are the ones I know about. If you know of any I’ve missed, feel free to add them in the comments field below! Note that this is only the Private Cloud and Lifecycle Management material – the complete master list of all EM material can be found in the master Focus On EM12c document.