Monthly Archives May 2008

Data Visualization Eye Candy

By way of Mashable, I give you another stunning and addictive data visualization, Tag Galaxy.
Based on the Flickr API, this Germany-based tool is simple to use. Start out by entering a tag, and you get a “galaxy” of related tags. Here’s the “oracle” galaxy:

Clicking on any planet drills further into the galaxy, refining your tag [...]

Resuming your ETL process in OWB

If your ETL process fails, for whatever reason, you have two options: to restart the process from the beginning, or to resume from the last successfully completed task.
Restarting from beginning
It is reasonable easy to restart the process in OWB, you would have to wait until your top level process flow has completed and then if [...]

Querying the current tracefile name, using SQL - with tracefile_identifier

Here’s a code snipped for identifying current tracefile name using SQL. Yep I know there are many such examples online, but I haven’t found any so far which also account for TRACEFILE_IDENTIFIER variable.
Luckily the value of this variable is accessible from V$PROCESS, so we can write a query which constructs us the full tracefile name, [...]

Into the wild: AdSense for feeds

We’ve been hinting at this for awhile, but it’s finally time to spill the beans: Starting next week, we’ll be rolling out AdSense for feeds to a small group of publishers, in anticipation of a full launch to all FeedBurner and AdSense publishers “coming soon”. If you start seeing “Ads by Google” on an ad in a feed somewhere, that’d be us.

So what will this mean for you? Well, publishers already in the FeedBurner Ad Network will continue to see premium CPM ads directly sold onto their content, but with the added bonus of contextually targeted ads that will fill up the remainder of their inventory. That means you get the best of both worlds: a dedicated Google sales force that knows how and why to sell onto your content, with the added revenue that full back-fill coverage provides. And with AdSense, you’ll know that your back-filled ads are using the strongest contextual ad engine, ensuring the most relevant and profitable ads are delivered to your subscribers. And yes, ads are also sold via Google’s AdWords program.

For publishers who are not yet placing ads in their feeds, any publisher who meets the requirements to join the AdSense program will also be able to use AdSense for feeds. You will be able to manage your feed ad units directly from AdSense Setup tab, and track performance right on the AdSense Report tab. You can slice, dice, mix, or mash your tracking across feed units and content units, or keep them totally separate. You’re in control. You can still control the frequency and rules around when ads appear in your feeds, without having to mess with templates on your content management system.

You might be wondering what you’ll need to do to use AdSense for feeds. You’ll learn more about the details when we fully launch, but here are the basics: you will need to sign up for AdSense if you haven’t already, and you will want to set up your AdSense channels for “placement targeting” in order to make sure that advertisers can target your syndicated content specifically. As a publisher, you will remain be in control of the campaigns that are targeted at your feed by harnessing the power of Ad Review Center.

And, this is just the beginning of the chocolaty goodness that will come from ongoing integration effort with Google - there are many more “things” and “stuff” yet to come, as we mentioned a few weeks back.

We’ll give you the full details on AdSense for feeds, including supported formats, how to sign up, etc., etc. when we’re ready for the full launch to all publishers. In the meantime, FeedBurner feeds will continue to be fed as usual, and we’ll be reaching out to select publishers individually to try out AdSense for feeds.

Oracle Troubleshooting with Snapper - detecting who’s causing excessive redo generation

My friend asked today a question that how to identify why his Oracle 9.2 database has suddenly started generating loads more redo than usual.
So obviously I recommended him Snapper as first thing, it’s perfect for ad-hoc analysis like that! ( I know I sound biased but if you haven’t used Snapper yet, then now is [...]

Hey Scott, where have you been ?

Today I missed Scott in my emp table. When selecting from EMP, Scott is not there. Gone…
Ok, let’s recreate the scott schema.
C:> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
SYS@lsc02> drop user scott cascade;
User dropped.
SYS@lsc02> @?/rdbms/admin/utlsampl
Disconnected from Oracle Database 10g Enterprise [...]

Opensocial with SSO for corporate users

We work in Oracle, and we “eat our dog food” to use the Oracle Single Sign On.  As we work towards providing Opensocial capabilities to our internal networking site (Connect), we find that Opensocial fits very well with SSO within the corporate domain.
So, how does SSO help opensocial apps?  Well, if the backend of the [...]

Nothing Changed

The following request appeared on the Oracle Forum a few days ago:
I have a select query
select col1,col2,col3 from table1 order by col1,col3
This table contains 4.5 million records initially and the select was returning records in less than 2 minutes .
This query has been running for the last year with out any issues, but from last [...]

Oracle and Football

Proper football, that is.

As a big fan of Dimitri’s World Cup 2006 Apex application, I’m looking forward to the Euro 2008 version. I had a couple of "bandwidth exceeded" messages earlier today but that’s not too surprising. Should be fun -)

What Utter Nonsense!

Well, perhaps not. There are grains of truth in here but they’re pretty hard to find and the hyperbolic tone deserves a hyperbolic reaction. Of course there are numerous such articles on the web, including the Oracle equivalent, but this one hits the limits of my patience.

http://www.rocket99.com/techref/8690.html

I think I need a lie down.