Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Identify child_number for a session?
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