Re: grant select command so slow
Date: Wed, 14 May 2008 14:54:07 -0400
Message-ID: <OF12CE670A.9EFC0814-ON85257449.0067B18E-85257449.0067D4C6@lnotes-gw.ent.nwie.net>
Joan,
could it be oracle does the check to see if the grant already exists(and I'm totally speculating here), and sees it already does and doesn't do anything and moves on to the next view/table?
Could you make it more smart by writing the query to it only has to do the grants on ones that its missing?
just some rambling thoughts.
Joe
You can have it: Fast, Right or Cheap, pick 2 of the 3. Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.
Joan Hsieh <joan.hsieh_at_tufts.edu>
Sent by: oracle-l-bounce_at_freelists.org
05/14/2008 02:48 PM
Please respond to joan.hsieh_at_tufts.edu
From
Joan Hsieh <joan.hsieh_at_tufts.edu>
To
oracle_l <ORACLE-L_at_freelists.org>
cc
Subject
grant select command so slow
Hi list,
I have created a role with just select privilege on all sysadm objects. The script run very fast at first time. Since there maybe new tables created in the prod. So I cron the script, run it every night. Now the script ran so slow, each grant statement at least took 2 to 3 seconds. So it never finished to run in one day. (totally had more than 49000 tables and views). The system is not loaded, most time is just this session is active. The other function seems normal, users didn't complain for their activities. Do you know any reason why the "grant select on syadm.xxxx to role" run so slow?
Thanks,
Joan
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 14 2008 - 13:54:07 CDT