-
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
-
My stuff at OpenWorld
Analytic Functions [UGF7455] Analytics have been with us since Oracle8i Database Release 2 (8.1.6), but they are still dramatically underused by application developers. This session looks at the syntax and usage of analytic functions and how they can supercharge your SQL skill set. SQL Tuning 101 [CON7457] It’s the age-old problem: the SQL statement… Read more
-
12c FETCH FIRST
Tom Kyte’s latest magazine article talks about the new FETCH FIRST syntax in 12c. You can read about that at: http://www.oracle.com/technetwork/issue-archive/2013/13-sep/o53asktom-1999186.html There’s a (quite valid) comment at the end of the article: “Note that in real life, you would use bind variables instead of hard-coded literals, so instead of using the number 5 as I… Read more
-
Insync 13 Brisbane
Just a quick note to let you know I’ll upload the slides in the next few days Read more
-
30 chars just not enough…
Sometimes even Oracle itself just can’t cope with the 30 character limit This from a M000 trace file 🙂 *** 2013-08-29 15:27:46.316 *** SESSION ID:(1020.7527) 2013-08-29 15:27:46.316 *** CLIENT ID:() 2013-08-29 15:27:46.316 *** SERVICE NAME:(SYS$BACKGROUND) 2013-08-29 15:27:46.316 *** MODULE NAME:(MMON_SLAVE) 2013-08-29 15:27:46.316 *** ACTION NAME:(Remote-Flush Slave Action) 2013-08-29 15:27:46.316 *** KEWROCISTMTEXEC – encountered error: (ORA-12899:… Read more
-
Compressed partitions are not compressed tables
So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then you read about using compression to make your older, static data faster and smaller and you thought … “Cool!” Let’s see that in action – first here is my uncompressed partition table SQL> create table… Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 