Re: prevent sql invalidations after grants on objects

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 <contactarul@xxxxxxxxx>wrote:

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



-- 
Eagle Fan

Sr. DBA

Other related posts: