Re: Query hanged on gv$lock & gv$locked_object
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Mon, 13 Apr 2015 12:51:37 -0400
Message-ID: <552BF419.3060402_at_yahoo.com>
On 04/13/2015 02:00 AM, Abhinav Gupta 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
What exactly is the event that the query is waiting for?
Date: Mon, 13 Apr 2015 12:51:37 -0400
Message-ID: <552BF419.3060402_at_yahoo.com>
On 04/13/2015 02:00 AM, Abhinav Gupta 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
What exactly is the event that the query is waiting for?
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 13 2015 - 18:51:37 CEST