Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> V$sql - object_status
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-lReceived on Thu Jan 25 2007 - 09:28:30 CST
![]() |
![]() |