Oracle mutiple session for an application

Question

Hi !

I have a problem. Well, I have an VB6 app that connects to an oracle database. Normally it uses just one session to connect to the database, but after running an update query on a table, it opens another one, on wich it runs just one query : SELECT VALUE FROM SYS.NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_NCHAR_CHARACTERSET' The update query is :

UPDATE SYS_PASS set LAST_LOG = SYSDATE where ID = 'xxxx'

Any idee why this is happening, or how could i get rid of this extra session ?

Answer 1

This extra SQL statement must be generated either by

• your own VB6 program, in which case you need to fix it yourself
• "something" in your technology stack (the ODBC driver?), in which case you need to look at replacing all or parts of that technology stack; which may or may not be feasible (but hey, if you really want to get rid of that extra statement...)

Answer 2

If you want know what for your database do select then ask about select (describe how you detected extra select etc), not about app, while people will not understand what problem do you have.

Your second query executes on the opened connection itself and not on any other connection.

You might be seeing other connection because of connection pooling. You can verify that by setting Pooling = false in the connection string.