[RESOLVED] vb.net issue with oracle session

[adshocker]

hi all,

i noticed in vb.net that when declaring new connection objects it creates a new session. and sometimes it reuses an existing one.

is this an expected behavior?

in my application i created a global temporary table. in oracle, this acts like a table but session based. the behavior mentioned above is causing some issues with my temporary table as new sessions are being created and thus, i'm not able to get the desired data from the table.

i thought of using a global connection but not sure if this is the best way.

any suggestions?

thanks.

[GaryMazzone]

That is the expected behavior for Oracle. The smon process has not had time to clean up the connection so it thinks it is still in use and creates a new session.

[adshocker]

hi,

thanks for the info.

i would like to add a follow up question on this...

i'm trying to experiment with oracle connections and sessions.. i noticed that if i use a global connection object but then close and dispose it after using it, it removes the session after a while..

what is the impact if i leave the connection open the entire application is running?

thanks

[GaryMazzone]

I takes up one of you Oracle connection that is it. What is it. You may need to mofify the Oracle inti file to allow more connections at one time.

[adshocker]

thanks.