Performance of dedicated server!

From: Yeung Man <yngm_at_chowsangsang.com>
Date: Fri, 16 Jul 1999 13:10:02 +0800
Message-ID: <7mmeo7$1l5$1@news.hk.linkage.net>

Hi,

We are running MTS of Oracle Enterprise 8.0.5.1.1 on WinNT 4.0 with service pack 5; however, the server always terminated suddenly. Do anyone have any idea about this? Is it the bugs of oracle?

Therefore, we have to change the server from MTS to dedicated server. However, the performance after changing to dedicated server is very poor and unacceptable. We have then switch back. We have only 15 users on the server and configuration of server are 256M RAM and PII 400 CPU. We have set the shared_pool_size = 96M, processes = 400, db_block_buffers = 10000, open_cursors = 400, db_block_size = 4096 in the dedicated server. What parameter do we set to wrong values and what parameter's values should be correctly set in dedicated server. Please help as it severely affect our operation.

TIA. Best Regards,
Man
yngm_at_chowsangsang.com Received on Fri Jul 16 1999 - 00:10:02 CDT