10g: parallel pipelined table functions with cursor selecting from table(cast(SQL collection)) doesn't work
From: Frank Bergemann <FBergemann_at_web.de>
Date: Wed, 8 Jun 2011 06:00:57 -0700 (PDT)
Message-ID: <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>)".
Date: Wed, 8 Jun 2011 06:00:57 -0700 (PDT)
Message-ID: <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
Received on Wed Jun 08 2011 - 08:00:57 CDT