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…
Month: October 2011
Runtime connection load balancing issues in 11.2.0.2
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…
11g compiler warnings
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…
Querying load balancing information from the Load Balancing Advisory
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. #!/home/oracle/local/bin/python import cx_Oracle, string conn = cx_Oracle.connect(mode…
Simple example of a type stored in a table
Nothing fancy today, this is just a placeholder for using object types as a column in a table. SQL> create type mytype as object (p_name varchar2(20),p_age number); 2 / SQL> create table type_table(c mytype); Table created. SQL> insert into type_table…
Disabling LOGGING on a LOB
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…