OBJECT_STATUS NULL in V$SQL

Hi All,

What is the meaning of the OBJECT_STATUS NULL in a record of v$SQL? 

The situation is that I see one record with a status VALID with defined 
attributes in V$SQL. Few other (10-20) records with the same SQL_TEXT have 
status NULL, also other attributes are NULL or zero except for loads, 
invalidation, user_opening, child_number and child_address that are filled.


Q2: the attribute USERS_OPENING is documented as "Number of users executing the 
statement"; the majority of "Internet SQL's" compute USERS_OPENING * 250. Any 
comments on the meaning of this attribute?

The database is 9.2 of Sun Solaris.
The cursors are open from a JDBC connection.
The database runs in a MTS mode.


Regards,

Jaromir D.B. Nemec

Other related posts:

  • » OBJECT_STATUS NULL in V$SQL