This article may be of interest to you:

https://knowledge.safe.com/articles/79080/persistent-connections-and-oracle-database.html

It doesn't answer your question specifically, but you can infer a lot from it.

I have read this article before posting my question. It doesn't answer my question directly or indirectly. It doesn't say anything about workspaces. I am also not sure about FeatureReaders and FeatureWriters and whether they are considered transformers or readers and writers.

Hi @denisnaumov,

Thanks for those great questions.

FeatureReaders / FeatureWriters use the same connections methods as readers and writers. All readers and transformers share the same database connection if they are set to use persistent connection you should only have a max of two connections per workspace regardless of what transformers or readers/writers you use. (The first for readers/transformers/featureReaders, and the second for all writers/featureWriters)

The workspaceRunners scenario is a good question. Child processes sent by the FME desktop from a workspaceRunner are a new instances, so unlike FME Server the child process will use new connections and not the parents connections.

Thanks,

Richard

Hi @denisnaumov,

Thanks for those great questions.

FeatureReaders / FeatureWriters use the same connections methods as readers and writers. All readers and transformers share the same database connection if they are set to use persistent connection you should only have a max of two connections per workspace regardless of what transformers or readers/writers you use. (The first for readers/transformers/featureReaders, and the second for all writers/featureWriters)

The workspaceRunners scenario is a good question. Child processes sent by the FME desktop from a workspaceRunner are a new instances, so unlike FME Server the child process will use new connections and not the parents connections.

Thanks,

Richard