Tag: linkedin

April 17

Although it isn’t (absolute) science, it has been a little bit over two years since I enabled Google Analitics. Just to see were I was regarding Gardner trends and if my XMLDB nerd mindset had any chance in the real world…

For those who are interested, hereby some small impressions…

Totals for this website

Click the picture to enlarge

Read the Post WebStats and the Oracle XMLDB Market?

March 25

I don’t know what it is today, but reading Tanel’s post about “Oracle 11g: Reading alert log via SQL“, I just wanted to see if I could manage to do it backwards.

In principle you don’t have to use the statements below, because I noticed that the DBMS_SYSTEM.KSDWRT will do it for you automatically.

The content of my Oracle 11g log.xml file is as follows

 <msg TIME='2008-11-24T21:10:48.265+01:00' org_id='oracle' comp_id='rdbms'
 msg_id='opistr_real:887:3971575317' TYPE='NOTIFICATION' GROUP='startup'
 level='16' host_id='14-317-818' host_addr='10.10.10.103'
 pid='2188' version='1'>
 <txt>Starting ORACLE instance (normal)
 </txt>
</msg>
<msg TIME='2008-11-24T21:10:48.312+01:00' org_id='oracle' comp_id='rdbms'
 msg_id='ksunfy:13802:2937430291' TYPE='NOTIFICATION' GROUP='startup'
 level='16' host_id='14-317-818' host_addr='10.10.10.103'
 pid='2188'>
 <txt>LICENSE_MAX_SESSION = 0
 </txt>
</msg>
<msg TIME='2008-11-24T21:10:48.312+01:00' org_id='oracle' comp_id='rdbms'
 msg_id='ksunfy:13803:4207019197' TYPE='NOTIFICATION' GROUP='startup'
 level='16' host_id='14-317-818' host_addr='10.10.10.103'
 pid='2188'>
 <txt>LICENSE_SESSIONS_WARNING = 0
 </txt>
</msg>

So based on Tanel’s blog, could I do the same, but now with XMLDB functions (based on database version 11.1.0.7.0)…

Here it goes.

Read the Post Creating an alert log via XML/SQL

March 24

I just saw Daniel Fink’s – OptimalDBA – blog post: When is a sql statement too long? When the following OTN XMLDB Forum post popped up in my mind… “xquery” versus “select xmlquery” and passing clauses. It tells the story about using bind variables and its performance issues, some alternative ways of dealing with things, charactersets and the ORA-19102 error (“XQuery string literal expected”), ORA-19114 (“Error during parsing the XQuery expression: string”) or ORA-01704 (“String literal too long”).

So when is a XQuery string too long…?

Read the PostWhen is an XQuery Statement too Long?