join x$kglcursor and x$ksmhp - USE_NL

List,
just looked at V$SQL_SHARED_MEMORY
it joins x$kglcursor with x$ksmhp
it selects the chunksize/chunktype etc from the x$ksmhp (memory heap ?) table..
but if i select * from x$ksmhp i get nothing !! , after looking at the view_definition of V$SQL_SHARED_MEMORY, i came to know that ONLY if i use sql hint "USE_NL" , does two tables select rows !!

why is that.. ??

TIA Rahul Received on Tue Aug 01 2000 - 02:20:02 CDT