Re: PX Slaves won't die

From: <bryan_w_taylor_at_my-deja.com>
Date: Mon, 06 Nov 2000 16:25:03 GMT
Message-ID: <8u6m0l$ei7$1@nnrp1.deja.com>

In article <973424995.21480.5.nnrp-03.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

> A session can be inactive and still
> hold open cursors. It is possible
> that the cursor that caused the slaves
> to go active is still open.

Ah, yes. That explains everything. The user in question was using TOAD, and I've noticed that the data grid opens a cursor to fill the grid, and allow scrolling. Even if you click to another tab, the cursors stays open in case you come back.

I wonder what the best way to prevent this is. I don't necesarily want every data grid to use full parallelism, but I want to keep the default degree for the tables. I don't control the SQL in the tool, so I can't put in the noparallel hint. Ideas?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 06 2000 - 10:25:03 CST