Solved

Multiple Sessions in Oracle

Posted on 2000-03-22
6
309 Views
Last Modified: 2010-05-18
I have a unique problem: I created an app in Delphi that is essentially a tracking program. It tracks certain items and the age. It also updates/inserts into the database. Now, when I log in to Oracle from within the Delphi app, everything is fine (I log in to Oracle as system and monitor V$Session); only one session is created. If I run this particular query from within the Delphi app, it creates 7 sessions in oracle. I've run the query in SQL Plus and only one session appears. Run within Delphi app, 7 sessions appear. We are running multi-threaded server and parallel server options o an Oracle 7.3.4 server (NT 4.0). I've created other Delphi apps that do not create this phenomenon. Here are some particlars:
- Query runs on a view of several tables (eqi-joined)
- View contains 2 longs
- Simple query only selects the fields
- App contains 2 query controls, one store procedure control, one database control, one table control and 3 datasources. I don't do multiple logins in a loop. I have noticed 7 sessions during logon and combo box population (via loop on table control). After it's finished, the other 6 sessions disappear. Another DBA and I watched as he killed every session, and nothing happened until he killed the true active session for the program. In fact here is the output from within SQL Plus:
USERNAME                       STATUS         SID   SERIAL# PROGRAM
------------------------------ -------- --------- --------- -------
EVANSJ                         INACTIVE        23       841 OraPgm
EVANSJ                         INACTIVE        30       412 OraPgm
EVANSJ                         INACTIVE        40       398 OraPgm
EVANSJ                         INACTIVE        51       267 OraPgm
EVANSJ                         INACTIVE        60       190 OraPgm
EVANSJ                         INACTIVE        66        56 OraPgm
EVANSJ                         INACTIVE        67        97 OraPgm

If anyone has encountered this problem and has solved it, or might know what's going on, there are 200 points for you.
0
Comment
Question by:evansj
  • 4
  • 2
6 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2646505
listening . . . (too late now here)
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 200 total points
ID: 2648167
hi again,

i guess that depends on the bde sql-passthrough settings of your alias-driver.

check following entries:

set sqlpasstroughmode to shared noautocommit
set sqlmode to server

just a guess

meikl
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2650357
hi evansj,

i guess that my guess was right, isn't it?

thanks for accepting my comment as an answer :-)
glad to helped you
good luck again

meikl
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 

Author Comment

by:evansj
ID: 2650915
To Meikl: It worked this morning, now its doing almost the same thing with 7 connects 6 inactive one active.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2653627
hi evans,
that are bad news :-(
what was different?

will do a test on next monday,
maybe i can reproduce this

meikl
0
 

Author Comment

by:evansj
ID: 2653976
I tried down revving the BDE, then I uprevved back to 5.11. The phenomenon occurs more often than not, and sometimes only produces one instance.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now