Re: Link procedure to sql statement in v$sqlarea

I think this identification becomes a bit easier in 11g where program_id in v$sql points to the object_id (in most cases) from where that specific sql came from. I believe i read this in one of the articles on metalink.

Raj

On 10/22/07, Saibabu Devabhaktuni <saibabu_d_at_yahoo.com> wrote:
>
> You can also compare "LAST_ACTIVE_TIME", "LAST_LOADED_TIME", and
> "FIRST_LOAD_TIME"
> values of pl/sql and sql query entries in v$sql.
>
>

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