Another Oracle OpenWorld is behind us (when did it become October?) and as usual, it was fun to catch up with the members of my Oracle developer community, my ODTUG buddies and fellow ACEs. Cloud was definitely the hot topic on everyone’s mind this year, especially because Oracle announced their upcoming Oracle Mobile Cloud Services and released their Oracle Developer Cloud Service to production a few weeks before the (more...)
I missed most of the total but enjoyed the crescent of the partial eclipse re-emerging. It's amazing how distinct the shadow leading to the penumbra.
My friend said there will be some good shots in tomorrow's paper. I laughed and said here in the 21st (more...)
It’s that wonderful time of year again – no, not talking about springtime, when I’m stalked by airborne grass pollens causing me to choke and gag all day. The sound of a lawnmower is enough to elicit a sneezing fit – and in Aussie springtime, that’s most weekends. (I’m so glad my wife does the mowing at our place, usually while I’m at work. My son is now old enough to do the mowing – (more...)
I think, it is as important as ever to follow best practices for server-side development. There are lots of options that could get the job done "now", but very few that would survive for months/years. Also, there is a constant pressure from various "alternative" solutions to (more...)
- Log File Sync: ist das Event, auf das User-Sessions warten, die ein Commit abgesetzt haben, das vom LWGR verarbeitet werden soll.
- Log File Parallel Write: ist das Event auf das der LWGR (more...)
Today celebrates one year of the database design quiz on the PL/SQL Challenge!
Here’s a look back at some of the stats for the quiz to date with some trivia related to the numbers :)
select count(*) from quizzes; COUNT(*) -------- 52 -- The number of white keys on a piano -- the smallest number with 4 representations -- as the sum of 4 positive squares select count(*) from (more...)
- http://jonathanlewis.wordpress.com/2014/09/19/shrink-tablespace-2/: weist darauf hin, dass es in aktuellen Releases sinnvoll ist, zugehörige Indizes vor einer Move-Operation einer Tabelle als unusable zu markieren, da die Segmente in diesem Fall sofort gelöscht werden (nach der Move-Operation findet diese Löschung ohnehin statt, da die Index-rowid-Referenzen durch die Bewegung der Tabelle unbrauchbar werden). Diese Löschung erlaubt dann die Tabelle "weiter vorn" im (more...)
|Idioms - the bane of ESL speakers?|
Reading Anton's comment on a Friday afternoon got me a little too excited - upon reading it again Tuesday (we had a long weekend) I realised it was tongue in cheek.
So instead I went to Twitter to find what's being said at Oracle Open World about #orclapex. Turns out there will be a third early adopter - (more...)
Businesses all over the world have spent millions and millions building data warehouses and implementing Business Intelligence (BI) without coming anywhere near the promised business benefits.
That is about the change.
And the thing that will change this is interactive, visual analytics on tablets.
Tablets and modern interactive graphics are a match made in heaven. Business users who will reluctantly spend half an hour looking at a BI report will happily spend hours playing around (more...)
My session on "Oracle 12c for Developers" is done.Afterwards someone asks the question:
What happens when you use DBMS_REDACT with a complete row update?My guess was that it would place the redacted data in the column, but I haven't tried it, so here goes:
create table emp
,to_char (abs (dbms_random.random)) credit_card
(object_schema => 'A'
,object_name => 'EMP'
,policy_name => 'Hide Creditcard'
These techniques aim to be useful as well as fun to learn for (more...)
The big annual Oracle event is almost here – starting Sunday 28 Sep with the User Group Sunday followed by four days of presentations in around 50 tracks!
If the agenda seems a bit overwhelming, read the OTech Magazine Special OpenWorld Issue to find some of the highlights and can’t-miss sessions.
My sessions are:
- Mastering Oracle ADF Bindings: Advanced Techniques (UGF3484). Sunday Sep 28 at 10am in Moscone South room 270
- Starting Your Oracle Application (more...)
Apex 5.0 is going to be released in a couple of hoursIt's a long weekend here in Perth, and I have a footy grand final to watch - but no doubt I'll be installing it somewhere soon!
All that being said, apex.oracle.com is still on 4.2.5, so don't hold your breath for too long.
I’ve been setting up a simplified lab environment to let my students learn use in class. This added content will show them how to do reverse engineering with MySQL Workbench.
It’s a complete Fedora image with MySQL and Oracle Database 11g for the course. The uncompressed image is 14GB and the compressed image is 5.3GB. I chose Fedora because it’s the smallest open source image that supports both environments, and Fedora is the closest (more...)