GV$LOADPSTAT select inst_id, -- INST_ID NUMBER klcpxon, -- OWNER VARCHAR2(31) klcpxtn, -- TABNAME VARCHAR2(31) klcpxpn, -- PARTNAME VARCHAR2(31) klcpxrld -- LOADED NUMBER from x$klpt