Re: Storing XML application logs in the database

From: Nigel Thomas <>
Date: Wed, 27 Jan 2010 10:42:53 +0000
Message-ID: <>


If you want to understand some of the pros/cons of the different storage formats for XML, you can start by looking at Oracle ACE Marcus Gralike's posts at his blog See in particular the category Binary-, CLOB-, Object-Relational Storage <>.

One other point. If you make the application logs real XML rather than "XML like" (even if they contain some "free format" text elements) then you and your developers will have the freedom to query/transform them using *any *standard
XML tool (not just Oracle). For example, you'll be able to open the log with a browser, or with a tool like XMLSpy; you can use XSLT to process logs (eg to get out performance stats) without necessarily using the Oracle database. That will make the logs more useful/valuable in the long run.

Regards Nigel

Received on Wed Jan 27 2010 - 04:42:53 CST

Original text of this message