Learning is not a spectator sport

Complete listing of posts

  • Really dumb triggers

    Some people hate triggers, some people love triggers… I am not that opinionated on them in either direction, but one thing I do hate, whether it be a trigger or not, is dumb code. And today’s post just happens to be about dumb code in a trigger. Consider this simple trigger (you see these everywhere… Read more

  • An accusatory error message

    I found this hilarious SQL> startup ORACLE instance started. Total System Global Area 1469792256 bytes Fixed Size 2402776 bytes Variable Size 536872488 bytes Database Buffers 922746880 bytes Redo Buffers 7770112 bytes Database mounted. ORA-19821: an intentionally corrupt log file was found Really ? I intentionally corrupted my log file ? I dont think so !… Read more

  • SQL injection

    Another big public username and password leak… http://o.canada.com/technology/bell-canada-security-breach-391451/ Some good reading on how it was done, and thus ensuring your code isn’t prone to SQL injection here: http://www.troyhunt.com/2014/02/heres-how-bell-was-hacked-sql-injection.html Read more

  • Pluggable database and restricted sessions

    Once you get into pluggable database territory, you might need to check your usage of “alter system enable restricted session”, because unless you’ve patched, there’s a little bug which lets you enable restricted session, but wont let you get out of it ! 🙂 For example: SQL> alter session set container = pdb12; Session altered.… Read more

  • OUGN 2014

    I had the pleasure of being a guest of the Norwegian User Group for the second year in a row on their famous cruise conference at the start of April. For a relatively ‘small’ conference (around 300-400 people), the array of quality speakers the group manage to get is always astounding.  Martin Nash, Cary Millsap,… Read more

  • Norway bound

    I cant wait to get to Norway again for this year’s OUGN conference. If you’re in Europe…this should be on your must-attend list every year. It’s awesome fun. I’ll be talking about Clone DB, Optimizer Stats and Analystics in SQL http://ougnvarseminar2014.sched.org/ Read more

  • views in 12c

    Observed an interesting idiosyncracy in the creation of views in 12c (this is in a pluggable database, but not confirmed whether this is related or not). This database was upgraded from 11.2 without incident…until we came to replace one of the existing views. SQL> create or replace 2 view EXISTING_VIEW_NAME 3 as select * from… Read more

  • 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