saddr，paddr几个参数的理解

saddr,sid,serial#,paddr怎么理解

这几个参数主要出现在v$process v$session视图中,请参看视图的说明
[quote]
V$PROCESSThis view contains information about the currently active processes. While the [font=新宋体]LATCHWAIT[/font] column indicates what latch a process is waiting for, the [font=新宋体]LATCHSPIN[/font] column indicates what latch a process is spinning on. On multi-processor machines, Oracle processes will spin on a latch before waiting on it.
[table=98%][tr]ColumnDatatypeDescription[/tr][tr][td][font=新宋体]ADDR[/font][/td][td][font=新宋体]RAW(4 | 8)[/font][/td][td]Address of process state object[/td][/tr][tr][td][font=新宋体]PID[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Oracle process identifier[/td][/tr][tr][td][font=新宋体]SPID[/font][/td][td][font=新宋体]VARCHAR2(12)[/font][/td][td]Operating system process identifier[/td][/tr][tr][td][font=新宋体]USERNAME[/font][/td][td][font=新宋体]VARCHAR2(15)[/font][/td][td]Operating system process username. Any two-task user coming across the network has "-T" appended to the username.[/td][/tr][tr][td][font=新宋体]SERIAL#[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Process serial number[/td][/tr][tr][td][font=新宋体]TERMINAL[/font][/td][td][font=新宋体]VARCHAR2(30)[/font][/td][td]Operating system terminal identifier[/td][/tr][tr][td][font=新宋体]PROGRAM[/font][/td][td][font=新宋体]VARCHAR2(48)[/font][/td][td]Program in progress[/td][/tr][tr][td][font=新宋体]TRACEID[/font][/td][td][font=新宋体]VARCHAR2(255)[/font][/td][td]Trace file identifier[/td][/tr][tr][td][font=新宋体]BACKGROUND[/font][/td][td][font=新宋体]VARCHAR2(1)[/font][/td][td][font=新宋体]1[/font] for a background process; NULL for a normal process[/td][/tr][tr][td][font=新宋体]LATCHWAIT[/font][/td][td][font=新宋体]VARCHAR2(8)[/font][/td][td]Address of latch the process is waiting for; NULL if none[/td][/tr][tr][td][font=新宋体]LATCHSPIN[/font][/td][td][font=新宋体]VARCHAR2(8)[/font][/td][td]Address of the latch the process is spinning on; NULL if none[/td][/tr][tr][td][font=新宋体]PGA_USED_MEM[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]PGA memory currently used by the process[/td][/tr][tr][td][font=新宋体]PGA_ALLOC_MEM[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process)[/td][/tr][tr][td][font=新宋体]PGA_FREEABLE_MEM[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Allocated PGA memory which can be freed[/td][/tr][tr][td][font=新宋体]PGA_MAX_MEM[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Maximum PGA memory ever allocated by the process[/td][/tr][/table]


[/quote]


[quote]
V$SESSIONThis view lists session information for each current session.
[table=98%][tr]ColumnDatatypeDescription[/tr][tr][td][font=新宋体]SADDR[/font][/td][td][font=新宋体]RAW(4 | 8)[/font][/td][td]Session address[/td][/tr][tr][td][font=新宋体]SID[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Session identifier[/td][/tr][tr][td][font=新宋体]SERIAL#[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.[/td][/tr][tr][td][font=新宋体]AUDSID[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Auditing session ID[/td][/tr][tr][td][font=新宋体]PADDR[/font][/td][td][font=新宋体]RAW(4 | 8)[/font][/td][td]Address of the process that owns the session[/td][/tr][tr][td][font=新宋体]USER#[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Oracle user identifier[/td][/tr][tr][td][font=新宋体]USERNAME[/font][/td][td][font=新宋体]VARCHAR2(30)[/font][/td][td]Oracle username[/td][/tr][tr][td][font=新宋体]COMMAND[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Command in progress (last statement parsed); for a list of values, see [url=file:///E:/tools/oradocs/10gr2/server.102/b14237/dynviews_2088.htm#g1432037][color=#800080]Table 7-5[/color][/url]. These values also appear in the [font=新宋体]AUDIT_ACTIONS[/font] table.[/td][/tr][tr][td][font=新宋体]OWNERID[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]The column contents are invalid if the value is [font=新宋体]2147483644[/font]. Otherwise, this column contains the identifier of the user who owns the migratable session. For operations using Parallel Slaves, interpret this value as a 4-byte value. The low-order 2 bytes of which represent the session number, and the high-order bytes the instance ID of the query coordinator.
[/td][/tr][tr][td][font=新宋体]TADDR[/font][/td][td][font=新宋体]VARCHAR2(8)[/font][/td][td]Address of transaction state object[/td][/tr][tr][td][font=新宋体]LOCKWAIT[/font][/td][td][font=新宋体]VARCHAR2(8)[/font][/td][td]Address of lock waiting for; null if none[/td][/tr][tr][td][font=新宋体]STATUS[/font][/td][td][font=新宋体]VARCHAR2(8)[/font][/td][td]Status of the session: [list][font=新宋体]ACTIVE[/font] - Session currently executing SQL
[font=新宋体]INACTIVE[/font]
[font=新宋体]KILLED[/font] - Session marked to be killed
[font=新宋体]CACHED[/font] - Session temporarily cached for use by Oracle*XA
[*][font=新宋体]SNIPED[/font] - Session inactive, waiting on the client
[/list][/td][/tr][tr][td][font=新宋体]SERVER[/font][/td][td][font=新宋体]VARCHAR2(9)[/font][/td][td]Server type ([font=新宋体]DEDICATED[/font]| [font=新宋体]SHARED[/font]| [font=新宋体]PSEUDO[/font]| [font=新宋体]NONE[/font])[/td][/tr][tr][td][font=新宋体]SCHEMA#[/font][/td][td][font=新宋体]NUMBER[/font][/td][td]Schema user identifier[/td][/tr][tr][td][font=新宋体]SCHEMANAME[/font][/td][td][font=新宋体]VARCHAR2(30)[/font][/td][td]Schema user name[/td][/tr][tr][td][font=新宋体]OSUSER[/font][/td][td][font=新宋体]VARCHAR2(30)[/font][/td][td]Operating system client user name[/td][/tr][tr][td][font=新宋体]PROCESS[/font][/td][td][font=新宋体]VARCHAR2(12)[/font][/td][td]Operating system client process ID[/td][/tr][tr][td][font=新宋体]MACHINE[/font][/td][td][font=新宋体]VARCHAR2(64)[/font][/td][td]Operating system machine name[/td][/tr][tr][td][font=新宋体]TERMINAL[/font][/td][td][font=新宋体]VARCHAR2(30)[/font][/td][td]Operating system terminal name[/td][/tr][tr][td][font=新宋体]PROGRAM[/font][/td][td][font=新宋体]VARCHAR2(48)[/font][/td][td]Operating system program name[/td][/tr][tr][td][font=新宋体]TYPE[/font][/td][td][font=新宋体]VARCHAR2(10)[/font]
[font=新宋体]....[/font]
[/td][td]Session type[/td][/tr][/table]

[/quote]

如上,你应该看到serial#在不同的视图中，含义自然不一样

谢谢，版主。就是不知道这几个试图说明怎么找到！:L

[url]http://tahiti.oracle.com[/url]

这个网站是oracle官方的文档站点.

Oracle Document CD需要自备一套，有问题可以立即查找

上[url]www.oracle.com.cn[/url]好像有个在线的