select
OWNER, -- OWNER VARCHAR2(31)
TABNAME, -- TABNAME VARCHAR2(31)
PARTNAME, -- PARTNAME VARCHAR2(31)
LOADED -- LOADED NUMBER
from
GV$LOADPSTAT
where
inst_id = USERENV('Instance')