Home » RDBMS Server » Performance Tuning » Sort Area Size - ORA-600 & ORA-02097 (merged)
Sort Area Size - ORA-600 & ORA-02097 (merged) [message #256217] Fri, 03 August 2007 07:55 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

I am using pfile and i changed the value of Sort_Area_Size from 524288 to 1073741824(1GB) but when i started the database and checked the value of Sort_Area_Size it was showing 524288.

Please help me in this one to change the value of Sort_Area_Size from 524288 to 1073741824(1GB) and tell me why i was getting 524288 instead of 1073741824(1GB).


Regards,
Naveen
Re: Sort_Area_Size [message #256233 is a reply to message #256217] Fri, 03 August 2007 08:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post (copy and paste) the full execution of what you did.
Not try to explain it, you likely did something wrong that you can't see and so can't explain us and so we can't see it.

And post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Fri, 03 August 2007 08:31]

Report message to a moderator

Ora-02097................... [message #256245 is a reply to message #256217] Fri, 03 August 2007 09:25 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

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
Re: Ora-02097................... [message #256253 is a reply to message #256245] Fri, 03 August 2007 10:23 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Bug No. 2205276

Use a smaller value
Previous Topic: Problem when installing statspack
Next Topic: Monthly Avg. CPU Time usage.. meaningful?
Goto Forum:
  


Current Time: Wed Dec 07 03:23:12 CST 2016

Total time taken to generate the page: 0.10766 seconds