Topic: Performance & Tuning >> Sort_Area_Size
|
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.
|
|
|
|
| Navi |
Posted: Aug 03, 2007 08:47:37 AM |
Total Post: 60
Joined: Jun, 2007
|
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
|
|
|
 chitta |
| Posted: Aug 08, 2007 09:40:27 AM |  |
|
Total Post: 4
Joined: Aug, 2007
|
Hi navi,
could u please confirm wheather you were set in session level or database level,
because if you set in session level it will not reflect on next login.
|
|
|
|
|
| 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 | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
