Re: Alive sessions

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 25 Mar 2002 22:18:41 +0100
Message-ID: <do4v9ucmo04dqk8oq6c342b8n47sgdsi5a@4ax.com>

On Mon, 25 Mar 2002 19:38:00 -0000, "daniel" <test_at_test.com> wrote:

>>>DCD doesn't work on NT,
>
>really??? please explain???
>
>
>--
>Regards,
>
>Daniel.
>

According to Metalink a NT 4 process (the same applies to Win2k) can allocate only 16 timers. As Oracle has been implemented multithreaded, each Oracle 'process' equates one thread within a single NT process. As soon as you have more than 16 processes/sessions in your instance, the remaining processes won't get a timer allocated, which is necessary for DCD, as DCD polls the client every n minutes. So, either you need to implement MTS (where multiple client sessions share a single server process), or you need to allow not more than 16 processes, which isn't a very useful limit. This has been resolved in 9i for XP

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Mar 25 2002 - 15:18:41 CST