In an effort to knock out some loose ends, I finally took my OCP upgrade test (1Z0-055) from 9i to 11g. It was tough, but I did pretty well on it. So as I start to look for ways to find more work with Big Data and open source software…I get my Oracle certification upgraded. Confused? Me too. Just one of those things that I needed to knock off of my plate.
See next post for more Oracle news (involves Hadoop!)
I’ve been enslaved by RDBMS’s for too long. Keep an eye out for some interesting posts about Hadoop (Hive, HBase) and other Big Data platforms. I’ve recently obtained my CCAH (Cloudera Certified Administrator of Apache Hadoop) after a 3 day training course and I’ve also been cheating on Oracle with MongoDB. Plan on seeing interesting articles and some how-tos in the coming weeks. Right now, I’m stuffing as much data as I can into my Hadoop cluster at home and in the more distant future, I’ll be learning R and pulling some fancy charts and graphs from it.
Looking for some data to feed your demo Hadoop cluster? Interested in pulling some awesome lists and stats about music? Here’s a great set of data for you. Full details at the link below.
via The Echo Nest Taste Profile Subset Million Song Dataset.
Run this:
SELECT b.TABLESPACE,
b.segfile#,
b.segblk#,
ROUND ( ( (b.blocks * p.VALUE) / 1024 / 1024), 2) size_mb,
a.SID,
a.serial#,
a.username,
a.osuser,
a.program,
a.status
FROM v$session a,
v$sort_usage b,
v$process c,
v$parameter p
WHERE p.NAME = ‘db_block_size’
AND a.saddr = b.session_addr
AND a.paddr = c.addr
ORDER BY b.TABLESPACE,
b.segfile#,
b.segblk#,
b.blocks;