Learning is not a spectator sport

Inappropriate behaviour

You pick up little funny things in the day to day with Oracle. Like this one when you try to

I’m sitting here watching the import of a moderately sized database via transportable tablespaces. You know…the thing you use when

We had an interesting issue on 12.1.0.1, where users were reporting very slow performance on queries to external tables. When

Anyone that has ever coded PLSQL will be familiar with the error ORA-4068, where you had some state persisted in

Just curious if anyone else is seeing this behaviour.. SQL> set long 500000 SQL> @pt “select * from v$sql where

The annual two day AUSOUG conference in Perth is well underway, and so far, its been a wonderfully successful event.

Its not immediately obvious the significance of this query…but trust me…you’ll love it 🙂 SQL> select table_name, column_name from dba_tab_cols

Well, the annual spectacle of enormous proportions has come to a conclusion again. And thats probably the first reason I’d

Thanks to anyone that came along to my sessions at OpenWorld. You can review the slides via the links below: