Oracle Database Discussions

hi all,

As you know IsSys_Modifiable field in v$parameter has three values, DEFERRED , IMMEDIATE and FALSE.

in oracle documentation : http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/dynviews_2087.htm#REFRN30176
says that

DEFERRED means, you can change this parameter regardless of the type of parameter file used to start the instance. even SPFILE or PFILE.
FALSE means, you can NOT change this parameter unless a server parameter file was used to start the instance. it must be SPFILE.

but for example, RECYCLEBIN parameter listed as DEFERRED which means, I can change this paramter with "Alter system" and change will be effected on subsequenct sessions. It does NOT. I can not change it just "Alter System" command, I must use scope=spfile statement too and if I started my instance from pfile so I can not change it with Alter system again.

so I can not see any difference between DEFERRED and FALSE ? parameters which has both value has same effect.