Home » RDBMS Server » Server Administration » Change Parameter value in Oracle 11gR2 (11g R2)
Change Parameter value in Oracle 11gR2 [message #554222] Fri, 11 May 2012 08:25 Go to next message
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?
Re: Change Parameter value in Oracle 11gR2 [message #554223 is a reply to message #554222] Fri, 11 May 2012 08:28 Go to previous messageGo to next message
BlackSwan
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
ALTER SYSTEM SET cursor_sharing='EXACT' SCOPE=SPFILE;;
ALTER system set open_cursors=2500 SCOPE=SPFILE;
ALTER SYSTEM set session_cached_cursors=70 SCOPE=SPFILE;

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: Change Parameter value in Oracle 11gR2 [message #554226 is a reply to message #554223] Fri, 11 May 2012 08:50 Go to previous messageGo to next message
Aysberq
Messages: 2
Registered: May 2012
Junior Member
Thanks
Re: Change Parameter value in Oracle 11gR2 [message #554229 is a reply to message #554226] Fri, 11 May 2012 08:56 Go to previous message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All statements, including ALTER SYSTEM, are described in Database SQL Reference

Regards
Michel
Previous Topic: Cause of invalid objects
Next Topic: insufficient privileges
Goto Forum:
  


Current Time: Wed Apr 14 17:49:27 CDT 2021