-
Oracle Developer Day Perth
Well…it was a great day with over 100 people attending. I had the standard fail of trying to show people 200 things that I think are important, in a time allowing only for 50 things, but better to be overfed than starving 🙂 Links to the slides are below. Thanks everyone for coming – hope Read more
-
Free developer day in Perth
Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your enthusiasm. There’s something for database developers Apex developers ADF developers See you all there … http://bit.ly/oddperth20140218 Read more
-
ORA-65131 grrrr
So…the future is container databases ? Cool ! I’ll create all my databases as container databases….I’m so happy….until SQL> CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH; CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH * ERROR at line 1: ORA-65131: The feature Flashback Data Archive is not supported in a pluggable database. Read more
-
Man…I really really like this 🙂
Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c… 11.2 SQL> grant resource, connect to demo identified by demo; Grant succeeded. SQL> select privilege 2 from dba_sys_privs 3 where grantee = ‘DEMO’; PRIVILEGE —————————————- UNLIMITED TABLESPACE 12.1 SQL> grant resource, connect to demo identified by Read more
-
The challenge of optimization
With every release of Oracle, more and more power comes to the optimizer. Many of these are new features (such as adaptive cursor sharing, adaptive optimization, dynamic sampling, etc)…but also within the “core” of the optimizer, there are continuing efforts to transform and interrogate SQL’s to try derive a ‘smarter’ query and hence hopefully a Read more
-
Cloning databases
My friend Kyle wrote a blog piece a while back http://www.kylehailey.com/what-delphix-does-in-1-minute-22-seconds/ Now, not to criticise Delphix (in fact,the opposite – its a very very cool product, and you should read some of Kyle’s great blog content on it), but if you have not got it, or can’t get it, then as long as you have Read more
-
number of set bits
declare n number := ….; tmp number; begin tmp := n – ( bitand ((n / 2) ,3681400539)) – (bitand ((n / 4) ,1227133513)); tmp := mod ( bitand ((tmp + (tmp / 8)) , 3340530119) , 63 ); dbms_output.put_line(tmp); end; Google for “hakmem” to see how it works Read more
-
The cost of Oracle
It’s not uncommon for people on one hand to expound the functionality, performance and features of Oracle, whilst on the other hand, lament the potential high cost of the product. I’m not pontificating here – I’m commonly one of these people. So much good stuff in Oracle….yet so much to pay to get that good Read more
-
Once you’ve done your I/O…there’s still more to do !
The world is obsessed with I/O nowadays…. This is understandable – we’re in the middle of a pioneering period for I/O – flash, SSD, MLC, SLC, with ever more sophisticated transport mechanisms – infiniband, and the like. But don’t forget, that once you get those blocks back to Oracle, you need to “consume” them, ie, Read more
-
A good day…
I work for a company that provides betting to consumers in Australia… In Australia, the three biggest days for betting are typically: Melbourne Cup (horse race) Caulfield Cup (horse race) AFL grand final (sports) Yesterday was the Caulfield Cup and we breezed through it…always a nice result. Because if we dont we lose lots of Read more
-
Thoughts from OpenWorld
The amazing coordination of so many things: – feeding 60,000 delegates goes off without a hitch. The food is not spectacular, but its also not terrible. – the Ace program. Flights, hotels, transport, etc, all miraculously fall into place due to the effort of Vikki and Lillian. San Francisco – What an amazing place to Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 