who hard parsed (loaded into shared pool) a specific sql?

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: 2006-01-12 21:36:36
Message-id: 20060112203636.49420.qmail@web32802.mail.mud.yahoo.com

... if the sql comes from a stored code. v$sql parsing_user_id and parsing_schema_id show the owner of the stored code (at least for code running with definer-rights scope), not the actual user.

There's a first/last_load_time, but is there any way to know who (assuming DB security is used - i.e. every user has a DB account) caused a sql to be hard parsed and loaded to a library cache?

Thanks,
Boris Dali.                                   

---

Find your next car at http://autos.yahoo.ca

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

Received on Thu Jan 12 2006 - 21:36:36 CST