Re: Direct SGA access problem because of structs' changing start addresses (e.g., x$ksmsp)
- From: "keydana@xxxxxx" <keydana@xxxxxx>
- To: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- Date: Fri, 17 Jan 2014 21:08:54 +0100
Hi Marcin,
> As far as I remember I never found out how to find a starting address without
> query a instance
Yes, I was wondering about that, too (it would be great to not have any sqlplus
step first) - but if you say you've already researched that, I guess it's not
feasible...
>
> If you are interested in I can try to find these sources somewhere but I'm
> wondering why you are looking into that topic now when ASH is build in into
> Oracle or you can run S-ASH or other similar tools from SQL.
Well I guess, it's just "for fun" (and looking for a way to do some
programming, privately, connected somehow to the job ;-))
And if it doesn't cause too much trouble, of course it would be interesting to
see your code :-)
Thanks!
Sigrid
>
> regards,
> Marcin
>
>
>
> On Tue, Jan 7, 2014 at 10:33 PM, keydana@xxxxxx <keydana@xxxxxx> wrote:
> Hi,
>
> 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--
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Marcin Przepiorowski
> http://oracleprof.blogspot.com
Other related posts:
