VIEW: CTXSYS.CTX_USER_SESSION_SQES

Source

View Text - Preformatted

select u.name sqe_owner,
       s.sqe_name sqe_name,
       s.sqe_query sqe_query
  from sys.user$ u, table(drvxmd.ctx_sqe_tbl_func) s
  where u.user# = s.sqe_owner# and
        u.user# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT U.NAME SQE_OWNER
, S.SQE_NAME SQE_NAME
, S.SQE_QUERY SQE_QUERY
FROM SYS.USER$ U
, TABLE(DRVXMD.CTX_SQE_TBL_FUNC) S
WHERE U.USER# = S.SQE_OWNER# AND U.USER# = USERENV('SCHEMAID')