Topic: Performance & Tuning >> Ora-02097...................
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Ora-02097................... |
| Navi |
Posted: Aug 03, 2007 10:20:10 AM |
Total Post: 60
Joined: Jun, 2007
|
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 |
|
|
 Mohammed Taj |
| Posted: Aug 04, 2007 12:44:59 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
What is your Oracle Version ?
and why you want to increase sort_area_size upto 1 GB.
what is your pga size ?
and Ora-00600 means call oracle support or submit SR.
Regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
