to check if oracle database is upgrade from 10g to 11g

Below script can the checked to see the database up gradation life cycle.

SQL> l

  1* select * from DBA_REGISTRY_HISTORY

SQL> /

ACTION_TIME                         ACTION               NAMESPACE            VERSION                      ID COMMENTS

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

16-NOV-09 04.22.18.257083 PM        UPGRADE              SERVER               11.1.0.7.0                      Upgraded from 11.1.0.6.0

06-JUN-10 01.36.36.363629 PM        APPLY                SERVER               11.1.0.7                      2 PSU 11.1.0.7.2

06-JUN-10 01.40.09.606668 PM        CPU                                                               6452863 view recompilation

25-MAY-11 05.59.56.069514 PM        VIEW INVALIDATE                                                   8289601 view invalidation

25-MAY-11 06.00.22.484425 PM        UPGRADE              SERVER               11.2.0.2.0                      Upgraded from 11.1.0.7.0

25-MAY-11 07.45.23.622169 PM        VIEW INVALIDATE                                                   8289601 view invalidation

25-MAY-11 07.45.39.435819 PM        UPGRADE              SERVER               11.2.0.2.0                      Upgraded from 11.1.0.7.0

7 rows selected.

SQL> SELECT version, prv_version,banner FROM sys.registry$ ;

VERSION              PRV_VERSION                    BANNER

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

11.2.0.2.0           11.1.0.6.0                     Oracle Database Catalog Views Release 11.2.0.2.0 - 64bit Production

11.2.0.2.0           11.1.0.7.0                     Oracle Database Packages and Types Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle Workspace Manager Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     JServer JAVA Virtual Machine Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle XDK Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle Database Java Packages Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle Expression Filter Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle Text Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle XML Database Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle Rules Manager Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle Multimedia Release 11.2.0.2.0 - Development

VERSION              PRV_VERSION                    BANNER

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

11.2.0.2.0           11.1.0.7.0                     OLAP Analytic Workspace Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Oracle OLAP API Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     OLAP Catalog Release 11.2.0.2.0 - Development

11.2.0.2.0           11.1.0.7.0                     Spatial Release 11.2.0.2.0 - Development

11.2.0.2.0                                          Oracle Enterprise Manager Release 11.2.0.2.0 - Development

3.2.1.00.12          3.0.1.00.12                    Oracle Application Express Release 3.2.1.00.12 - Development

11.1.0.6.0                                          OWB Release 11.1.0.6.0 - Production

18 rows selected.

SQL>