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.
>
>
Other related posts:
