V$sql - object_status
- From: "Arnon, Yuval" <Yuval.Arnon@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Jan 2007 10:28:30 -0500
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@xxxxxxxxxxxxx,
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
