Wednesday, July 24, 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%'

Wednesday, July 17, 2013

How to add System Properties with Spring Framework

A cool example grabbed on the web :



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