查看oracle版本更新时间,查看oracle数据库当前版本，包括升级的记录

set pages 100 lines 120

col action format a6

col namespace format a10

col version format a10

col comments format a15

col action_time format a30

col bundle_series format a15

alter session set nls_timestamp_format = 'yyyy-mm-dd hh24:mi:ss.ff';

select * from dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS

------------------------------ ------ ---------- ---------- ------------- --------------- ---------------

2014-07-07 22:00:32.410906 VIEW I 8289601 view invalidati

NVALID on

ATE

2014-07-07 22:01:32.949342 UPGRAD SERVER 11.2.0.4.0 Upgraded from 1

E 0.2.0.4.0

2014-07-07 22:02:41.015858 APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0

.2.0

2014-07-10 11:20:14.144058 APPLY SERVER 11.2.0.4 2 PSU PSU 11.2.0.4.2