Find Version of Oracle Client / Database/ Last PSU Applied / Components Installed
Quick SQL's to find the versions
Answer
Select * from v$version;
select * from product_component_version;
Answer
select * from dba_registry_history;
Question
How to find the client version;
Answer
SELECT DISTINCT client_version FROM v$session_connect_info;
Question
How to find the components installed in the Oracle
database
Answer
select * from dba_registry;
Good Luck!
Question:
How
to find the version of Oracle Database;Answer
Select * from v$version;
select * from product_component_version;
Question
How to find the PSU/CPU version that was last
applied to database;Answer
select * from dba_registry_history;
Answer
SELECT DISTINCT client_version FROM v$session_connect_info;
Answer
select * from dba_registry;
No comments:
Post a Comment