prevent sql invalidations after grants on objects
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.
http://www.freelists.org/webpage/oracle-l Received on Mon Sep 08 2008 - 22:40:18 CDT