For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi,
Iam using HCM 9.2, PT 8.53, DB.11.2.0.2.
What is this particular navigation does??
PeopleTools >Utilities> Administration >Oracle Data Masking
does this encrypts the value in the specified field??Suggestions welcomed !!
Aravind.
SELECT S.SID, S.USERNAME, S.PROGRAM, S.SQL_ID, S.SQL_ADDRESS, S.SQL_HASH_VALUE, S.SQL_CHILD_NUMBER CN, S.ROW_WAIT_OBJ#, S.ROW_WAIT_FILE#, S.ROW_WAIT_BLOCK#, S.ROW_WAIT_ROW#, L.LMODE, L.REQUEST, L.ID1, L.ID2, L.TYPE, L.BLOCK FROM V$LOCK L, V$SESSION S WHERE (L.ID1, L.ID2, L.TYPE) IN (SELECT ID1, ID2, TYPE FROM V$LOCK WHERE REQUEST > 0) AND L.SID=S.SID;
SID USERNAME PROGRAM SQL_ID SQL_ADDR SQL_HASH_VALUE CN ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LMODE REQUEST ID1 ID2 TY BLOCK --- -------- ----------- ------------- -------- -------------- -- ------------- -------------- --------------- ------------- ----- ------- ----- --- -- ----- 307 USER2 sqlplus.exe 4rtg0hv0atfkx 224E2B7C 3232545373 0 -1 0 0 0 3 5 82913 0 TM 1 314 USER3 sqlplus.exe cv338j6z2530g 224DAE38 3189935119 0 -1 0 0 0 0 3 82913 0 TM 0 320 TESTUSER sqlplus.exe 0vbusv12hnbk6 22480E10 1158295110 0 12517 1 29656 0 3 0 82913 0 TM 1
SELECT s.sid ||','||s.serial# AS "Sid/Serial", s.username AS "Name", l.type AS "lkType", decode(l.lmode,1,'none',2,'SS',3,'SX',4,'S',5,'SSX',6,'X',null) "lkMode", decode(l.request,1,'none',2,'SS',3,'SX',4,'S',5,'SSX',6,'X',null) "lkReq", l.ctime "Seconds", decode(l.block,1,'Yes',NULL) AS "Blocking?", l.id1, l.id2, o.object_name "Object" FROM v$lock l, v$session s, dba_objects o, v$locked_object lko WHERE s.sid=l.sid AND lko.session_id=s.sid AND -- (l.request != 0 OR l.block=1) AND lko.object_id=o.object_id ORDER BY l.ctime DESC, o.object_name;