1.To get the RCU version of the schemas installed.
SQL>SELECT OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY
Result
————————————————————————-
DEVR2_BIPLATFORM 11.1.1.6.0 VALID N
DEV3_BIPLATFORM 11.1.1.6.0 VALID N
DEV_BIPLATFORM 11.1.1.6.0 VALID N
DEV3_IAU 11.1.1.6.0 VALID N
DEVR2_IAU 11.1.1.6.0 VALID N
DEVR2_MDS 11.1.1.6.0 VALID N