SPFILE parameters

I am looking for a list of SPFILE parameters that can be modified via ALTER SYSTEM
LVL 35
YZlatAsked:
Who is Participating?
 
johnsoneConnect With a Mentor Senior Oracle DBACommented:
Actually according to the documentation link that angelIII posted, 1 is not a valid value in that view.

You would want this:

select name from v$parameter where issys_modifiable != 'FALSE';

However, please read the link that angelIII posted as there is a distinction between the other 2 values (IMMEDIATE and DEFERRED).
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2012.htm
select * from v$parameter where ISSYS_MODIFIABLE = 1;
0
 
YZlatAuthor Commented:
angerIII, that sql statement gave me an error:

SQL> select * from v$parameter where ISSYS_MODIFIABLE = 1;
select * from v$parameter where ISSYS_MODIFIABLE = 1
                                *
ERROR at line 1:
ORA-01722: invalid number
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it may require quotes:
select * from v$parameter where ISSYS_MODIFIABLE = '1';
0
 
YZlatAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.