Andrew's Oracle Blog

If you have some PL/SQL, Oracle allows you to include commit statements between a begin and end . Assuming this is appropriate for your ap...

Oracle started allowing sessions with space issues to hang rather than fail in version 9. I had always assumed this only worked if a tablesp...

I have often wondered how auditors crack Oracle passwords, particularly if the user concerned has a profile which locks the account after ...

Oracle apparently introduced list partitioning in Oracle 9. I decided to try it out in an Oracle 11 database. In this simple example I creat...

I was reading an old Oracle 9 performance tuning book (as you do) and it said that you could not do online rebuilds of bitmap indexes. I did...