cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

spfile.ora in 3.4 m060 - SUMMARY

spfile.ora in 3.4 m060 - SUMMARY

Sorry to take so long to summarize this one. I got two responses. Thank you Randy and Tiemo.


Using sqlplus works good:



Some examples to set parameters. Notice the scope...

sqlplus system/manager

alter system set optimizer_mode=RULE scope=spfile; alter system set cursor_sharing=similar scope=both; quit



To get values of particular parameters:

sqlplus system/manager

show parameter optimizer_mode;

show parameter cursor_sharing;

quit



To show values of all parameters:

sqlplus system/manager

show parameter;

quit;


read that to understand:
Announcements
LiveWorx Call For Papers Happening Now!