Re: v$open_cursor.sql_text showing "table_4_200_5e14_0_0_0 "??

In article <3cb1d02c.1004489319_at_newsfeeds-goliath.1usenet.net>, oraperf_at_yahoo.com says...
>
>No ideas, but I'd like to second the interest in what these queries
>are. I haven't seen it myself but I have had several people ask me.
>From what little info I have it seems to be related to Vantive.
>

not related to vantive. see

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3311300131016

>Best Wishes
>Kyle Hailey
>
>On 6 Apr 2002 05:14:50 -0800, jmsalvo_at_ihug.com.au (john) wrote:
>
>>I am trying to figure out why v$open_cursor.sql_text is showing things
>>like "table_4_xxxx_x_x_x_x", the reason being that these entries in
>>v$open_cursor has the most number of entries in v$open_cursor.
>>database clients are JDBC Thin drivers against Oracle 8.1.7.x on
>>Solaris 8.
>>
>>Since these tables are not really tables ( nor are they real objects
>>in the sense that they are not in ALL_OBJECTS ), here is what I can
>>just assume:
>>
>>1) Parallel query execution -- I had a few tables / indexes that had a
>>DEGREE of default. But even after ALTERing them to be NOPARALLEL ( and
>>even restarting the clients using these tables ), the entries are
>>still there.
>>
>>2) Partitioned tables -- Although I have partitioned tables, these
>>tables are owned by another user and are not accessed from the
>>offending client.
>>3) (B)LOB -- Recalling that LOBs are moved out of the table ( but
>>still in the tablespace ) when the size gets to 4K or more, this is
>>the most likely candidate, although the documentation does not
>>specifically say how LOBs are named when stored outside of the table.
>>However, I also recall reading the LOBs are named with something like
>>SYS$xxxxx.
>>
>>Any ideas?
>
>Best Wishes
>Kyle Hailey
>
>http://oraperf.sourceforge.net
>
>
>-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
>------== Over 100,000 Newsgroups - Ulimited downloads - 19 servers ==-----

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp