Re: Is it possible to read a SGA's memory architecture ?

Norman Dunbar wrote:
>
> As far as I am aware, only two companies in the entire world have direct
> access to Oracles SGA architechture. One is Oracle, the other is Precise
> who market an app which can monitor Oracle without having to run any SQL
> against the system being monitored. I believe it originated in Israel
> and they decoded the SGA by themselves. When Oracle found out, they were
> 'so impressed' they let them have the info whnever they changes the
> internals.
>
> Bear in mind that the above is part of the 'sales speak' for Precise -
> and should be taken with the appropriate amount of salt !
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: pseed72_at_yahoo.co.kr (yun chul jang) [mailto:pseed72_at_yahoo.co.kr]
> Posted At: Monday, October 21, 2002 9:11 AM
> Posted To: server
> Conversation: Is it possible to read a SGA's memory architecture ?
> Subject: Is it possible to read a SGA's memory architecture ?
>
> Hi !
> I'm trying to read a SGA's memory architecture through any language.
> But, it's a little difficult thing for me.
> If you have some tips, please let me know.
> In advance, thank you.

As I've seen done by an OakTable friend, you can truss oracle and discover how it attaches to the SGA. Then with a little bit of fiddling around the X$ tables, you can map the "ADDR" columns to real physical memory addresses.

You got be a little weird to understand it all...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."