Skip to main content

Posts

Showing posts from July, 2013

Look for 'delete' statements in Oracle history

That's what I had to found in production today. Hopefully, I had access to v$sql

So, here is the miracle :

select v.SQL_TEXT,
           v.PARSING_SCHEMA_NAME,
           v.FIRST_LOAD_TIME,
           v.DISK_READS,
           v.ROWS_PROCESSED,
           v.ELAPSED_TIME,
           v.service
      from v$sql v
where v.SQL_TEXT like '%delete%' OR v.SQL_TEXT like '%delete%'

How to add System Properties with Spring Framework

A cool example grabbed on the web :



<beanclass="org.springframework.beans.factory.config.MethodInvokingFactoryBean"><propertyname="targetObject"><beanclass="org.springframework.beans.factory.config.MethodInvokingFactoryBean"><propertyname="targetClass"value="java.lang.System"/><propertyname="targetMethod"value="getProperties"/></bean></property><propertyname="targetMethod"value="putAll"/><propertyname="arguments"><util:properties><propkey="org.apache.cxf.stax.allowInsecureParser">true</prop></util:properties></property></bean>