UNIX下如何查看ORACLE进程

显示全部楼层 · 2013-2-25 14:51:24

由于本人一直没有接触过UNIX系统,因此不清楚UNIX系统下如何查看ORACLE的PROCESSES参数,是不是这么写
connect sys/change_on_install as sysdba
show parameter

千问 · 2013-2-25 14:51:24

？不太理解楼主的意思？
$ ps -ef | grep -n oracle

千问 · 2013-2-25 14:51:24

ps -ef|grep ora_

千问 · 2013-2-25 14:51:24

文不对题。
查看操作系统下的进程是可以用2楼、3楼的方法。
如果是查看数据库的PROCESS参数，就是你自己写的方法。或者更精确一点：
SQL> show parameter process

千问 · 2013-2-25 14:51:24

樓主出的問題有誤導的傾向﹐呵

千问 · 2013-2-25 14:51:24

study........

千问 · 2013-2-25 14:51:24

也不知道是要看进程，还是要看参数？？？

千问 · 2013-2-25 14:51:24

man ps

千问 · 2013-2-25 14:51:24

1.在
Connected to:Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit ProductionWith the Partitioning and Real Application Clusters optionsJServer Release 9.2.0.8.0 - ProductionSQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 3
db_writer_processes integer 4
job_queue_processes integer 50
log_archive_max_processes integer 2
processes integer 4000
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning and Real Application Clusters options
JServer Release 9.2.0.8.0 - Production

SCJF_CX1:[/oracle]$ps -ef | grep ora_|grep -v grep
oracle 14529 1 0 Oct 29 ? 0:00 ora_reco_scjfcx1
oracle 14492 1 0 Oct 29 ? 5:46 ora_pmon_scjfcx1
oracle 14543 1 0 Oct 29 ? 7:00 ora_arc1_scjfcx1
oracle 14513 1 12 Oct 29 ? 264:45 ora_lms2_scjfcx1
oracle 14531 1 0 Oct 29 ? 0:59 ora_cjq0_scjfcx1
oracle 14537 1 0 Oct 29 ? 1:02 ora_qmn2_scjfcx1
oracle 14494 1 1 Oct 29 ? 18:29 ora_diag_scjfcx1
oracle 14525 1 1 Oct 29 ? 13:34 ora_ckpt_scjfcx1
oracle 4832 1 0 20:39:07 ? 0:00 ora_j003_scjfcx1
oracle 14539 1 0 Oct 29 ? 0:00 ora_d000_scjfcx1
oracle 14527 1 0 Oct 29 ? 3:15 ora_smon_scjfcx1
oracle 14523 1 0 Oct 29 ? 24:05 ora_lgwr_scjfcx1
oracle 14533 1 0 Oct 29 ? 1:03 ora_qmn0_scjfcx1
oracle 14498 1 0 Oct 29 ? 24:11 ora_lmd0_scjfcx1
oracle 14509 1 13 Oct 29 ? 266:21 ora_lms0_scjfcx1
oracle 14519 1 0 Oct 29 ? 29:00 ora_dbw2_scjfcx1
oracle 29070 1 0 19:22:58 ? 0:06 ora_j001_scjfcx1
oracle 14511 1 13 Oct 29 ? 267:58 ora_lms1_scjfcx1
oracle 14496 1 0 Oct 29 ? 24:16 ora_lmon_scjfcx1
oracle 14517 1 0 Oct 29 ? 56:30 ora_dbw1_scjfcx1
oracle 14521 1 0 Oct 29 ? 28:52 ora_dbw3_scjfcx1
oracle 14546 1 0 Oct 29 ? 3:22 ora_lck0_scjfcx1
oracle 14535 1 0 Oct 29 ? 1:02 ora_qmn1_scjfcx1
oracle 14515 1 0 Oct 29 ? 56:36 ora_dbw0_scjfcx1
oracle 14541 1 0 Oct 29 ? 41:24 ora_arc0_scjfcx1
oracle 29163 1 165 19:24:58 ? 0:18 ora_j000_scjfcx1
oracle 2623 1 0 20:09:04 ? 0:00 ora_j002_scjfcx1

SCJF_CX1:[/oracle]$ps -ef | grep ora_|grep -v grep | wc -l
26