Re: Finding users who have dynamically set SORT_AREA_SIZE

On 7 May 2002 09:55:56 -0700, mikerault_at_earthlink.net (Mike Ault) wrote:

>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

This question can easily be answered by revoking alter session privilege from all the users you suspect doing this.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue May 07 2002 - 16:12:08 CDT