Re: Finding users who have dynamically set SORT_AREA_SIZE

For heap and memory dumps the typical values are:

    1        PGA
    2        SGA
    4        UGA
    8        CGA    (C for call)

    16 and 32 also have an effect in 9i, IIRC 32 relates     to the large pool but I can't remember what 16 did.

Your are correct about the 'clopen' notation.

I've not come across nm before - perhaps the omission is because the dump is from a heap and not from the static data segment -- but that's a conjecture based on ignorance of the technology.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Yong Huang wrote in message ...


>I wanted to try 12. But I accidentally typed 14, which still gave me

>what I want. I think the levels usually are 2, 4, 8 and 12.

>

>I wonder what the two numbers following "stpdef" and "stsustp_p" mean

>(stpdef is not even in `nm $ORACLE/bin/oracle`)? And why does the

>bracket close with parenthesis? Maybe an address range inclusive at

>the start but exclusive at the end? Oracle "hackers" such as Steve

>Adams or K Gopal may be more interested in those things!

>

>Yong Huang

>