prevent sql invalidations after grants on objects
- From: "Arul Ramachandran" <contactarul@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 8 Sep 2008 20:40:18 -0700
On an extremely busy 24x7 10.2.0.3 db, I need to grant privileges on several
tables to a few roles. This would invalidate the sqls (we are talking
100s/1000s of sqls) in the sql area that refer to the tables leading to a
hard parse storm.
Is there a documented/undocumented way to prevent the invalidations and the
resulting reparses?
Thanks in advance.
--
Arul
Other related posts:
