create user command is hanging
create user command is hanging.
SQL> select osuser,last_call_et,sql_id,username,sid,serial#,event,program,blocking_session from v$session where status='ACTIVE' and username='SYS' and type<>'BACKGROUND';
OSUSER LAST_CALL_ET SQL_ID USERNAME SID SERIAL# EVENT PROGRAM BLOCKING_SESSION
------------------------------ ------------ ------------- ------------------------------ ---------- ---------- ---------------------------------------------------------------- ------------------------------------------------ ----------------
oracle 843948 0raht0h154b63 SYS 49 56887 library cache: mutex X oracle@am-oradbdev-ux01 (J002) 88
oracle 843836 bkryyh4vf4p55 SYS 55 60775 library cache: mutex X oracle@am-oradbdev-ux01 (J004) 88
oracle 423 ad7b22x4k91n6 SYS 88 14857 library cache: mutex X sqlplus@am-oradbdev-ux01 (TNS V1-V3) 33
oracle 0 4p0cb5sfchax4 SYS 93 34403 SQL*Net message to client sqlplus@am-oradbdev-ux01 (TNS V1-V3)
0