Re: parallel pipelined table functions with cursor selecting from table(cast(SQL collection)) doesn't work

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 8 Jun 2011 17:20:21 +0200
Message-ID: <4def9336$0$26058$>

"Frank Bergemann" <> a écrit dans le message de news:
|i try to distribute SQL data objects - stored in a TABLE OF <SQL
| object-Type> - to MULTIPLE (parallel) instances of a table function,
| by passing a select CURSOR(...) to the table function, which selects
| from the SQL TABLE OF storage via "select * from
| TABLE(CAST(<storage> as <storage-type>)".
| But oracle always only starts a single table function instance :-( -
| whatever hints i provide or setting i use for the parallel table
| function (parallel_enable ...)
| Could it be, that this is due to the fact, that my data are not
| globally available, but only in the main thread data?
| Can someone confirm, that it's NOT possible to start multiple parallel
| table functions for selecting on SQL data type TABLE OF <object>
| storages?
| (It will take some time to create an example for that - but might be
| necessary to post such here. Let me try without first).
| - thanks!
| rgds,
| Frank

Waiting for your example/test case...

Michel Received on Wed Jun 08 2011 - 10:20:21 CDT

Original text of this message