Re: Any easy way to chenge the SORT_AREA_SIZE setting of import session?

sybrandb_at_yahoo.com wrote:
> Ever heard of the ALTER SYSTEM set sort_area_size = ... deferred
> command?
> Probably not, because you don't read manuals, you start screwing up
> exports right away.
>

That would probably be fine if you want all other new sessions to get the same value for SORT_AREA_SIZE.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_2013.htm#i2061284

To target a particular user a logon trigger will do the trick.

Perhaps in the future you should check the manual and provide a reference. Received on Wed Sep 28 2005 - 08:58:55 CDT