Archive for October, 2011

I guess this may have a place if your application data is transient in nature and doesn’t need to be retained forever. We first take an existing table and for a given column family set its “time to live” to 30 seconds. According to the documentation, the cell will be removed after this time.... »

We upgraded our largest and most important databases last month to 11.2.0.2 from 10.2.0.4. We had a few issues, most of which have been resolved. However, one that continued to plague us until yesterday is the apparent inability of any version of the Oracle JDBC drivers to utilize runtime connection load balancing. For those... »

The PL/SQL compiler warnings have been enhanced in 11.2.0.1 and up to include a warning for the dreaded “when others then null” exception handler. Actually, the warning is raised any time an “others” is handled (even if it is logged somewhere), and not re-raised. See below for an example. 1 2 3 4 5... »

I use what is below to periodically gather what the load balancing advisory posts. The data reflects the percentage of connections to distribute to each instance for a given service in a RAC. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21... »

Nothing fancy today, this is just a placeholder for using object types as a column in a table. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 SQL> CREATE type mytype AS object (p_name varchar2(20),p_age number); 2 /   SQL> CREATE... »

In Oracle 10.2.0.4, we were doing a large data migration of archive records. Initially, we could recreate the data from the source, so our plan was to: copy rows nologging to destination database backup destination database truncate tables in the source database The tables have LOB columns in them, and we found that with... »