Hanging SQL query (Oracle)

From: Tomasz Majchrzak (tomekem_at_poczta.fm)
Date: 12/10/04

  • Next message: Robert Klemme: "Re: federate several datasources" 
    Date: Fri, 10 Dec 2004 11:38:09 +0100

    Hello,

    Execution of my query to Oracle db stops. My system is running on
    Resin (v2.1) and Oracle 8i as database (on the same machine).
    The system has been working fine for 2 years but problem appeared
    recently. Code below is executed many times although problem with
    stopped query occurs once per '500 times' or less. There are no
    DML operations in the system so there are no blocking transactions.
    When problem appears, you can still connect to Oracle from console.
    Processor usage is low so it doesn't look like infinite loop.
    I changed JDBC driver for newest one (the previous one was 3 years
    old) but it didn't helped.

    Do you have any suggestions?

    Tomek

    JDK: 1.4
    System: Linux

    Stack trace from JVM:

    tcpConnection-6801-8:
      [1] java.net.SocketInputStream.socketRead0 (native method)
      [2] java.net.SocketInputStream.read (SocketInputStream.java:129)
      [3] oracle.net.ns.Packet.receive (null)
      [4] oracle.net.ns.NetInputStream.getNextPacket (null)
      [5] oracle.net.ns.NetInputStream.read (null)
      [6] oracle.net.ns.NetInputStream.read (null)
      [7] oracle.net.ns.NetInputStream.read (null)
      [8] oracle.jdbc.ttc7.MAREngine.unmarshalUB1 (null)
      [9] oracle.jdbc.ttc7.MAREngine.unmarshalSB1 (null)
      [10] oracle.jdbc.ttc7.Oall7.receive (null)
      [11] oracle.jdbc.ttc7.TTC7Protocol.doOall7 (null)
      [12] oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe (null)
      [13] oracle.jdbc.driver.OracleStatement.doExecuteQuery (null)
      [14] oracle.jdbc.driver.OracleStatement.doExecute (null)
      [15] oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (null)
      [16] oracle.jdbc.driver.OracleStatement.executeQuery (null)
      [17] my_packet.my_page (null)
      ..
      ..
      [20] com.caucho.jsp.JavaPage.service (JavaPage.java:75)
      [21] com.caucho.jsp.Page.subservice (Page.java:485)
      [22] com.caucho.server.http.FilterChainPage.doFilter (FilterChainPage.java:182)
      [23] com.caucho.server.http.Invocation.service (Invocation.java:312)
      [24] com.caucho.server.http.CacheInvocation.service (CacheInvocation.java:135)
      [25] com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:342)
      [26] com.caucho.server.http.RunnerRequest.handleConnection (RunnerRequest.java:272)
      [27] com.caucho.server.TcpConnection.run (TcpConnection.java:137)
      [28] java.lang.Thread.run (Thread.java:536)

  • Next message: Robert Klemme: "Re: federate several datasources"

    Relevant Pages

    • Re: Access and Linked tables to Oracle
      ... You might want to consider using a Pass-through query for this, ... you do not need to update your Oracle tables through Access. ... > The initial Access database was created in Access 2000. ... > is really slow if the primary key gets created on that table ...
      (microsoft.public.access.tablesdbdesign)
    • Re: SQL Injection Legalities
      ... I am currently writing the SANS Step-by-step guide to securing Oracle ... Oracle database, application server et al to secure it. ... >This was being discussed as a legal issue in pen-test, but I was curious if>anyone else has thought of using SQL Injection to cause a DoS. ... The second OR is>only to maintain a valid SQL statement (assuming the final character in the>query will be a single quote). ...
      (Vuln-Dev)
    • Re: Views - performance
      ... when u use stored object views oracle has to read the data dictionary ... this includes lots of steps for execution ... semantics of the query and fires it ... you'll possibly have any idea is to use explain plan to provide a base ...
      (comp.databases.oracle.server)
    • Re: Limiting Large Result Sets
      ... Oracle 9i - Database ... Using query based approach, i was able to retreive all the million rows ... Fetch Size ... rows at a time from the database cursor. ...
      (comp.lang.java.programmer)
    • Re: Question for 10g enthusiasts
      ... force Oracle to use the better execution plan for all users. ... If the access is through private synonyms, the query will ...
      (comp.databases.oracle.server)