Re: Query hanged on gv$lock & gv$locked_object
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 13 Apr 2015 09:26:12 +0300
Message-ID: <CAOVevU7zOuj8fw4iX1tiisQEtCkkqHeb2Jhm=tJhtyEXzd1sSA_at_mail.gmail.com>
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_at_gmail.com> wrote:
Date: Mon, 13 Apr 2015 09:26:12 +0300
Message-ID: <CAOVevU7zOuj8fw4iX1tiisQEtCkkqHeb2Jhm=tJhtyEXzd1sSA_at_mail.gmail.com>
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_at_gmail.com> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 13 2015 - 08:26:12 CEST