grant select command so slow
- From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
- To: oracle_l <ORACLE-L@xxxxxxxxxxxxx>
- Date: Wed, 14 May 2008 14:48:25 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
