select sessionId , tokenId , expiryTime, expiryOffset from MDSYS.TokenSessionMap_t$ where (tokenId in (select tokenId from MDSYS.CurrentSessionTokenMap$ where sessionId in (select dbms_session.unique_session_id from dual))) or expiryTime < sysdate
SELECT SESSIONID
, TOKENID
, EXPIRYTIME
, EXPIRYOFFSET
FROM MDSYS.TOKENSESSIONMAP_T$
WHERE (TOKENID IN (SELECT TOKENID
FROM MDSYS.CURRENTSESSIONTOKENMAP$
WHERE SESSIONID IN (SELECT DBMS_SESSION.UNIQUE_SESSION_ID
FROM DUAL))) OR EXPIRYTIME < SYSDATE
|
|
|