Re: grant select command so slow
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- 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.
Thanks,
Finn
On 5/15/08, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> 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-
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
