But i think maybe it is better if i use the multi_threaded server. I have no idea on multi_threaded server. Could somebody tell me the info. on it, such as configuration, advantage/disadvantage? I appreciate it very much.
The MTS architecture eliminates the need for a dedicated server process for each connection. A dispatcher directs multiple incoming network session requests to a pool of shared server processes. An idle shared server process from a shared pool of server processes picks up a request from a common queue. This means a small number of shared servers can perform the same amount of processing as many dedicated servers. Also, since the amount of memory required for each user is relatively small, less memory and process management are required, and more users can be supported.
The advantage of MTS is that system overhead is reduced and less resources are used, allowing the number of users supported to be increased.
Thanks. I will pay attention to that. The another problem is that how could i check the user usage for memory? If i incease the processes value in init.ora file we will allow more users to connect to the database. Each user need a private memory. i need to increase the memory space. So how could i know the exactly needed memory for one additional user?