Re: Select any dictionary role
- From: Alex Gorbachev <gorbyx@xxxxxxxxx>
- To: fred_fred_1@xxxxxxxxxxx
- Date: Tue, 18 Oct 2005 01:57:57 +0200
AFAIK and experienced, excessive access to some V$ views might cause
some contention on latches. At least we experienced that in few db
instances with one of our monitoring scripts. We think we hit the bug
that accesing particular V$ table can lead for a long hold time of a
latch. Well as V$ views are based on X$ memory structures, access to
them is protected with latches. This is my understanding and that's
what we've been told by Oracle support in that case.
2005/10/17, Fred Smith <fred_fred_1@xxxxxxxxxxx>:
> Hello all,
> Just wanted to get your thoughts ... is there any "danger" to granting
> developers the SELECT ANY DICTIONARY role in the database? (IMHO, they don't
> particulary need such "open" access, however tools such as OEM require it
> for login apparently).
--
Best regards,
Alex Gorbachev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
