prevent sql invalidations after grants on objects

From: Arul Ramachandran <>
Date: Mon, 8 Sep 2008 20:40:18 -0700
Message-ID: <>

On an extremely busy 24x7 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.



-- Received on Mon Sep 08 2008 - 22:40:18 CDT

Original text of this message