Direct SGA access problem because of structs' changing start addresses (e.g., x$ksmsp)

I'm trying to write some Haskell code for direct SGA access of - preferredly, as of today - x$ksmsp (sql queries against this table being expensive, possibly...), and for that I'm following the approach from Kyle Hailey, as detailed in the Oracle Wait Interface book.

So I need the struct's start address, but unfortunately, when I query x$ksmsp several times in a row - even from the same sqlplus process - I get different results every time... (Actually, this seems to be the case with most fixed tables, apart from those "fixed" fixed ones as x$ksuse...)

It'd be great if anyone had advice, or an idea, what I could do to get this working all the same (and as to what the reason might be?) It ought to be possible somehow to do this, as I've tried oradebug direct access with x$ksmsp and it worked (of course, it runs in sqlplus, so I don't know...)

Thanks a lot in advance!

Sigrid--
http://www.freelists.org/webpage/oracle-l Received on Tue Jan 07 2014 - 23:33:40 CET