Re: Finding users who have dynamically set SORT_AREA_SIZE

It seems unlikely that you will be able
to get this unless Oracle supplies a
packaged interface.

I would assume that since the modified
sort_area_size is a session-related value then it would have to be in the UGA,
and therefore only visible to the current session.

Obviously you could do a use oradebug,
attach to another session and dump its
global_area, but I don't think that's what you would consider an appropriate solution.

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



Mike Ault wrote in message
<37fab3ab.0205070855.3ed63147_at_posting.google.com>...


>Ok all you senior gurus out there, I have reached a dead end on this,

>how to determine using a select statement, without having to audit,

>not using V$SQLAREA or its cronies, whether someone has set their

>SORT_AREA_SIZE (or HASH_AREA_SIZE) dynmaically to a higher, system

>threatening value? Is there an underlying K structure that has this

>information available?

>

>Mike