How to derive the username that owns the SQL in V$SQLAREA

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Sat, 1 Dec 2007 16:12:48 -0800 (PST)
Message-ID: <45578132-5ba4-4f10-88db-a3d09beb5113@s19g2000prg.googlegroups.com>

How do you derive the username of the session the created the SQL that appears in V$SQLAREA?

In V$SQLAREA, there is a field SQL_ID.

Generally, I should look for a view that have SQL_ID, SERIAL# and SID right? (or USERNAME and SQL_ID?)

I search through ALL the V$ tables - a few views seems plausible - V
$SESSION has a SQL_ID, but its does not match with any of those of V
$SQLAREA, and V$SESSION_LONGOPS has no rows in the view. And so is V
$SORT_USAGE.....
I have given up. Anyone knows the answer? Received on Sat Dec 01 2007 - 18:12:48 CST