select
  inst_id,                                 -- INST_ID NUMBER
  kjilkftlkp,                              -- HANDLE RAW(8)
  kjilkftgl,                               -- GRANT_LEVEL VARCHAR2(9)
  kjilkftrl,                               -- REQUEST_LEVEL VARCHAR2(9)
  kjilkftrn1,                              -- RESOURCE_NAME1 VARCHAR2(30)
  kjilkftrn2,                              -- RESOURCE_NAME2 VARCHAR2(30)
  kjilkftpid,                              -- PID NUMBER
  kjilkftxid0,                             -- TRANSACTION_ID0 NUMBER
  kjilkftxid1,                             -- TRANSACTION_ID1 NUMBER
  kjilkftgid,                              -- GROUP_ID NUMBER
  kjilkftoodd,                             -- OPEN_OPT_DEADLOCK NUMBER
  kjilkftoopt,                             -- OPEN_OPT_PERSISTENT NUMBER
  kjilkftoopo,                             -- OPEN_OPT_PROCESS_OWNED NUMBER
  kjilkftoonxid,                           -- OPEN_OPT_NO_XID NUMBER
  kjilkftcogv,                             -- CONVERT_OPT_GETVALUE NUMBER
  kjilkftcopv,                             -- CONVERT_OPT_PUTVALUE NUMBER
  kjilkftconv,                             -- CONVERT_OPT_NOVALUE NUMBER
  kjilkftcodv,                             -- CONVERT_OPT_DUBVALUE NUMBER
  kjilkftconq,                             -- CONVERT_OPT_NOQUEUE NUMBER
  kjilkftcoep,                             -- CONVERT_OPT_EXPRESS NUMBER
  kjilkftconddw,                           -- CONVERT_OPT_NODEADLOCKWAIT NUMBER
  kjilkftconddb,                           -- CONVERT_OPT_NODEADLOCKBLOCK NUMBER
  kjilkftwq,                               -- WHICH_QUEUE NUMBER
  kjilkftls,                               -- STATE VARCHAR2(64)
  kjilkftaste0,                            -- AST_EVENT0 NUMBER
  kjilkfton,                               -- OWNER_NODE NUMBER
  kjilkftblked,                            -- BLOCKED NUMBER
  kjilkftblker                             -- BLOCKER NUMBER
from
  x$kjilkft
union all
select
  inst_id,                                 -- INST_ID NUMBER
  kjbllockp,                               -- HANDLE RAW(8)
  kjblgrant,                               -- GRANT_LEVEL VARCHAR2(9)
  kjblrequest,                             -- REQUEST_LEVEL VARCHAR2(9)
  kjblname,                                -- RESOURCE_NAME1 VARCHAR2(30)
  kjblname2,                               -- RESOURCE_NAME2 VARCHAR2(30)
  0,                                       -- PID NUMBER
  0,                                       -- TRANSACTION_ID0 NUMBER
  0,                                       -- TRANSACTION_ID1 NUMBER
  0,                                       -- GROUP_ID NUMBER
  0,                                       -- OPEN_OPT_DEADLOCK NUMBER
  1,                                       -- OPEN_OPT_PERSISTENT NUMBER
  0,                                       -- OPEN_OPT_PROCESS_OWNED NUMBER
  1,                                       -- OPEN_OPT_NO_XID NUMBER
  0,                                       -- CONVERT_OPT_GETVALUE NUMBER
  0,                                       -- CONVERT_OPT_PUTVALUE NUMBER
  0,                                       -- CONVERT_OPT_NOVALUE NUMBER
  0,                                       -- CONVERT_OPT_DUBVALUE NUMBER
  0,                                       -- CONVERT_OPT_NOQUEUE NUMBER
  0,                                       -- CONVERT_OPT_EXPRESS NUMBER
  0,                                       -- CONVERT_OPT_NODEADLOCKWAIT NUMBER
  0,                                       -- CONVERT_OPT_NODEADLOCKBLOCK NUMBER
  kjblqueue,                               -- WHICH_QUEUE NUMBER
  kjbllockst,                              -- STATE VARCHAR2(64)
  0,                                       -- AST_EVENT0 NUMBER
  kjblowner,                               -- OWNER_NODE NUMBER
  kjblblocked,                             -- BLOCKED NUMBER
  kjblblocker                              -- BLOCKER NUMBER
from
  x$kjbl