select rowid help for oracle 9.2.0.2.0

From: <samuels_at_red.seas.upenn.edu>
Date: Wed, 21 Apr 2004 04:11:41 +0000 (UTC)
Message-ID: <c64s9t$3eaf$1@netnews.upenn.edu>

hi,
i'm hoping someone can help me with this. here's the scenerio, i have a million row table a and i do the following: begin
for i in (
select /*+ full(a) */ a_column from a) loop null;
end loop;
end;
/

runtime: 2 minutes

now, i try the following:
begin
for i in (
select /*+ full(a) */ rowid from a) loop null;
end loop;
end;
/

runtime: 10+ minutes (i've never waited long enough for it to complete)

i do not know how to explain the difference in time. i believe this is a pl/sql bug. i can do a [select /*+ full(a) */ a_column from a] or [select /*+ full(a) */ rowid from a] in sqlplus with no difference in runtime.

i ran into this issue after upgrading from 8.1.7.4.0 to 9.2.0.2.0.

if anyone has any ideas or can help that would be great (before i create a TAR). thanks in advance.
-maurice

ps --> the OS is SunOS 5.8 Received on Tue Apr 20 2004 - 23:11:41 CDT