Twitter @gcolbran
Bikers Against E-Tolls SA
Author Archives: Gary
Alter session set events ’10231 trace name context forever, level 10′;
Used event 10231 today to recover data from a corrupt block. What does it actually mean to us ? Simply put, it’s asking oracle to ignore blocks which contain errors, meaning your query on a table will not fail and … Continue reading
Fixing corruption, oracle 10.2.
Client had an issue for the last month, and we investigated the cause of the problem. delete from OUR_TABLE where COLUMN2=1 and COLUMN_1NME=’DOBA07′ the error we are getting : ORA-08102: index key not found, obj# 87586, file 5, block 923994 … Continue reading
Posted in Corruption, Oracle, Uncategorized
Tagged BLOCK_CORRUPTION, corruption, dbms_repair, ORA-08102, oracle
Comments Off
Building a Date Dimension
During a POC recently, we required to build a Date Dimension. Given a list of dates, what is the sql to extract the day of the week for a given date value ?
Posted in Uncategorized
Comments Off
Can we have columns larger than 60K characters in Netezza?
Netezza has a couple of limitations regarding column and row length, being a column maximum of 64K and a row maximum of 65535K, not to mention the column limit of 1600 in a table. How can we store longer text … Continue reading
Obtaining Netezza table size information.
On Netezza, with a large loading process, you cannot see the size of the table growing expect with the nzadmin tool. However, there’s a means to know it is running.
eXelate
In this brief customer testimonial from the 2011 IBM Netezza Roadshow, Kevin Lyons, SVP of Analytics at eXelate, talks about how eXelate powers their scalable analytics platform using the IBM Netezza data warehouse appliance to turn billions of online records … Continue reading
Posted in Uncategorized
Tagged advanced analytics, analytics, audience segmentation, behavioral targeting, big data, Computer Software, Data Analytics Software, data exchange, data mining, data warehouse, data warehouse appliance, digital media, exelate, IIBM, Management System, marketing, Netezza, oracle, teradata, testimonial, trend reporting, weblog data
Comments Off
IBM Thinkpad wireless keeps turning off.
I found that the wireless LAN kept turning off on my IBM Levono laptop. Took a poke around to find where to disable this.
Posted in IBM, Software, Uncategorized
Tagged access connections, Disabled, laptop, network, wireless
Comments Off
Checking Block Used Space
A client want’s to know how to check block usage on an object to determine if it should be re-organised to save space. Here’s where I’ll use dbms_space.
Posted in 11g Release 2, dbms_metadata, dbms_redefinition, dbms_space, Oracle, Uncategorized
Tagged BLOCKS;, dbms_metadata, dbms_redefinition, dbms_space, free space, reorganise
Comments Off
Netezza CEO Jim Baum Out at IBM, On to New “Non-Competitive” Venture
Former Netezza chief executive Jim Baum has left IBM, Xconomy has learned. Baum was the CEO of Marlborough, MA-based Netezza since early 2009 and oversaw the “big data” analytics company’s $1.7 billion acquisition by IBM almost exactly a year ago. … Continue reading
