VIEW: CTXSYS.CTX_USER_PENDING

Source

View Text - Preformatted

select /*+ ORDERED USE_NL(i p d)*/
       idx_name  pnd_index_name,
       ixp_name  pnd_partition_name,
       pnd_rowid,
       pnd_timestamp
  from dr$index i, dr$index_partition p, dr$pending d
 where idx_id = ixp_idx_id
   and pnd_pid = ixp_id
   and pnd_cid != 0
   and pnd_cid = idx_id
   and idx_owner# = userenv('SCHEMAID')
UNION ALL
select /*+ ORDERED USE_NL(i d) */
       idx_name  pnd_index_name,
       null      pnd_partition_name,
       pnd_rowid,
       pnd_timestamp
  from dr$index i, dr$pending d
 where pnd_pid = 0
   and pnd_cid = idx_id
   and idx_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL(I P D)*/ IDX_NAME PND_INDEX_NAME
, IXP_NAME PND_PARTITION_NAME
, PND_ROWID
, PND_TIMESTAMP
FROM DR$INDEX I
, DR$INDEX_PARTITION P
, DR$PENDING D
WHERE IDX_ID = IXP_IDX_ID
AND PND_PID = IXP_ID
AND PND_CID != 0
AND PND_CID = IDX_ID
AND IDX_OWNER# = USERENV('SCHEMAID') UNION ALL SELECT /*+ ORDERED USE_NL(I D) */ IDX_NAME PND_INDEX_NAME
, NULL PND_PARTITION_NAME
, PND_ROWID
, PND_TIMESTAMP
FROM DR$INDEX I
, DR$PENDING D
WHERE PND_PID = 0
AND PND_CID = IDX_ID
AND IDX_OWNER# = USERENV('SCHEMAID')