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 -> Identify child_number for a session?

Identify child_number for a session?

From: Richard Kuhler <noone_at_nowhere.com>
Date: Fri, 04 Apr 2003 23:35:44 GMT
Message-ID: <kFoja.27817$Hx.17741736@twister.socal.rr.com>


How do you identify the CHILD_NUMBER for a given session? V$SESSION has SQL_ADDRESS and SQL_HASH_VALUE but I don't see CHILD_NUMBER. If two different sessions submit the same query but receive different plans then they will have different CHILD_NUMBERs and different V$SQL entries. However, I don't see how you can tell which CHILD_NUMBER each session is using. Ultimately, I want to distinguish between the plans in V$SQL_PLAN using that CHILD_NUMBER information.

Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production With the Partitioning and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production

Thanks,
Richard Kuhler Received on Fri Apr 04 2003 - 17:35:44 CST

Original text of this message

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