Database Tuning (MOSC)

MOSC Banner

why Object_status in v$sqlarea becomes VALID_UNAUTH

edited Feb 2, 2010 10:52PM in Database Tuning (MOSC) 1 commentAnswered
 Hi ,

couple of days ago,I  created sqlprofile for some queires .query was running smoothly in earlier days but today client complains that query has not retured any records back to the client .

i can see  object_status=VALID_UNAUTH when perform following query

select object_status from v$SQLAREA where sql_id = 'xxxxx'  showing

why it is so..

Many thanks

Digivjay

why it is so..

Many thanks

Digivjay

why it is so..

Many thanks

Digivjay

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center