First of all, apologies for the long delay between posts. We've been evaluating various avenues for the cycle of hardware and software refresh in our data centres and for obvious reasons I could not make any public postings or comments that might be mis-interpreted by the various suppliers.
In these situations there is a confidentiality protocol that must be followed and simply cannot be broken.
I've said it before here and will say it again: the Oracle implementation of proxy logins is flawed from the start.
I've given at least one demonstration of why. And why using ALTER SESSION SET CURRENT_SCHEMA is a much more manageable and secure alternative.
Despite that, folks insist and persist on using proxies...
Consider Tom Kyte's article on the latest Oracle magazine, with the examples
Sorry for the marked absence of posts, folks. This year we've been upgrading all our Oracle dbs to 22.214.171.124 and all our MSSQL dbs to 2008R2 - hectic is an understatement for how things have been!
On top of that we've been told we may need to increase the size of our main Oracle dbs by 10X in the next 2 years. So, in the process of upgrading I had to ensure the groundwork for that sort of
The few who follow this blog know I don't at all like the way Oracle is slowly forcing customers to use the OCM and direct Oracle support links, for patching and upgrades.
It's very simple: our db servers are in an intranet, in a designated set of subnets that will N-E-V-E-R be open to anything past the DMZ. And even then only as the originators and to a known IP address.
This, I stress
Regular readers of this irregular blog will recall it's a loooong time since I had anything positive to say about Oracle and its marketing and support organization.Mind you: it's not a problem with the folks that man the fort at MOS - or whatever the blessed thing is called this week!In general I've found them competent and helpful and have actually recommended quite a few for service awards.
...that's been bugging me for a while, about time I blog about it.This post is mostly for my own reference. Although of course it might be useful for the odd budding dba out there who still believes the command line is a useful weapon in their armory.Yeah, they do exist! I'm one of them, thank you.So, have you been using sqlplus of late? And been bugged by the default Oracle data format we all
Finally worked out how to change the admin email ids in the blog!For some reason I never quite fathomed, Google took the wrong email id for admin of this blog when they took over Blogger. With the result that for quite a while I had to login with a different address than my usual gmail and/or yahoo to administer this blog.It's been a pain in the you-know-what to manage, with yet one more email
Back in 2008 my wish list included sparse object allocation (deferred allocation in Oracle's translation). And bingo, I got it in 11gr2! It was almost as if someone came here for inspiration!
Prior to that in my "No Moore" series I actually described the Exadata architecture, long before it became public.
Not that such a thing would ever be acknowledged by Oracle, we know that! After all, I
In the last 48 hours or so there have been two interesting events in the Oracle and IT front in Sydney.
First one was the Oracle Cloud Summit at the Sofitel Wentworth.
Like so many other marketing events it had its fair share of "ooh-aahh" stuff.
You know, the usual: "Exadata can finish work before it started", "Exalogic can finish it before it was thought out in the first place",
Been a long time since last post. It's been a busy period since the start of 2011.
Mostly because we are in a period of turmoil when apparently every man and his dog is trying to get into our site for "outsourcing". Even though that is most definitely not what we are doing. But never let reality interfere with a good dose of marketing...
We've seen a lot of "cloud computing" and SaaS