If you read my postings on XML Publisher 5.5 towards the end of last year (here [http://www.rittman.net/archives/2005/12/more_on_xml_publisher.html],here [http://www.rittman.net/archives/2005/12/wrapping_up_on_xml_publisher.html]), or sat through the "XML Publisher

I know I saidI wouldn't answer any more questions send directly [http://www.rittman.net/archives/2006/02/question_time.html] as opposed to via theforum [http://www.rittman.net/forum], but this one was too good to pass on. > "Hello, Mark. I am searching for

In part two [https://www.rittmanmead.com/blog/2006/02/28/hunting-deadlocks-part-2/], I mentioned that large files could take tens of seconds to process and the processing of a file is wrapped into a single transaction that either fails or succeeds. I also said this problem seemed

I never like finding why a deadlock happens, all too often the solution is embedded in the application code where some error in logic has caused multiple sessions to do things in different orders. The text of the error message provided by Oracle implies “heap all blame at the developers’

Occasionally, just occasionally, I am asked to leave my sane, safe data warehouse world (OK, not many DBAs out there would agree with that) and take a look at some other systems. For the past couple of days I have been looking at ‘deadlock’ problems on a legacy application and

I don't know if anyone else has come across it yet, butJonathan Lewis [http://www.jlcomp.demon.co.uk/] has recorded apodcast for DBAZine [http://www.dbazine.com/podcasts/podcast-lewis]. It talks about Jonathan's new book, the type of work he does as a consultant,

Keith Laker [http://oraclebi.blogspot.com/] from the Oracle Business Intelligence product team dropped me a line this evening, to tell me about a survey the Data Warehouse Development team at Oracle are carrying out. It sounds like a useful and interesting survey and I'll certainly be taking

And relax... Just finished the second of my twoDesktop Conference 2006 [http://www.desktopconference2006.org/]presentations, this time on Oracle OLAP Best Practices. There were more technical problems as the start again, just as I was about to start I was asked to move to a different conference ID (i.

Well I've just finished my first presentation for the Desktop Virtual Conference 2006 [http://www.rittman.net/archives/2006/02/looking_forward_to_the_desktop.html], on XML Publisher. It was a bit strange presenting it actually, there's no feedback during the session from the audience

"Faster Batch Processing" [http://www.oracle.com/technology/oramag/oracle/06-mar/o26performance.html] : " When you need to load millions of rows of data into a table, the most efficient way is usually to use an INSERT, UPDATE, or MERGE statement to process your data in bulk.

I've finished the presentations now for theDesktop Conference 2006 [http://desktopconference2006.org/node/36]next week; the one on XML Publisher is the one that I gave the other week at the UKOUG BIRT SIG (with the addition of a XML Publisher Desktop demo), whilst the OLAP Best

I've had a few questions through recently, and rather than answer them directly via email, I thought I'd publish them here. Going into the future, I'll only be answering questions that get posted to the forum (http://www.rittman.net/forum), as it makes

Just a couple of updates. If you found the article last week on Oracle OLAP memory management useful, Chris Chiappa sent an email through to me this evening with some clarifications and corrections. I've annotated the article with Chris' comments and you canread the updated version here

I went to see a new customer last week who was looking to put together a company MIS system. The system needed to load and transform some data prior to analyzing it using OracleBI Discoverer, and to do the transformation they were looking at using OracleBI Warehouse Builder, and a

A couple of days ago I downloaded the new release of JDeveloper. Although I had been playing with the Early Adopter version for some while I wanted to see how the official release looked. I had already recommended it to my Java developers and wanted to make sure my opinion

Due to a dropped internet connection this entry was duplicated to here [http://pjs-random.blogspot.com/2006/02/some-days-developer-in-me-emerges-and_09.html] So this one is edited to history, and the more recent one stands. If only because Niall added a comment on the

When you work with the OLAP functionality in Oracle Database 10g, you need to be aware of how it handles memory. Just like a relational data warehouse, data held in multidimensional datatypes makes use of memory structures such as the System Global Area [http://download-uk.oracle.com/docs/cd/

Just a quick one. If you came to theUKOUG BIRT SIG last week [http://www.rittman.net/archives/2006/01/ukoug_business_intelligence_re.html], and want to get hold of the Excel-based tool/sample Kevin showed us that creates calculated measures en-masse, it's now available

I've just had two of my presentations accepted for the ODTUG Kaleidoscope 2006 [http://www.odtug.com/2006_Conference/2006_conference_HOME.htm] conference in Washington D.C. next June. The first presentation I'll be doing is the "Oracle XML Publisher - What's It

I've just had two of my presentations accepted for theODTUG Kaleidoscope 2006 [http://www.odtug.com/2006_Conference/2006_conference_HOME.htm] conference in Washington D.C. next June. The first presentation I'll be doing is the"Oracle XML Publisher - What's It All