select inst_id, -- INST_ID NUMBER phadd_kkocs, -- ADDRESS RAW(8) hashv_kkocs, -- HASH_VALUE NUMBER sqlid_kkocs, -- SQL_ID VARCHAR2(13) childno_kkocs, -- CHILD_NUMBER NUMBER bucketid_kkocs, -- BUCKET_ID NUMBER count_kkocs -- COUNT NUMBER from X$KKOCS_HISTOGRAM