Release 3.00
Oct 14, 2002
|
Sybernet / Supplied Procedures Reference
Release 3.00 Oct 14, 2002 |
|
This procedure reports information on users and processes in Sybernet or SQLPlus. For each process being run, sp_who reports the SESSIONID, USER_NAME, APPLICATION, HOSTNAME, OBJECT_NAME, and HTTP_USER_AGENT.
Procedure SP_WHO
(
LOGIN_NAME VARCHAR2
) ;
| Parameter | Description |
|---|---|
login_name |
optional login_name |
sp_who runs best with format set to preformatted.
| Column | Description |
|---|---|
sessionid |
This is the unique session id assigned by Oracle. |
user_name |
This is the user_name connected on this session. |
application |
This is the application name gotten from Oracle's session table. The application will either be Sybernet or SQLPlus. No other applications are listed. |
hostname |
This is this session's IP address or hostname. For connections initiated by Sybercron this address is Sybercron's hostname followed by its process ID. |
object_name |
This is the last object executed by this session that was written to the audit file. |
http_user_agent |
This is the name and version of the client software when Sybernet is being accessed from a web browser. Sybercron and SQLPlus write their name to this column. |
The following example illustrates how to invoke sp_who:
http.sp_who;
SESSIONID USER_NAME APPLICATION HOSTNAME OBJECT_NAME HTTP_USER_AGENT
---------- ------------------------------ ------------------------------ ------------------------------ --------------------------------------- ------------------------------------------------------------
294375 SYBERCRON Sybernet@ORAPROD (TNS V1-V3) oraprod.sri.com.05434 HTTP.PIPE_CREATE_PIPE Sybercron
294377 SYBERCRON Sybernet@ORADEV (TNS V1-V3) oradev.sri.com.06994 HTTP.PIPE_CREATE_PIPE Sybercron
294393 SYBERCRON Sybernet@ORADEV (TNS V1-V3) mis.sri.com.12196 HTTP.PIPE_CREATE_PIPE Sybercron
294391 SYBERCRON Sybernet@ORADEV (TNS V1-V3) kirk.sri.com.00470 HTTP.PIPE_CREATE_PIPE Sybercron
294400 SYBERCRON Sybernet@ORADEV (TNS V1-V3) astro.sri.com.01372 HTTP.PIPE_CREATE_PIPE Sybercron
294833 HTTP Sybernet@ORADEV (TNS V1-V3) 128.18.28.84 HTTP.SP_HTML_ISQL Mozilla/4.77 (Macintosh; U; PPC)
294828 DELTEK Sybernet@ORADEV (TNS V1-V3) 128.18.37.222 DELTEK.SRI_LD_RPT_0250 Mozilla/4.79 [en] (Windows NT 5.0; U)
294816 ENG484 Sybernet@ORADEV (TNS V1-V3) 128.18.37.142 DELTEK.SRI_CLNT_RPTS_FORM Mozilla/4.7 [en] (WinNT; U)
294852 HTTP SQLPlus@spock (TNS V1-V3) spock HTTP.SP_WHO SQLPlus
294846 HTTP Sybernet@ORADEV (TNS V1-V3) 128.18.37.89 HTTP.SP_HTML_LOGIN Mozilla/4.7 [en] (WinNT; U)