SELECT SID, -- SID NUMBER SERIAL#, -- SERIAL# NUMBER CURRMVOWNER, -- CURRMVOWNER VARCHAR2(31) CURRMVNAME -- CURRMVNAME VARCHAR2(31) FROM GV$MVREFRESH