change permanently the value of the initialization parameter [message #647650] |
Thu, 04 February 2016 10:34 |
|
Nagaram
Messages: 2 Registered: February 2016
|
Junior Member |
|
|
I am wondering if you can help me with one SQL plus statement:
"Write SQL statement you would need to execute in SQL*Plus to change permanently the value of the initialisation parameter CURSOR_SHARING to the value EXACT. Provide detailed explanation."
I know that the type of the open_cursor is dynamic and in its sql should be state SCOPE = MEMORY and SCOPE = SPFILE ( or SCOPE = BOTH) ,for the changes to persist in the future sessions, but I don't know exactly how to do...
so far I've changed the OPEN_CURSORS parameter to 200. (the original value was 300, but because the sql statement stated the SCOPE= MEMORY, the value of 200 was holded for the current session only. Therefore, when I started the new session, the old value, 300, was put it in place again.).
the sql statement which I used was:
ALTER SYSTEM SET open_cursor = 200 SCOPE = MEMORY.
|
|
|
Re: change permanently the value of the initialization parameter [message #647654 is a reply to message #647650] |
Thu, 04 February 2016 11:23 |
John Watson
Messages: 8929 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:the sql statement which I used was:
ALTER SYSTEM SET open_cursor = 200 SCOPE = MEMORY. No it wasn't:
orclz> ALTER SYSTEM SET open_cursor = 200 SCOPE = MEMORY;
ALTER SYSTEM SET open_cursor = 200 SCOPE = MEMORY
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
orclz> please be precise in future.
What is the effect when you use scope=both rather than scope=memory ?
|
|
|
|
|
|