OraFAQ Forum: Server Administration » Change Parameter value in Oracle 11gR2

Home » RDBMS Server » Server Administration » Change Parameter value in Oracle 11gR2 (11g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change Parameter value in Oracle 11gR2 [message #554222]

Fri, 11 May 2012 08:25

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?

Report message to a moderator

Re: Change Parameter value in Oracle 11gR2 [message #554223 is a reply to message #554222]

Fri, 11 May 2012 08:28

BlackSwan
Messages: 26766
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/

Report message to a moderator