RE: addresses and offsets in x$

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 7 Aug 2000 23:39:48 +1000
Message-Id: <10582.113967@fatcity.com>

Hi Rahul,

Under Oracle7 this was easy because the conversions were all done implicitly, but now you need to make it all explicit. For example ...

    where raw1 = hextoraw(ltrim(to_char(to_number(rawtohex(raw2), 'XXXXXXXX') + &offset, 'XXXXXXXX')))

Happy hacking,
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: Monday, 7 August 2000 18:50
To: 'Oracle List I'; 'Oracle List II'
Subject: addresses and offsets in x$

List,
to find which lib objects are in the reserved area, must join x$ksmspr.KSMCHPTR to x$kglob.KGLHDADR BUT... the KSMCHPTR points to 28 bytes inside the KGLHDADR. How to join these structures allowing for this offset ?

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 Mon Aug 07 2000 - 08:39:48 CDT