Re: prevent sql invalidations after grants on objects

  • From: "Eagle Fan" <eagle.f@xxxxxxxxx>
  • To: contactarul@xxxxxxxxx
  • Date: Wed, 10 Sep 2008 10:32:32 +0800

I'm not sure how busy your database is.

If you do it one by one and sleep a few seconds in between and moniter the
number of active sessions, I think it should be ok for most databases.

When table has trigger on it, adding column may cause high active sessions
on extremely busy system since it will invalid the trigger and triggers
needs to be re-compiled.

Grant priveleges doesn't invalid trigger. I think it's ok for most

On Tue, Sep 9, 2008 at 11:40 AM, Arul Ramachandran <contactarul@xxxxxxxxx>wrote:

> 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.
> --
> Arul

Eagle Fan


Other related posts: