可以查询:v$obsolete_parameter试图

SQL> select * from v$obsolete_parameter;

NAME ISSPECIFIED
---------------------------------------------------------------- -----------
spin_count FALSE
use_ism FALSE
lock_sga_areas FALSE
instance_nodeset FALSE
large_pool_min_alloc FALSE
shared_pool_reserved_min_alloc FALSE
_kspptbl_mem_usage FALSE
enqueue_resources FALSE
lgwr_io_slaves FALSE
arch_io_slaves FALSE
backup_disk_io_slaves FALSE
ops_interconnects FALSE
lm_procs FALSE
ogms_home FALSE
parallel_transaction_resource_timeout FALSE
_lm_statistics FALSE
lm_locks FALSE
lm_ress FALSE
lm_procs FALSE
_lm_multiple_receivers FALSE

如果ISSPECIFIED为true，就表示已经在init.ora中使用了