Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> V$sql - object_status

V$sql - object_status

From: Arnon, Yuval <Yuval.Arnon_at_webloyalty.com>
Date: Thu, 25 Jan 2007 10:28:30 -0500
Message-ID: <FE0ABB04D9872B4EA8B91DE36AAC449E08A8B801@exchange04.webloyalty.com>


Hi,

Trying to find out what is the explanation of a value in the object_status column of v$sql.
We have one SQL that is showing with a object_status of INVALID_UNAUTH. Metalink and Oracle DOC do not explain the meaning of this. What is the cause for the status to be set to this value?. The session that is running this query is ACTIVE but is in a hung state for the last few hours.

Oracle 9.2.0.7 on Win 2003 server.

TIA. Yuval.

This transmission may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you, oracle-l_at_freelists.org, are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 25 2007 - 09:28:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US