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?