Re: Storing XML application logs in the database
Date: Wed, 27 Jan 2010 10:42:53 +0000
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 www.liberidu.com. See in particular the category Binary-, CLOB-, Object-Relational Storage <http://www.liberidu.com/blog/?cat=23>.
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
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 NigelReceived on Wed Jan 27 2010 - 04:42:53 CST