Reg : Shared server process or dedicated server process

[Former Member]

Hi,

Apologies if i have asked a silly question.How do we know whether our DB is running in dedicated server process or shared server process.

[former_member524429 · Accepted solution]

Hi,

How do we know whether our DB is running in dedicated server process or shared server process.

I assume that, you are asking about the view of Oracle Processes in different OS Platform.

In a UNIX environment, Oracle processes (also other DB Processes) can be viewed as individual system processes.

On Windows platform Oracle Processes (also other DB Processes) are implemented as threads that run within one common Oracle operating system process, oracle.exe (e.g. in DB2, db2syscs.exe process). These processes are not visible when you list processes at operating system level.

Regards,

Bhavik G. Shroff

[Former Member · Accepted solution]

Hi,

My question was that oracle database which run under SAP do they have shared server mode or else dedicated server mode.