Re: Link procedure to sql statement in v$sqlarea

From: rjamya <rjamya@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Wed, 24 Oct 2007 22:48:25 -0400

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@xxxxxxxxx> 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.
>
>

References:

RE: Link procedure to sql statement in v$sqlarea
From: Saibabu Devabhaktuni

Re: Link procedure to sql statement in v$sqlarea

Other related posts: