| dynamic parameter [message #152981] |
Wed, 28 December 2005 04:52  |
gjayasekar
Messages: 45
Registered: October 2005
|
Member |
|
|
Hi,
I want to change dynamic parameter CURSOR=FORCE IN 9.2.0 Version
1.I want to change it for entire system (for all user)
2.How can i change it ie., only in spfile (or) spfile and pfile
3.Which file oracle read first spfile (or) pfile
4.how can i see spfile as text file
5.how can i create pfile from current spfile
Thanks
Jai
|
|
|
|
|
|
| Re: dynamic parameter [message #152994 is a reply to message #152981] |
Wed, 28 December 2005 05:40  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
1)Probably you mean the parameter cursor_sharing , not cursor.
Before you change this setting , you should do good testing..I read in Tom Kyte's expert one on one that, it may not be a good solution to have this change done. Instead , the application should use bind variables.
2) if you decide to change, then you can change by:
alter system set cursor_sharing=force scope=both;
(this will update spfile also)
3) spfile
4)You can not. spfile is binary file.
5)create pfile from spfile;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
