Re: prevent sql invalidations after grants on objects

From: Eagle Fan <>
Date: Wed, 10 Sep 2008 10:32:32 +0800
Message-ID: <>

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

On Tue, Sep 9, 2008 at 11:40 AM, Arul Ramachandran <>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


Received on Tue Sep 09 2008 - 21:32:32 CDT

Original text of this message