It would be better to use gv$ function for such queries:
https://oraganism.wordpress.com/2012/05/20/gv_function/
gv/v$lock is complex view, and I had also trouble with it:
http://orasql.org/2012/06/30/a-lot-of-latch-free-dml-allocation-latch-in-concurrent-queries-to-vlock/
On Apr 13, 2015 9:01 AM, "Abhinav Gupta" <iamabhinav.akg@xxxxxxxxx> wrote:
Query, even the basic SELECT for count is hanging on these views.
The queries are running fine on v$* version of these scripts on all the
instances. Also, the query are running fine on other dictionary and dynamic
performance vies.
Anyone seen this kind of issue in database?
-Abhinav
