可以查询: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中使用了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/188692/viewspace-903474/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/188692/viewspace-903474/