v$sql.parsing_user_id=0 when parser was not SYS

Looking at v$sql, I see that quite often a cursor that was actually originally parsed by some user other than SYS shows a PARSING_USER_ID of 0 (SYS). How can I tell who really parsed this cursor? Shouldn't there be a separate child cursor in v$sql for each user that uses the cursor?

I am in 8i, trying to automate SQL plan collection for the most executed queries (similar to v$sqlplan functionality in 10g). If I can't empirically determine the correct current_schema to set when running explain, I will have to fudge and create an "educated guess" algorithm.

Thanks,

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

--
http://www.freelists.org/webpage/oracle-l