Re: Finding users who have dynamically set SORT_AREA_SIZE

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).