Search

Top 60 Oracle Blogs

Recent comments

September 2014

The Future of PL/SQL : My Opinion

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:

  1. OMG. Oracle really don’t care about PL/SQL any more. If they did, there would be loads of new features.
  2. Wow. PL/SQL is so mature and cool that there is really not much more to add.

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?

Site Hosting Update : Two Months Down the Line

About two months ago I moved my website between servers within the same hosting company. The old service was being hammered, so I moved to a better dedicated server blah, blah, blah. There was some fallout from this, mostly focussed on lost emails, but I figured it was pretty much over.

Yesterday I received two emails from totally separate people asking why I was blocking their company proxies from accessing my website. I wasn’t. One of the guys got his company to do “something” to their proxy (squid) and they were able to access my site again. The other is waiting for his network folks to check their proxy.

That incident prompted this quick post, just to let people know how things are…

The website is available from these URLs.

How to Configure EM12c to NOT Use Load Balancers

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:

Oracle OpenWorld 2014 – Bloggers Meetup

class="l-submain">
class="l-submain-h g-html i-cf">

Oracle OpenWorld Bloggers Meetup Guess what? You all know that it’s coming, when it’s coming and where… That’s right! The Annual Oracle Bloggers Meetup, one of your top favourite events of OpenWorld, is happening at usual place and time.

What: Oracle Bloggers Meetup 2014

When: Wed, 1-Oct-2014, 5:30pm

Oracle Open World: Oaktable speakers at Delphix booth

Screen Shot 2014-09-19 at 2.16.51 PM

#222222;" border="0" width="600" cellspacing="0" cellpadding="0" align="left">

#bd2027;">#800000;">
Planning to attend Oracle OpenWorld this year? 

#6e6e6e;">#888888;">If so, stop by to visit Delphix at booth 821 and hear from Oracle industry luminaries such as Jonathan Lewis, Tim Gorman, Kyle Hailey, Ben Prusinski and the Oracle Alchemist, Steve Karam.

New Oracle CEOs “Hurd ‘n’ Catz”: This should be great

“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.

Back to technology: Is it effective to place Oracle REDO on SSD?

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.

Shrink Tablespace

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.

Login with Safari does not work anymore

Hi SCN team,

once again SCN is not working properly with Safari (Version 6.0.5 (7536.30.1)).

 

The browser keeps loading or is frozen, if i try to login on SCN (without certificate and "remember" password). I click on http://scn.sap.com/thread/login.jspa and then it is redirected to https://accounts.sap.com/saml2/idp/sso/accounts.sap.com?... and that's it.

 

Nothing more is happening. It works pretty well, if i try the same with Firefox 23.0.1 for example. Pretty annoying, that Safari seems not be tested at all by implementing changes or whatever.