Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

SPFILE parameters

I am looking for a list of SPFILE parameters that can be modified via ALTER SYSTEM
0
YZlat
Asked:
YZlat
  • 2
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]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
 
johnsoneSenior 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
 
YZlatAuthor Commented:
Thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now