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_at_gmail.com>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

--
http://www.freelists.org/webpage/oracle-l