Re: grant select command so slow
Date: Thu, 15 May 2008 14:40:04 -0400
All good suggestions to only grant to new objects.
To address the original question, I have also seen a database where the grants (and a lot of other DBA stuff) were slow. It turned out that instance had all kinds of junk installed that wasn't used like UltraSearch and some old EM stuff and whatnot. Many of these things generated jobs that were running more or less constantly. After deinstalling these components the database sped up considerable.
Check your jobs.
On 5/15/08, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
> Rather than running the grant script for all objects, just run grants
> for newly created tables every day OR , if tables are created manually
> through a migration process, include the grants in that process itself.
> Hemant K Chitale-