1 Reply Latest reply: Feb 12, 2009 7:39 AM by Timur Akhmadeev RSS

    Setting  "v$session.program"  oracle JDBC   connection   property

    684481
      Hi ,
      I would like to know how and where i can set the oracle JDBC connection property "v$session.program" (Ability to set the program field on the Oracle v$session ) on WebLogic server (9 and above) on config.xml or maybe other place . i found some reference how to do that in Oracle Application Server but nothing for WebLogic . My general idea is to be able to finalize via Oracle OEM which connection pool is performing specific SQL statement , this will be done by setting the property "v$session.program" with the value of the connection pool .

      Thanks .
        • 1. Re: Setting  "v$session.program"  oracle JDBC   connection   property
          Timur Akhmadeev
          In connection pool's config XML, which resides in ${DOMAIN}/config/jdbc/{some-name}.xml add a property v$session.program with wanted value, like this:
           <jdbc-driver-params>
              <url>jdbc:oracle:thin:@...</url>
              <driver-name>oracle.jdbc.OracleDriver</driver-name>
              <properties>
                <property>
                  <name>...</name>
                  <value>...</value>
                </property>
                <property>
                  <name>v$session.program</name>
                  <value>test-program</value>
                </property>
              </properties>
              <password-encrypted>...</password-encrypted>
            </jdbc-driver-params>
          After that all Oracle sessions for connections from that pool will have test-program in v$session.program field.

          Edited by: Timur Akhmadeev on Feb 12, 2009 4:39 PM
          Corrected path to jdbc config