Re: Query Using 20 Parallel Sessions

From: Dereck L. Dietz <>
Date: Fri, 8 Feb 2008 21:43:35 -0500
Message-ID: <ws8rj.55015$>

"joel garry" <> wrote in message On Feb 8, 5:05 am, "Dereck L. Dietz" <> wrote:
> Oracle
> Windows Server 2003
> We have a query going against a 100 million plus row partitioned table
> using
> a bitmap index on a column with only 3 distinct values. When the query
> runs
> it only takes about 2 minutes and uses about 20 parallel sessions. This
> query is trying to retrieve specific rows where a value in a column is 0
> so
> the number of rows returned will not be huge.
> The person who runs this query has been informed that this is causing a
> "problem" because of it using 20 parallel sessions and has come to me to
> resolve the problem.
> I personally believe it is just Oracle working as designed and chosing the
> most efficient access path and method.
> Any comment/suggestions as to what my response should be?
> Thanks

Are you using shared server? ASM?

It's my understanding (which may be out of date or wrong) that when using shared server and parallel, the shared server will not be sharable while the parallel transactions are running on it and locks are held. Don't know any details since I don't do that.

Stuff about ASM in patch list.


-- is bogus.
"Mankind has a perfect record in aviation; we never left one up

Yes this query was run in shared server mode.  You make it sound like in 
dedicated server that locks wouldn't be held? 
Received on Fri Feb 08 2008 - 20:43:35 CST

Original text of this message