Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$OPEN_CURSOR SQL_TEXT field - what does it mean when it shows table_4_xxx_xxx_xxxx_x_x_x??

Re: V$OPEN_CURSOR SQL_TEXT field - what does it mean when it shows table_4_xxx_xxx_xxxx_x_x_x??

From: john <jmsalvo_at_ihug.com.au>
Date: 6 Apr 2002 05:01:24 -0800
Message-ID: <fa6269d2.0204060501.145cd8e7@posting.google.com>


Have you found out what these "table_4_xxx" mean?

vfonger_at_socketware.com (Vivian Fonger) wrote in message news:<6c4b2c3e.0203281039.4a47e8a3_at_posting.google.com>...
> I am trying to monitor open cursor in our Oracle production system.
> When I am checking out the v$open_cursor table, at the SQL_TEXT field,
> it shows me that some of the inactive processes are opening up cursor
> with SQL_TEXT looks like "table_4_200_1e08_0_0_0". I want to know
> what does it means?? I would really appreciate if anyone can provide
> me some inputs on this issue. Thanks.
Received on Sat Apr 06 2002 - 07:01:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US