prevent sql invalidations after grants on objects
From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Mon, 8 Sep 2008 20:40:18 -0700
Message-ID: <1c1a62990809082040rbc1b5ecwa3c4160197e22723@mail.gmail.com>
Date: Mon, 8 Sep 2008 20:40:18 -0700
Message-ID: <1c1a62990809082040rbc1b5ecwa3c4160197e22723@mail.gmail.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 08 2008 - 22:40:18 CDT