0 Replies Latest reply on Jan 3, 2014 6:21 AM by f15fc492-3aa3-41f4-9b18-6de8ab57cdfe

    Help with DB and glassfish

    f15fc492-3aa3-41f4-9b18-6de8ab57cdfe

      Good mornig,

       

      I am working with a amplicacin for the company and pass the boss has endorsed me wearing brown going forever and nobody has been able to solve it.

       

      The issue is that every time the Java application connects to the DB parallel glassfish throws the following statement:

        SELECT value $ FROM $ props WHERE name = 'GLOBAL_DB_NAME'

       

      The problem that the set is not closed and is inactive.

       

      Neither do we know even qupero been inactive DB are not deleted until an automated process every two hours that handles inacctivas delete all sessions over two hours is launched.

       

      The problem that causes this if launched many queries saturate the DB.

       

      The version is:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      CORE    11.2.0.3.0    Production

      TNS for 64-bit Windows: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

       

      Thanks in advance for your help.