Ora-02097...................

[nkumarin001]

Hi,

Sorry i had typed a wrong question previously so i dint know to edit it so i am writing one more question but this is different question,

I came to know that i am using spfile by following query:-

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
2 FROM sys.v_$parameter WHERE name = 'spfile';

Init F
------
SPFILE


I found the value of Sort_Area_Size by following query:-

SQL> sho parameter sort_area_size;

NAME TYPE VALUE
------------------------------------ ----------- ---------
sort_area_size integer 524288


After that i tried to change the value of sort_area_size TO 1GB as follows and i got the following error:-

SQL> ALTER SESSION SET SORT_AREA_SIZE=1073741824;

ERROR:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00600: internal error code, arguments: [925], [hash_area_size],
[-2147483648], [], [], [], [], []


Please help me in changing the value of Sort_Area_Size to 1073741824 and please tell me why i got that error

Regards
Naveen

[nabh4u]

Hi,

Sorry i had typed a wrong question previously so i dint know to edit it so i am writing one more question but this is different question,

I came to know that i am using spfile by following query:-

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
2 FROM sys.v_$parameter WHERE name = 'spfile';

Init F
------
SPFILE


I found the value of Sort_Area_Size by following query:-

SQL> sho parameter sort_area_size;

NAME TYPE VALUE
------------------------------------ ----------- ---------
sort_area_size integer 524288


After that i tried to change the value of sort_area_size TO 1GB as follows and i got the following error:-

SQL> ALTER SESSION SET SORT_AREA_SIZE=1073741824;

ERROR:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00600: internal error code, arguments: [925], [hash_area_size],
[-2147483648], [], [], [], [], []


Please help me in changing the value of Sort_Area_Size to 1073741824 and please tell me why i got that error

Regards
Naveen

try using ALTER SYSTEM SET SORT_AREA_SIZE=1073741824;

hope this might be helpful.