select * from v$session where audsid=userenv('sessionid');
2016-01-13 10:35:47 访问(2569) 赞(0) 踩(0)
select * from v$session where audsid=userenv('sessionid');
要用DBA身份连接才能按照上面的方式查询出来,你可以看到机器名和连接的程序名称!
这样一来,就可以判断出当前连接的sessionid
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
---------------- ---------- ---------- ---------- ---------------- ---------- ------------------------------ ---------- ---------- ---------------- ---------------- -------- --------- ---------- ------------------------------ ------------------------------ ------------------------ ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- -------------- ------------- ---------------- -------------- ----------- ---------------- --------------- ------------- ----------------- --------------- ------------ --------------------- ------------------------- --------------- ------------------- ------------------------------------------------ ----------- -------------------------------- ----------- ---------------------------------------------------------------- -------------------- ------------- -------------- --------------- ------------- --------------- ----------- ------------ ------------ ------------- --------------- ----------- -------------------------------- ----------- ----------- --------- ---------------------- ---------------------------------------------------------------- ----------------------- ----------------- ---------------- ----------------------------- ----------------------- ---------------------- ---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ------------- ----------- ---------------------------------------------------------------- ---------- --------------- ------------------- --------------- -------------------- -------------------------- ---------------------------------------------------------------- --------- --------------- --------------- -------------------- ------------------ ---------------- --------------- ----------------------------------------------------------------
000007FFC3614C30 10 95 4294967295 000007FFC34EE6A0 0 SYS 0 2147483644 INACTIVE DEDICATED 0 SYS SX-PC\SX 4284:8832 WORKGROUP\SX-PC 8924 SX-PC plsqldev.exe USER 00 0 000007FFB77B9940 356401299 9m7787camwh4m 0 2016/1/13 10:41 16777367 PL/SQL Developer 1190136663 SQL 窗口 - 新建 2127054360 78441 -1 0 0 0 94 2016/1/13 1 29 NO NONE NONE NO DISABLED ENABLED ENABLED 0 NO HOLDER NO HOLDER 682 345 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 29 WAITING 28715467 -1 0 orcl DISABLED FALSE FALSE FIRST EXEC 100 000007FFC34EE6A0 19
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:4 16777219 000007FFB77B9940 356401299 9m7787camwh4m 0 2016/1/13 10:42 16777370 PL/SQL Developer 1190136663 命令窗口 - 新建 1316471608 78529 -1 0 0 0 5 2016/1/13 1 0 NO NONE NONE NO DISABLED ENABLED ENABLED 0 NOT IN WAIT NOT IN WAIT 98 341 SQL*Net message to client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2000153315 7 Network -1 0 WAITED SHORT TIME 1 21 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:41 16777280 PL/SQL Developer 1190136663 Primary Session 206085144 78410 644 1 4369 0 5 2016/1/13 9 43 NO NONE NONE NO DISABLED ENABLED ENABLED 0 NO HOLDER NO HOLDER 599 345 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 43 WAITING 43054229 -1 0 orcl DISABLED FALSE FALSE FIRST EXEC 100 000007FFC34DBEC0 3
000007FFC377CA70 134 436 4294967295 000007FFC34F0780 0 SYS 0 2147483644 INACTIVE DEDICATED 0 SYS SX-PC\SX 12212:6468 WORKGROUP\SX-PC 8889 SX-PC sqlplus.exe USER 00 0 0 00 0 0 sqlplus.exe 254292535 0 77460 -1 0 0 0 14 2016/1/13 1 347 NO NONE NONE NO DISABLED ENABLED ENABLED 0 NO HOLDER NO HOLDER 14 345 SQL*Net message from client driver id 1413697536 0000000054435000 #bytes 1 0000000000000001 0 00 2723168908 6 Idle 0 346 WAITING 346425896 -1 0 orcl DISABLED FALSE FALSE FIRST EXEC 100 000007FFC34F0780 6
SQL> select userenv('sessionid') from dual;
USERENV('SESSIONID')
--------------------
4294967295
标签：
select * from v$session where audsid=userenv('sessionid'); 
上一条：
下一条：
相关评论
发表评论