Full list of Oracle parameters:

col name format a35
col value format a35
SELECT name, value
FROM v$parameter
ORDER BY 1;

List modified Oracle Parameters:

col name format a35
col value format a35
SELECT name, value
FROM v$parameter
WHERE isdefault = ‘FALSE’
ORDER BY 1;

List unsupported Oracle parameters:

set pagesize 0
set linesize 100
col ksppinm format a40
col ksppdec format a40
SELECT ksppinm, ksppdesc
FROM x$ksppi
WHERE SUBSTR(ksppinm,1,1) = ‘_’
ORDER BY ksppinm;

Is an SPFILE being used:

show parameter spfile

Create SPFILE from PFILE:

CREATE spfile=<pfile_name> FROM spfile=<spfile_name>;

create spfile from pfile=’initorabase.ora’;

Alter SPFILE:

ALTER SYSTEM SET optimizer_index_cost_adj = 10
COMMENT=’Permanent Change To System Configuration’
SCOPE=BOTH SID=*;

Startup using init.ora ( pfile )  file:

STARTUP PFILE = /u01/oracle/product/ora10/dbs/initorabase.ora