my schema name is HH V$session: SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS MACHINE TERMINAL PROGRAM TYPE SQL_ADDR SQL_HASH_VALUE PREV_SQL PREV_HASH_VALUE MODULE MODULE_HASH ACTION ACTION_HASH CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU CURRENT_QUEUE_DURATION CLIENT_IDENTIFIER -------- ---------- ---------- ---------- -------- ---------- ------------------------------ ---------- ---------- -------- -------- -------- --------- ---------- ------------------------------ ------------------------------ --------- ---------------------------------------------------------------- ---------------- ---------------------------------------------------------------- ---------- -------- -------------- -------- --------------- ------------------------------------------------ ----------- -------------------------------- ----------- ---------------------------------------------------------------- -------------------- ------------- -------------- --------------- ------------- --------- ------------ --- ------------- ---------- --- -------------------------------- -------- -------- -------- ---------------------- ---------------------------------------------------------------- 6B9E9D98 7 56 408 6B9C5388 67 HH 0 2147483644 INACTIVE NONE 67 HH Administrator 3488:2624 ITECH\PASARIS PASARIS USER 6A942430 538405214 6A942430 538405214 0 0 53840 -1 0 0 0 15-NOV-08 693 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0 6B9EB8E0 10 188 416 6B9C5034 67 HH 59 2147483644 6B09333C ACTIVE SHARED 67 HH Administrator 3212:3480 ITECH\PASARIS PASARIS USER 03913DD8 0 69CA9D68 1120244549 PL/SQL Developer 1190136663 Main session 1773317990 55444 -1 0 0 0 15-NOV-08 147 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0 6B9ECB10 12 28 406 6B9C5388 67 HH 0 2147483644 INACTIVE NONE 67 HH dev 3724:3732 ITECH\DELL DELL USER 6AB9AD6C 2111533059 6AEF6E9C 1428100621 0 0 53824 -1 0 0 0 15-NOV-08 3151 NO NONE NONE NO DEFAULT_CONSUMER_GROUP DISABLED ENABLED ENABLED 0 SQL> ============================= v$lock: ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK -------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ---------- 6BA8625C 6BA8626C 2 MR 201 0 4 0 29707 0 6BA86210 6BA86220 2 MR 8 0 4 0 29707 0 6BA861C4 6BA861D4 2 MR 7 0 4 0 29707 0 6BA86178 6BA86188 2 MR 6 0 4 0 29707 0 6BA8612C 6BA8613C 2 MR 5 0 4 0 29707 0 6BA860E0 6BA860F0 2 MR 4 0 4 0 29707 0 6BA86094 6BA860A4 2 MR 3 0 4 0 29707 0 6BA86048 6BA86058 2 MR 2 0 4 0 29707 0 6BA85FFC 6BA8600C 2 MR 1 0 4 0 29707 0 6BA85F18 6BA85F28 3 RT 1 0 6 0 29710 0