I have executed this statement in Oracle DB.ALTER SYSTEM SET PROCESSES=1000 SCOPE=SPFILE; Can I bring this change in effect without DB restart? - Quora
Differences Between PFILEs and SPFILEs in Oracle Database Initialization Parameter Files | PDF | Oracle Database | Operating System
SQL Statements: ALTER SESSION to ALTER SYSTEM, 3 of 3
Introduction SPFILE et INIT.ORA - Trivadis
Chapitre 07 Gestion de L'instance | PDF | Base de données Oracle | Mémoire (informatique)
ALTER SYSTEM
Oracle Default Scope in Alter Statement - Dot Net Tutorials