Re: Finding users who have dynamically set SORT_AREA_SIZE

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

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1020899946.2581.0.nnrp-08.9e984b29_at_news.demon.co.uk>...
> Was the 14 a slip of the fingers. 4 - for UGA is
> what you want, 14 will include the fixed SGA and
> could be a bit large.
>
> BTW - the 00010000 following the sort_area_size
> is the sort_area_retained_size.
>
> --
> 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 ...
> >oradebug dump global_area 14
> >exit
> >Look at the trace file in udump. The following line
> >
> >stpdef stsustp_p [1A39218, 1A39240) = 000F4240 00010000 00000002
> >0000001B ...
> >
> >says the sort_area_size of that session is F4240 bytes (i.e. 1000000
> >bytes).
Received on Thu May 09 2002 - 12:21:50 CDT