Daily Archives Tuesday, July 2008

Are you the only one who “gets it” at your company?

Do you have a vision for how technology can transform what your company or department does, but no one will listen?  Do you spend your day “evangelizing” the merits of social networking behind the firewall but finding it fall on deaf ears?  Do you find yourself explaining how a wiki works to everyone who emails you [...]

New OWB Product Roadmap on OTN

I’m not sure how much significance we should attach to it (in terms of it being new news), but there’s an updated product roadmap document for OWB now available on OTN. Apart from the details we all know about such as OBIEE support in the next release, ODI knowledge module support and so on, there’s [...]

I Know Nothing About Data Warehouse Appliances and Now, So Won’t You - Part III. Tuning Data Warehouse Appliances.

I spent a little time last night perusing Stuart Frost’s blog (CEO, DATAllegro) and learned something new. Microsoft, it appears, has ported Windows and SQL Server to platforms beyond x86, x86_64 and IA64. I quote:
Database vendors such as Oracle and Microsoft have to build their software to run on any hardware. Hence there are a [...]

OBIEE, Discoverer, Oracle OLAP and Essbase Users: Complete the BI Survey 8

It’s that time of year again when the next BI Survey starts collecting responses from BI users around the world. Now at the eight edition, the BI Survey is an independent survey and analysis of hundreds of BI tools users around the world. This year, the BI Survey team are particularly keen to get responses [...]

Getting Started With Informatica PowerCenter 8.1.1

In the previous postings in my Oracle BI Apps series, I’ve looked at the BI Apps architecture, installation and configuration, and performing the initial data load. As one of the key benefits of the BI Apps is its extensibility, one of the first things I’d want to know if I was a customer is exactly [...]

XML Goodness in SQL - Part 1

Here are some cool and useful things you can do with XML using pure SQL in an Oracle database.

HTTPURIType

The HTTPURIType provides support for the HTTP protocol. It uses the UTL_HTTP package underneath to access the HTTP URLs. With HTTPURIType, you can create objects that represent links to remote Web pages (or files) and retrieve those [...]

Advert - All India OUG

I’ve just been reading Log Buffer 103 from the Pythian Website, and noticed that the All India Oracle User Group is holding their first ever technical event on Friday 18th July in Hyderabad. Since I won’t be able to attend, I thought I’d offer my support by advertising it here.
[...]

Oracle Open World is getting close!

LewisC’s An Expert’s Guide To Oracle Technology

September is just around the corner. If you’re going to OOW this year, I would suggest you get registered now and get a hotel. Last year there were more than 45000 attendees. I wonder what the estimate is for this year? With BEA in the mix, I would guess well over 5

hope for the future

So there I was this morning sitting on the tube (UK underground rail system) when a young student got on an sat down beside me. Obviously being both English and a commuter I couldn’t possibly speak to her!, but I did sneak a look at what she was reading. These turned out to be the notes she had made on her course that she was now going over presumably in preparation for exams. The notes this morning were on normal forms, entity relationship and data modelling. 
 
So there we go, a young female student of IT would be pretty good in itself, the fact that she was studying relational theory was the icing on the cake. There is hope ladies and gentlemen, there is hope.  

Advanced Oracle Troubleshooting Guide, Part 7: Sampling latch holder statistics using LatchProf

I have been too busy since getting back from vacation, thus no posts for a while. But I hope the waiting was worthwhile as I present you LatchProf, a tool for digging in to latch contention problems - using plain SQL and sqlplus!
As, I’m still busy, I make it short.
LatchProf is a script similar to [...]