RE: join x$kglcursor and x$ksmhp - USE_NL

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 1 Aug 2000 20:52:18 +1000
Message-Id: <10576.113466@fatcity.com>

Hi Rahul,

X$KSMHP is not a fixed structure. It is dynamic (as are quite a lot of the X$ tables). What it returns depends on which heap descriptor you join to it. It is effectively a function returning the contents of an arbitrary heap that takes the heap descriptor as its argument. Thus the need for the use_nl hint.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Tuesday, 1 August 2000 17:20
To: 'Oracle List I'
Cc: 'Oracle List II'
Subject: 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

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Tue Aug 01 2000 - 05:52:18 CDT