difference between alter system and alter database

[cis_groupie]

Have you heard about SPFILE?

What dbaforlife said is correct - the changes will stay in effect only as long as the database is mounted. HOWEVER, if you wish to make the changes permanent then the SPFile must be amended.