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

"Frank Bergemann" <FBergemann_at_web.de> a écrit dans le message de news: 25996c2b-6765-4781-ac87-f581ba705f33_at_k16g2000yqm.googlegroups.com...
|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...

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