VIEW: CTXSYS.CTX_PENDING

Source

View Text - Preformatted

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

View Text - HTML Formatted

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