Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared server mode and Real application cluster
On 28 Oct 2003 11:30:07 -0800, domenicg_at_hotmail.com (Domenic G.)
wrote:
>How much memory do you have on each node? If you have lots to spare,
>then keep it in dedicated mode. If not, you can move to MTS.
>Nowadays, using MTS isn't really necessary unless you have thousands
>of concurrent connections that sit there mostly idle most of the time.
> That's because machines now come with 4 GB + of memory.
bs.
Most third-party software firms are not using bind variables and don't
tune statements, so the only option is to throw memory to 'tune' the
application.
bs, also because jdbc clients are stateless, and require a connection per statement. Connection pooling and multiplexing is only available with MTS
bs, also because Microsux NT/2k still can't pass the 4Gb border.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Oct 28 2003 - 14:39:37 CST