Solved

SPFILE parameters

Posted on 2013-01-10
5
355 Views
Last Modified: 2013-01-11
I am looking for a list of SPFILE parameters that can be modified via ALTER SYSTEM
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 100 total points
ID: 38762912
http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2012.htm
select * from v$parameter where ISSYS_MODIFIABLE = 1;
0
 
LVL 35

Author Comment

by:YZlat
ID: 38763400
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38763880
it may require quotes:
select * from v$parameter where ISSYS_MODIFIABLE = '1';
0
 
LVL 35

Accepted Solution

by:
johnsone earned 250 total points
ID: 38764117
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
 
LVL 35

Author Closing Comment

by:YZlat
ID: 38766875
Thanks!
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ER Diagram 3 52
how to use l_instance in the host command 7 35
Performance Issue in Oracle 3 45
Force XMLSEQUENCE to return empty tags for null values. 10 45
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question