September 2013 archive

Sep 27

Back from Open World 2013

I am back from Oracle Open World 2013. This was my first Open World conference. I knew it was big but I was still unprepared for the overall size. Approximately 60,000 people attended the conference. I really doubt that it is possible to take in all that the conference offers in one week’s time. There …

Continue reading »

Sep 20

Off to Open World

I am off to my first Open World. It should be exciting and fun.

Sep 17

12c Move Datafiles Online

Prior to Oracle 12c, if you wanted to move a database’s file, you either had to shutdown the database, or take the datafile/tablespace offline. Here is an example of the steps you might take: ALTER TABLESPACE my_ts OFFLINE; !mv /old_dir/my_ts01.dbf /new_dir/my_ts01.dbf ALTER DATABASE RENAME FILE ‘/old_dir/my_ts01.dbf’ TO ‘/old_dir/my_ts01.dbf’; ALTER TABLESPACE my_ts ONLINE; Now in Oracle …

Continue reading »

Sep 17

12c Adaptive Plans

I’ve been meaning to write something up on Oracle 12c’s new Adaptive Plans. When I do have poorly performing SQL statements, it seems that the issue is often due to bad optimizer stats. Recalculate the stats and performance is improved. I like the new 12c feature of Adaptive Plans where the database engine will reformulate …

Continue reading »

Sep 05

12c Data Redaction

Oracle 12c’s Advanced Security option now includes Data Redaction. This is a great way to secure your data , transparently to the application, from prying eyes. If an end user does not need the entire tax id, they can be presented with just the last four digits, as an example. To me, this is just …

Continue reading »

Sep 05

ORA-01097

Every once in a while, a person comes across something that has been around forever but is a new experience for them. Just today, I hit the ORA-1097 error for the first time in my career. I was in a test database and needed to shut it down. SQL> shutdown immediate ORA-01097: cannot shutdown while …

Continue reading »

Sep 04

Oracle 11.2.0.4 Released

I had a short vacation last week and while I was gone, Oracle released the 11.2.0.4 patchset. This is patch number 13390677. It seems that as soon as I get caught up, I have a new version to contend with. Some time ago, I was two weeks away from completing upgrades of all of our …

Continue reading »