OraFAQ Forum: SQL & PL/SQL » V$SQL object_status INVALID

Home » SQL & PL/SQL » SQL & PL/SQL » V$SQL object_status INVALID_UNAUTH (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

V$SQL object_status INVALID_UNAUTH [message #561486]

Mon, 23 July 2012 05:27

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Hi,

One of my query was running since 5 hours, while it should ideally take 10 minutes.

Execution plan seems to be OK. But while investigating I found object_status is "INVALID_UNAUTH" in v$sql for that query. What does that mean, is this status anyhow affecting the execution of my query? and when this status comes into picture?

Thanks,
Manu

Report message to a moderator

Re: V$SQL object_status INVALID_UNAUTH [message #561496 is a reply to message #561486]

Mon, 23 July 2012 05:48

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

https://kr.forums.oracle.com/forums/thread.jspa?threadID=2222109
http://dioncho.wordpress.com/tag/invalid_unauth/

Regards
Michel

Report message to a moderator

Re: V$SQL object_status INVALID_UNAUTH [message #561503 is a reply to message #561496]

Mon, 23 July 2012 06:10

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

I already googled and gone thorugh these articles.

According to them, objects and cursor invalidates if you change the base. But its not my case. Please help me to dig into it.

Thanks,
Manu

Report message to a moderator

Re: V$SQL object_status INVALID_UNAUTH [message #561506 is a reply to message #561503]

Mon, 23 July 2012 06:27

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What's the problem?
For me, a cursor is valid or not, the reason it is not valid is only interesting for Oracle.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 9i
Next Topic:	SQL query to fetch steps of a test having recursive calls to other tests (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 03 15:58:53 CDT 2026