9i: sql child number not in v$session
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 1 Sep 2009 10:15:16 -0700
Is there anyway to get the sql child number for a query executed by a
session after the query has been executed?
I can get the hash_value from v$session for another session for the las
query the executed but can't get the child number.
If the query is running I can get the child_address from x$kgllk, ie
select kgllkhdl
from x$kgllk kgl, v$session s
where kgl.kglnahsh=s.sql_hash_value and
kgl.kgllksnm=&sid and
kgl.kglhdnsp=0 and kgl.kglhdpar != kgl.kgllkhdl;
But this only works while the query is running.
I can still get the sql_hash_value from v$session after the query has
finished, but haven't found a way to get the child_number.
Other related posts:
