Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: a simple PL/SQL question about getting a list of values to output parameters
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