[php]ps -ef
UID PID PPID C STIME TTY TIME CMD
root 0 0 0 Mar 06 ? 0:34 sched
root 1 0 0 Mar 06 ? 0:02 /etc/init -
root 2 0 0 Mar 06 ? 0:00 pageout
root 3 0 1 Mar 06 ? 112:03 fsflush
root 350 339 0 Mar 06 ? 0:00 /usr/dt/bin/dtlogin -daemon
daemon 172 1 0 Mar 06 ? 0:00 /usr/lib/nfs/statd
root 336 1 0 Mar 06 ? 0:00 /usr/lib/saf/sac -t 300
root 193 1 0 Mar 06 ? 0:18 /usr/sbin/syslogd
root 167 1 0 Mar 06 ? 0:00 /usr/sbin/inetd -s
root 283 1 0 Mar 06 ? 0:00 /opt/SUNWhwrdg/dptelog
root 174 1 0 Mar 06 ? 0:00 /usr/lib/nfs/lockd
root 202 1 0 Mar 06 ? 0:00 /usr/sbin/cron
root 136 1 0 Mar 06 ? 0:03 /usr/sbin/rpcbind
root 218 1 0 Mar 06 ? 0:00 /usr/lib/lpsched
root 189 1 0 Mar 06 ? 0:00 /usr/lib/autofs/automountd
root 271 1 0 Mar 06 ? 0:01 /usr/sbin/vold
root 156 1 0 Mar 06 ? 0:00 /usr/sbin/in.named
root 227 1 0 Mar 06 ? 0:39 /usr/lib/print/printd
root 257 1 0 Mar 06 ? 0:00 /usr/lib/utmpd
root 247 1 0 Mar 06 ? 0:00 /usr/lib/power/powerd
root 138 1 0 Mar 06 ? 0:00 /usr/sbin/keyserv
root 208 1 0 Mar 06 ? 0:01 /usr/sbin/nscd
root 345 339 0 Mar 06 ? 0:25 /usr/openwin/bin/Xsun :0 -nobanner -auth /var/dt/A:0-0P82ij
root 263 1 0 Mar 06 ? 0:00 /usr/lib/sendmail -bd -q15m
daemon 278 1 0 Mar 06 ? 0:00 /usr/lib/ab2/dweb/sunos5/bin/dwhttpd /usr/lib/ab2/dweb/data
daemon 279 278 0 Mar 06 ? 0:00 /usr/lib/ab2/dweb/sunos5/bin/dwhttpd /usr/lib/ab2/dweb/data
root 340 336 0 Mar 06 ? 0:00 /usr/lib/saf/ttymon
root 464 167 0 Mar 06 ? 0:00 /usr/dt/bin/rpc.ttdbserverd
root 310 1 0 Mar 06 ? 0:00 /usr/lib/snmp/snmpdx -y -c /etc/snmp/conf
root 309 283 0 0:00
root 411 401 0 Mar 06 ? 0:00 /usr/openwin/bin/fbconsole
root 337 1 0 Mar 06 console 0:00 /usr/lib/saf/ttymon -g -h -p oracleapp02 console login: -T sun -d /dev/console
root 325 1 0 Mar 06 ? 0:00 /usr/lib/dmi/dmispd
root 342 1 0 Mar 06 ? 0:00 /opt/SUNWhwrdg/dpteng
root 401 350 0 Mar 06 ? 0:00 /bin/ksh /usr/dt/bin/Xsession
root 449 446 0 Mar 06 pts/2 0:00 [ sh ]
root 330 1 0 Mar 06 ? 0:00 /usr/lib/dmi/snmpXdmid -s oracleapp02
root 339 1 0 Mar 06 ? 0:00 /usr/dt/bin/dtlogin -daemon
root 353 310 0 Mar 06 ? 0:00 mibiisa -p 32787
root 415 1 0 Mar 06 ? 0:00 /usr/openwin/bin/speckeysd
root 446 401 0 Mar 06 pts/2 0:00 [ sdt_shel ]
root 471 463 0 Mar 06 ?? 0:01 dtterm -session dt.dSaf_ -sdtserver
root 385 1 0 Mar 06 ? 0:00 /usr/openwin/bin/fbconsole -d :0
root 448 1 0 Mar 06 ? 0:00 /usr/dt/bin/dsdm
root 463 449 0 Mar 06 pts/2 0:03 /usr/dt/bin/dtsession
root 462 1 0 Mar 06 pts/2 0:07 /usr/dt/bin/ttsession
root 470 463 0 Mar 06 ? 0:01 dtwm
root 473 1 0 Mar 06 ? 0:00 /bin/ksh /usr/dt/bin/sdtvolcheck -d -z 5 cdrom
root 488 473 0 Mar 06 ? 0:00 /bin/cat /tmp/.removable/notify0
root 482 471 0 Mar 06 pts/4 0:00 /sbin/sh
root 523 471 0 Mar 06 pts/5 0:00 /sbin/sh
ora805 526 523 0 Mar 06 pts/5 0:00 -sh
ora805 497 1 0 0:09
root 679 677 0 Mar 06 pts/9 0:00 -sh
ora805 9911 1 0 18:35:33 ? 36:18 ora_snp5_DEVP
ora805 9907 1 0 18:35:33 ? 2:43 ora_snp3_DEVP
ora805 9905 1 0 18:35:33 ? 5:27 ora_snp2_DEVP
ora805 9909 1 0 18:35:33 ? 13:27 ora_snp4_DEVP
ora805 9901 1 0 18:35:33 ? 9:15 ora_snp0_DEVP
ora805 9903 1 0 18:35:33 ? 0:33 ora_snp1_DEVP
root 630 167 0 Mar 06 ? 0:00 in.telnetd
root 677 167 0 Mar 06 ? 0:00 in.telnetd [/php]
select addr from v$process where spid=9911;
select sid,sql_address,sql_hash_value from v$session where paddr=...
select sql_text from v$sqltext_with_newlines
where address=sql_address
and hash_value=sql_hash_value
order by piece
/
select * from v$sql_plan....
偶也不是很清楚和熟悉这个PLAN