RE: COLLECTION ITERATOR PICKLER FETCH

Hi Scott,

Pickling is serializing arbitrary object-oriented data structures. That is, converting them into a byte stream for storage, transmission over a network or iterative navigation as in this case. It is a more complex process than you might imagine. If you want more information, search the web for information on Python's pickle module.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
Sent: Friday, 11 May 2001 3:11
To: Multiple recipients of list ORACLE-L

Sometimes I really love the developers at Oracle...... This should be good fodder for Eric P.

Does anyone have experience with infamous pickler Fetch which shows up in this explain plan the select is on index organized nested tables (Nested objects)? It's obvious that someone in internals has a good sense of humor. I guess this is the way Oracle dereferences the embedded collections?   SELECT STATEMENT     SORT GROUP BY       NESTED LOOPS         NESTED LOOPS           NESTED LOOPS

            NESTED LOOPS
`               BLAH BLAH BLAH....

       COLLECTION ITERATOR PICKLER FETCH

          VIEW  AD_AGG_DATA_MASTER

            UNION-ALL PARTITION

              FILTER

                TABLE ACCESS BY INDEX ROWID AD_200003

                  INDEX RANGE SCAN AD_200003_IDX_1

              FILTER

                TABLE ACCESS BY INDEX ROWID AD_200004

                  INDEX RANGE SCAN AD_200004_IDX_1

              FILTER

                TABLE ACCESS BY INDEX ROWID AD_200005

                  INDEX RANGE SCAN AD_200005_IDX_1

Scott Crabtree
Veritas Certified Survivor

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
  INET: scott_at_psscorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).