Adamhuan's Data Center - 【逻辑驱动数据】
数据玩物、代码屋、1/0游戏：（零和博弈）/ 禅宗意志 / 规则战争 / 解放数据力量 / 技术的飞速发展并没有改变这个世界，因为，这个世界从没有变，它只是越来越趋近于它本来的模样。
Adamhuan
Shell Log：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
SQL> set pagesize 100 SQL> col program for a35 SQL> col username for a12 SQL> col osuser for a14 SQL> set linesize 300 SQL> select a.program,a.osuser,a.type,a.sid,a.serial#,a.paddr,a.process,a.username,a.command,a.status,a.schema#,a.schemaname,b.TEMPORARY_TABLESPACE,b.username from v$session a,dba_users b where a.schemaname = b.username; PROGRAM OSUSER TYPE SID SERIAL# PADDR PROCESS USERNAME COMMAND STATUS SCHEMA# SCHEMANAME TEMPORARY_TABLESPACE USERNAME ----------------------------------- -------------- ---------- ---------- ---------- ---------------- ------------ ------------ ---------- -------- ---------- ------------------------------ ------------------------------ ------------ oracle@misrep1 (PMON) oracle BACKGROUND 555 1 00000000BF6AA628 6153 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (DIAG) oracle BACKGROUND 554 1 00000000BF6AAE20 6157 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (PSP0) oracle BACKGROUND 553 1 00000000BF6AB618 6161 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (LMON) oracle BACKGROUND 552 1 00000000BF6ABE10 6165 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (LMD0) oracle BACKGROUND 551 1 00000000BF6AC608 6169 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (LMS0) oracle BACKGROUND 550 1 00000000BF6ACE00 6173 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (LMS1) oracle BACKGROUND 548 1 00000000BF6AD5F8 6181 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (MMAN) oracle BACKGROUND 546 1 00000000BF6ADDF0 6188 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (DBW0) oracle BACKGROUND 545 1 00000000BF6AE5E8 6194 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (LGWR) oracle BACKGROUND 544 1 00000000BF6AEDE0 6196 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (CKPT) oracle BACKGROUND 543 1 00000000BF6AF5D8 6198 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (RECO) oracle BACKGROUND 542 1 00000000BF6B05C8 6206 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (CJQ0) oracle BACKGROUND 541 1 00000000BF6B0DC0 6208 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (MMON) oracle BACKGROUND 540 1 00000000BF6B15B8 6210 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (MMNL) oracle BACKGROUND 539 1 00000000BF6B1DB0 6212 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (SMON) oracle BACKGROUND 538 1 00000000BF6AFDD0 6204 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (LCK0) oracle BACKGROUND 537 1 00000000BF6B25A8 6253 0 ACTIVE 0 SYS TEMP SYS racgimon@misrep1 (TNS V1-V3) oracle USER 535 18 00000000BF6B2DA0 5995 SYS 0 INACTIVE 0 SYS TEMP SYS oracle@misrep1 (QMNC) oracle BACKGROUND 533 7 00000000BF6B3598 6313 0 ACTIVE 0 SYS TEMP SYS racgimon@misrep1 (TNS V1-V3) oracle USER 530 8 00000000BF6B4588 5995 SYS 0 ACTIVE 0 SYS TEMP SYS racgimon@misrep1 (TNS V1-V3) oracle USER 529 14 00000000BF6B5D70 5995 SYS 0 INACTIVE 0 SYS TEMP SYS oracle@misrep1 (q000) oracle BACKGROUND 527 1 00000000BF6B4D80 6571 0 ACTIVE 0 SYS TEMP SYS oracle@misrep1 (q001) oracle BACKGROUND 525 1 00000000BF6B5578 6573 0 ACTIVE 0 SYS TEMP SYS sqlplus@misrep1 (TNS V1-V3) oracle USER 520 6470 00000000BF6B6568 24465 SYS 3 ACTIVE 0 SYS TEMP SYS racgimon@misrep1 (TNS V1-V3) oracle USER 517 13992 00000000BF6B7D50 5995 SYS 47 INACTIVE 0 SYS TEMP SYS 25 rows selected. SQL> |
————————————————————————
Ending。[……]
Adamhuan