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