select * from v$session where audsid=userenv('sessionid');获得当前用户的链接方式
2016-01-13 10:32:08 访问(2164) 赞(0) 踩(0)
SQL> select * from v$session where audsid=userenv('sessionid');
SADDR SID SERIAL# AUDSID PADDR USER# USERNAME COMMAND OWNERID TADDR LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS MACHINE PORT TERMINAL PROGRAM TYPE SQL_ADDRESS SQL_HASH_VALUE SQL_ID SQL_CHILD_NUMBER SQL_EXEC_START SQL_EXEC_ID PREV_SQL_ADDR PREV_HASH_VALUE PREV_SQL_ID PREV_CHILD_NUMBER PREV_EXEC_START PREV_EXEC_ID PLSQL_ENTRY_OBJECT_ID PLSQL_ENTRY_SUBPROGRAM_ID PLSQL_OBJECT_ID PLSQL_SUBPROGRAM_ID MODULE MODULE_HASH ACTION ACTION_HASH CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# TOP_LEVEL_CALL# LOGON_TIME LAST_CALL_ET PDML_ENABLED FAILOVER_TYPE FAILOVER_METHOD FAILED_OVER RESOURCE_CONSUMER_GROUP PDML_STATUS PDDL_STATUS PQ_STATUS CURRENT_QUEUE_DURATION CLIENT_IDENTIFIER BLOCKING_SESSION_STATUS BLOCKING_INSTANCE BLOCKING_SESSION FINAL_BLOCKING_SESSION_STATUS FINAL_BLOCKING_INSTANCE FINAL_BLOCKING_SESSION SEQ# EVENT# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS WAIT_TIME SECONDS_IN_WAIT STATE WAIT_TIME_MICRO TIME_REMAINING_MICRO TIME_SINCE_LAST_WAIT_MICRO SERVICE_NAME SQL_TRACE SQL_TRACE_WAITS SQL_TRACE_BINDS SQL_TRACE_PLAN_STATS SESSION_EDITION_ID CREATOR_ADDR CREATOR_SERIAL# ECID
---------------- ---------- ---------- ---------- ---------------- ---------- ------------------------------ ---------- ---------- ---------------- ---------------- -------- --------- ---------- ------------------------------ ------------------------------ ------------------------ ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- -------------- ------------- ---------------- -------------- ----------- ---------------- --------------- ------------- ----------------- --------------- ------------ --------------------- ------------------------- --------------- ------------------- ------------------------------------------------ ----------- -------------------------------- ----------- ---------------------------------------------------------------- -------------------- ------------- -------------- --------------- ------------- --------------- ----------- ------------ ------------ ------------- --------------- ----------- -------------------------------- ----------- ----------- --------- ---------------------- ---------------------------------------------------------------- ----------------------- ----------------- ---------------- ----------------------------- ----------------------- ---------------------- ---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ------------- ----------- ---------------------------------------------------------------- ---------- --------------- ------------------- --------------- -------------------- -------------------------- ---------------------------------------------------------------- --------- --------------- --------------- -------------------- ------------------ ---------------- --------------- ----------------------------------------------------------------
000007FFC3611DC0 11 128 4294967295 000007FFC34E6320 0 SYS 3 2147483644 ACTIVE DEDICATED 0 SYS SX-PC\SX 4284:8832 WORKGROUP\SX-PC 8834 SX-PC plsqldev.exe USER 000007FFB760DEE0 3125462386 dbcab2yx4pjbk 0 2016/1/13 10:3 16777217 000007FFB77B9940 356401299 9m7787camwh4m 0 2016/1/13 10:34 16777334 PL/SQL Developer 1190136663 命令窗口 - 新建 1316471608 77402 -1 0 0 0 5 2016/1/13 1 0 NO NONE NONE NO DISABLED ENABLED ENABLED 0 NOT IN WAIT NOT IN WAIT 48 345 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle -1 0 WAITED SHORT TIME 921 258 orcl DISABLED FALSE FALSE FIRST EXEC 100 000007FFC34E6320 33
000007FFC377F8E0 133 36 4294967295 000007FFC34DBEC0 0 SYS 0 2147483644 INACTIVE DEDICATED 0 SYS SX-PC\SX 4284:8832 WORKGROUP\SX-PC 5556 SX-PC plsqldev.exe USER 00 0 000007FFB77BB540 3403569819 3nz260v5dwqnv 0 2016/1/13 10:33 16777260 PL/SQL Developer 1190136663 Primary Session 206085144 77380 644 1 4369 0 5 2016/1/13 9 59 NO NONE NONE NO DISABLED ENABLED ENABLED 0 NO HOLDER NO HOLDER 401 345 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 59 WAITING 59058444 -1 0 orcl DISABLED FALSE FALSE FIRST EXEC 100 000007FFC34DBEC0 3
标签：
select * from v$session where audsid=userenv('sessionid');获得当前用户的链接方式 
上一条：
下一条：
相关评论
发表评论