Boa tarde!

Estou tendo problema com algumas consultas apenas em uma base RM ORACLE com resposta do dataset "Tempo de resposta excedido". Tenho outros 20 dataset funcionando 100%. O retorno dessa mesma consulta pelo PL/SQL não leva 4 segundos.

Algo que possam me ajudar?

Configuração do datasource:

<datasource enabled="true" jndi-name="java:/jdbc/FluigDSRM" jta="false" pool-name="FluigDSRM" use-java-context="false">
    <connection-url>jdbc:oracle:thin:@1.1.1.1:1521:N</connection-url>
    <driver>oracleDriver</driver>
    <new-connection-sql>alter session set nls_comp = 'LINGUISTIC' nls_sort = 'BINARY_CI'</new-connection-sql>
    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
    <pool>
        <min-pool-size>0</min-pool-size>
        <max-pool-size>300</max-pool-size>
        <prefill>true</prefill>
    </pool>
    <security>
        <user-name>fluig</user-name>
        <password>XXXX</password>
    </security>
    <validation>
        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
        <validate-on-match>true</validate-on-match>
        <background-validation>false</background-validation>
        <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>
        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
    </validation>
    <timeout>
        <blocking-timeout-millis>600000</blocking-timeout-millis>
    </timeout>
    <statement>
        <share-prepared-statements>false</share-prepared-statements>
    </statement>
</datasource>