sql statement "hanging" and unable to query v$lock

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 10 Jan 2001 14:38:50 -0800
Message-Id: <10737.126347@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07B56.1A7E90C0
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Question here. I have a query that's taking an abnormally long time to execute (at least in my opinion). I can see the query that's executing = (I
assume this is the one since I'm in a development database with only = very
few connections, and there's only one with loaded_versions =3D 1, open_versions =3D 1, and users_executing =3D 1 in v$sql).

I figured that there was probably a table being locked somewhere. But = when I
try to query v$lock (I typed in "select * from v$lock" in SQL*Plus on = the
server) that query hangs too! At least it never returns back to the = prompt.

However I can still connect to the database in a new session and query = other
v$ views such as v$session.

How do I find out why the process is hanging? I don't see any ORA- = errors in
the alert log.

Oracle Enterprise Edition 8.0.5 on Sun Solaris 5.7

Jacques R. Kilcho=EBr
(949) 754-8816
Quest Software, Inc.

8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

------_=_NextPart_001_01C07B56.1A7E90C0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>sql statement "hanging" and unable to query v$lock - =
Oracle 8.0.5</TITLE>
</HEAD>
<BODY>

Question here. I have a query that's taking an =
abnormally long time to execute (at least in my opinion). I can see the = query that's executing (I assume this is the one since I'm in a = development database with only very few connections, and there's only = one with loaded_versions =3D 1, open_versions =3D 1, and = users_executing =3D 1 in v$sql).

I figured that there was probably a table being =
locked somewhere. But when I try to query v$lock (I typed in = "select * from v$lock" in SQL*Plus on the server) that query = hangs too! At least it never returns back to the prompt.

However I can still connect to the database in a new =
session and query other v$ views such as v$session.


How do I find out why the process is hanging? I don't =
see any ORA- errors in the alert log.


Oracle Enterprise Edition 8.0.5 on Sun Solaris =
5.7


Jacques R. Kilcho=EBr
 (949) 754-8816
 Quest Software, Inc.


8001 Irvine Center Drive
 Irvine, California 92618
 U.S.A.
 <A HREF=3D"http://www.quest.com" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Wed Jan 10 2001 - 16:38:50 CST

sql statement "hanging" and unable to query v$lock - Oracle 8.0.5