column comp_name for a40
column comp_id for a20
column status for a20
select comp_id, comp_name, version, status from dba_registry;
set linesize 120
select * from v$option;
reference:
http://amoratech.wordpress.com/2011/07/22/how-to-find-the-installed-components-of-an-oracle-database/
http://javeedkaleem.blogspot.com/2010/03/install-database-components.html
No comments:
Post a Comment