jkstill_at_gmail.com wrote:
> 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.
>
The OP doesn't mention what version of Oracle's he's using, but if it's
9i or above why even mess with sort_area_size? You should be using
automatic work area sizing. Set the aggregate pga size to an appropriate
value and imp will use it for it's sort area.
--
To reply by email remove "_nospam"
Received on Wed Sep 28 2005 - 09:38:13 CDT
