September 2013 archive

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

Off to Open World

I am After this period, acute phase is started generic tadalafil uk and the person starts feeling aroused after some time and then the penis achieves rock solid erection that provides better performance and pleasure increases. Nonarteritic anterior ischemic optic neuropathy (NAION) tadalafil cheapest online and other Drugs- possible interactionsThis medication should not be taken …

Continue reading

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

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

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

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

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