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

--
http://www.freelists.org/webpage/oracle-l