Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Multi threaded server/Shared server


There are 2 types of server architectures :
1.Dedicated server architecture(DSA)
2.Shared server architecture(SSA)
In case of DSA, for every user process there will be a dedicated server process(DSP).


In an enterprise application environment, from 10g each server process occupies at least 5mb of memory, which may lead to wastage of memory resource.
In olden days, since RAM is very expensive we may go with SSA.
In case of SSA, for all user processes we enable few shared server processes.
Now a days since RAM has become very cheap, in most of the environments we go with dedicated server architecture.

In shared server configuration, we can give a dedicated connection to a specific user by configuring the following TNS entry :

to_hrms=
(Description=
(AddressList=(protocol=TCP)(host=venu1.oracle.com)(port=1521)
(server=dedicated)
(SID=hrms)))

Related Posts Plugin for WordPress, Blogger...

Flag Counter