RE: COLLECTION ITERATOR PICKLER FETCH

[Steve Adams]

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_23

  INDEX RANGE SCAN AD_23_IDX_1

  FILTER

TABLE ACCESS BY INDEX ROWID AD_24

  INDEX RANGE SCAN AD_24_IDX_1

  FILTER

TABLE ACCESS BY INDEX ROWID AD_25

  INDEX RANGE SCAN AD_25_IDX_1



Scott Crabtree
Veritas Certified Survivor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

friday fun early, vote for favorites / Re: COLLECTION ITERATOR PICKLER FETCH

[Eric D. Pierce]

dudes/dudettes,

i'm wy to brain dead after read about oracle9i self
tuning, so i'll take refuge in anagram fun:

   http://www.wordsmith.org/anagram/

select output for: iterator pickler fetch 
(it wouldnt take more than 25 chars)

A CRECHE FRITTER IT POLK
...
A CRECHE FELT IRK PIT ROT
...
A CRECHE FELT IRK IT PORT
...
A CRECHE KITE FLIRT PORT
...
A CRECHE TRIPLET FORK IT
...
A CRECHE TRIPE FORK TILT
...
A CRECHE PERK IF TILT ROT
...
A CRECHE KEPT FLIRT RIOT
...
A CRECHE TREK FLIP IT ROT
...
A CRECHE PETROL RIFT KIT
...
A ELECTRIC HEFT IRK PORT
...
A ELECTRIC FRET HIT PORK
...
A ELECTRIC PET FROTH IRK
...
A COERCE TREK FILTH TRIP
...
A CLICHE FRET REPORT KIT
...
A CLICHE PERK RETORT FIT
...
A RICOCHET FRITTER KELP
...
A HECTIC REEK FLIRT PORT
...
A HECTIC FILTER PERK ROT
...
A HECTIC FELT REPORT IRK
...
A CORRECT ETHER FLIP KIT
...







On 10 May 2001, at 9:11, Scott Crabtree scribbled with alacrity and cogency:


 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 

...


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).