Change Parameter value in Oracle 11gR2 [message #554222] |
Fri, 11 May 2012 08:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6c8d0894c328cc40df02cf2450d1c128?s=64&d=mm&r=g) |
Aysberq
Messages: 2 Registered: May 2012
|
Junior Member |
|
|
Hello everyone.
I want to change cursor_sharing, open_cursors and session_cached_cursors parameter values for SPFILE (Only SPFILE) using SQL Query.
I have found following SQL Queries, but I don't know these queries are only for SPFILE or not.
ALTER SESSION SET cursor_sharing='EXACT';
ALTER system set open_cursors=2500;
ALTER SESSION set session_cached_cursors=70;
I need SQL Queries only for SPFILE.
Can anyone help me?
|
|
|
|
|
|