Sort_area_size ora-0068
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Sep 2014 12:57:34 +0000
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
Other related posts:
