How to find obsolete parameters using by database

How to find obsolete parameters using by database[@more@]

可以查询: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/