Wednesday, May 21, 2014

How to find db version after upgrading or patching


SQL> show parameters compatibility

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
plsql_v2_compatibility               boolean     FALSE
SQL> show  parameters compat

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
compatible                           string      11.2.0.0.0
plsql_v2_compatibility               boolean     FALSE


SQL> col action_time for a30
SQL> col comments for a60
SQL> set linesize 120
SQL> select action_time, comments from registry$history order by 1 desc,2;

--
With metta
Quang Phan

No comments:

Post a Comment