Bug in V$SQl view?

Is there a bug in the V$SQL view in version 7.3.2.3.10?

Yesterday I ran the following query displaying session and sql info:

select a.username, a.sid, b.sql_text
from a.v$session, b.v$sql
where a.sql_address = b.address
and sid = 14;

I consistently got more than 1 lines returned. When I changed v$sql to v$sqlarea, I only got one.
--
Chuck Hamilton
chuckh_at_safeaccess.net

If at first you don't succeed, sky diving isn't for you. Received on Wed Oct 21 1998 - 09:24:41 CDT