What is below is a simple java class to load the customers table we created in a previous post import java.util.*; import org.apache.hadoop.hbase.client.*; import org.apache.hadoop.hbase.util.*; public class putHbase { public static void main(String[] args) throws Exception { HTable hTable =…
Author: Steve
Bridging the gap…from SQL to No SQL
For any DBA’s that have had someone call them and ask “What do you know about NoSQL?”, this post is specifically intended. Before you have a conniption fit and began quoting Tom Kyte-ism’s (an exceptionally smart guy, if you do…
How to change LOB parameter on an XMLTYPE column
I couldn’t find this in the documentation, so I thought I would post it in case someone else has the same question. If you have an XMLTYPE datatpe column stored as a CLOB, you can modify attributes using the example…
Simple usage of a user profile to limit concurrent logins
We had an issue in a development database where a group of developers were not using a connection manager, but trying to manage their own connections. This did not end well. To limit our exposure and the impact on other…
Multiple threads using same physical connection
This just doesn’t sound good. Having multiple threads use the same physical connection sounds like an exercise in frustration. Although the OracleDataSource connection object is thread safe, there is really no need to create a smaller number of connections than…
Python row copier
Below is a script I wrote to copy a set of tables from one schema (or database) to another. It simply takes every table in the source schema and builds up an array based copy for it, with the usage…
Running procedures?
You can use what is below to print out each session that is currently executing (or has pinned) a given stored procedure column owner format a20 column name format a30 column type format a15 set lines 255 trims on SELECT…
How much can I shrink my datafile?
Periodically, we will need to shrink a datafile. In Oracle, you can only shrink a file to the point occupied by the “highest” block in the file. The SQL below will provide you with the SQL to execute for each…
Getting started with map reduce
Map Reduce is a computer technology algorithm that is built on the age old concept of functional programming. The goals of functional programming can be simplistically described as: every program returns a value “map” lists of values to functions Map…
MySQL mysqlbinlog vs. Oracle logmnr
MySQL provides the mysqlbinlog utility to parse binary transaction logs for any number of purposes which may include replication, auditing, or troubleshooting. Oracle also provides this functionality through a PL/SQL package called dbms_logmnr, more commonly referred to as “Log Miner”.…