Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: a simple PL/SQL question about getting a list of values to output parameters

Re: a simple PL/SQL question about getting a list of values to output parameters

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 29 Dec 2006 08:44:45 +0100
Message-ID: <en16lp$4pk$1@news5.zwoll1.ov.home.nl>


EscVector schreef:

> "Do readers block writers in sqlserver".
>
> I can get this to happen in Oracle as well.
> Very easy to do do in fact. All you need is parallel query/partitioned
> table and toad or any other sql query tool. Child process remain
> active after simple select and block additional queries who's sessions
> need that particular cpu. I can reproduce this in 9i every time.

Show it - it's not blocking; maybe it's busy.... Not blocking (and in fact what you describe is readers blocking readers)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Dec 29 2006 - 01:44:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US