Many connection to Oracle from one SOC

220
0
02-02-2022 10:40 PM
mody_buchbinder
Occasional Contributor III

Hello all

We have a view in Oracle that is published with server.

When I check task manager on server it has one ArcSOC.exe for this service.

The process_information table have one record for this SOC.

In Oracle we see about 40 sessions opened by that SOC process.

In the task manager I see that this ArcSOC.exe process have about 40 threads.

The DBA said that some tables that this view is build on have DOP (degree of parallelism) bigger then 1 – I am not sure this is connected.

 

Does anybody run into this problem or know anything about it?

0 Kudos
0 Replies