Oracle的sessions和processes的数计算公式
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 5月 18 22:41:18 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> set linesize 1000
SQL> set timing on
SQL> set wrap off
SQL> conn sys as sysdba
输入口令:
已连接。
SQL> show user
USER 为 "SYS"
SQL> select * from V$instance ;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PARALL THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO DATABASE_STATUS INSTANCE_ROLE ACTIVE_STATE BLOCKE
--------------- -------------------------------- ------------------------------------------------------------------------------ ------------------------------------ ------------------ ------
1 orcl SHARK-7DB94E655 10.2.0.1.0 18-5月 -12 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO
已用时间: 00: 00: 00.06
SQL> show parameter process --查看进程数 10G默认安装 为150个进程
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150
SQL> show parameter session --回话数是170个
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
session_cached_cursors integer 20
session_max_open_files integer 10
sessions integer 170
shared_server_sessions integer
SQL> select 150*1.1+5 from dual; --核对公式 正常
150*1.1+5
----------
170
已用时间: 00: 00: 00.00
