Friday, July 6th, 2007 by Borkur Steingrimsson
This one doesn’t quite relate to BI, but here is a function I hadn’t seen before: new_time . This function accepts three arguments: A date, the timezone this date should be considered in, and the timezone you want the return value to be in. This can come in handy in some situations, but there [...]
Saturday, April 21st, 2007 by Borkur Steingrimsson
Seems that the Oracle Forums have finally come to their senses and allowed changing the watch/notification email address. Hurray for them! I have had the same email addy stuck in there since I signed up back in 2000. I haven’t had access to the mailbox in 4 years by now.
So, now I can at least [...]
Monday, November 7th, 2005 by Peter Scott
One of our customers has asked us to review the performance of one of their legacy data warehouses. The daily data load takes far too long. There seems to be a lot we can suggest here to improve things – for a start, we need move to an incremental load and not the complete reload [...]
Wednesday, September 28th, 2005 by Peter Scott
An anonymous poster to Tom Kyte’s Blog shared a tale of woe about data warehouse performance. Well, I felt for that poster – how can a developer put their hand on their heart (or wallet, if they are an external consultant) and say in effect “design does not matter, the database will be able [...]
