select
OWNER, -- OWNER VARCHAR2(31)
TABNAME, -- TABNAME VARCHAR2(31)
INDEXNAME, -- INDEXNAME VARCHAR2(31)
SUBNAME, -- SUBNAME VARCHAR2(31)
MESSAGE_NUM, -- MESSAGE_NUM NUMBER
MESSAGE -- MESSAGE VARCHAR2(4000)
from
GV$LOADISTAT
where
INST_ID = USERENV('Instance')