Sort Area Size - ORA-600 & ORA-02097 (merged) [message #256217] |
Fri, 03 August 2007 07:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
naveenkumar001
Messages: 62 Registered: July 2007 Location: Bangalore
|
Member |
![navik001](/forum/theme/orafaq/images/yahoo.png)
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
naveenkumar001
Messages: 62 Registered: July 2007 Location: Bangalore
|
Member |
![navik001](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|
|