Sort_area_size ora-0068
From: Dominic Brooks <dombrooks_at_hotmail.com>
Date: Mon, 1 Sep 2014 12:57:34 +0000
Message-ID: <DUB131-W1877C72C232EAC9F5CA99AA1C60_at_phx.gbl>
Why might a process erratically report an ORA-00068 for a consistent "alter session set sort_area_size"?
Date: Mon, 1 Sep 2014 12:57:34 +0000
Message-ID: <DUB131-W1877C72C232EAC9F5CA99AA1C60_at_phx.gbl>
Why might a process erratically report an ORA-00068 for a consistent "alter session set sort_area_size"?
There is some code setting workarea_size_policy to manual and attempting to set sort_area_size to 2147483647.
The value is hardcoded so it doesn't change. But sometimes the code works, sometimes it doesn't. Code was called from a job on a two node cluster.
Error when raised is consistent:
ORA-00068: invalid value 214783647 for parameter sort_area_size, must be between 1835298655 and 0.
Running the commands manually in a sqlplus session works consistently.
Thoughts?
Cheers,
Dominic
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 01 2014 - 14:57:34 CEST