0 Replies Latest reply: May 3, 2013 6:16 AM by joem RSS

    application spawning new query in weblogic 8.1

    joem
      Hi ,

      Has anybody encountered an issue in weblogic 8.1 (still BEA) with 10.2.0.1 database wherein the application which executes a select query respawns when the query being executed is taking a long time (around 10-15mins).. For example, when the application is executed, it only has 1 session in the database, then after a few minutes it would spawn another one eventhough the same query in the first session was not yet completed (so it creates 2 sessions now executing the same query), then for a while a third session comes along.. until the weblogic server would have insufficient memory.

      We don't know if we might be just missing some configuration to prevent it from spawning new sessions or are we encountering a bug.

      Thanks in advance.