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 22.214.171.124.0 - 64bit Production
PL/SQL Release 126.96.36.199.0 - Production
CORE 188.8.131.52.0 Production
TNS for 64-bit Windows: Version 184.108.40.206.0 - Production
NLSRTL Version 220.127.116.11.0 - Production
Thanks in advance for your help.