dedicated server連線測試
當ORACLE以DEDICATED SERVER連線到伺服器時:ORACLE對於每個會話都會生成新的專用伺服器,會話與專用伺服器間是一對一的關係
測試:
會話1:啟動資料庫以後沒有使用者連線上來的程式情況
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:00 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
oracle 24819 6319 0 15:10 pts/1 00:00:00 ps -ef
oracle 24820 6319 0 15:10 pts/1 00:00:00 grep oracle
會話1:當一個使用者登入SQLPLUS,但是沒連線到資料庫的程式情況
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:01 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
root 24822 24765 0 15:11 pts/2 00:00:00 su - oracle
oracle 24823 24822 0 15:11 pts/2 00:00:00 -bash
oracle 24850 24823 0 15:11 pts/2 00:00:00 sqlplus ---這裡多了一個SQLPLUS程式
oracle 24851 6319 0 15:11 pts/1 00:00:00 ps -ef
oracle 24852 6319 0 15:11 pts/1 00:00:00 grep oracle
會話1:當有一個使用者通過SQLPLUS連線到資料庫,程式情況
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:01 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
root 24822 24765 0 15:11 pts/2 00:00:00 su - oracle
oracle 24823 24822 0 15:11 pts/2 00:00:00 -bash
oracle 24850 24823 0 15:11 pts/2 00:00:00 sqlplus
oracle 24853 24850 2 15:11 ? 00:00:00 oracleTESTENV01 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 24854 6319 0 15:12 pts/1 00:00:00 ps -ef
oracle 24855 6319 0 15:12 pts/1 00:00:00 grep oracle
會話1:當有兩個使用者用SQLPLUS連線到資料庫,程式情況
[oracle@oraclelinux ~]$ ps -ef|grep oracle
root 6318 6286 0 10:08 pts/1 00:00:00 su - oracle
oracle 6319 6318 0 10:08 pts/1 00:00:00 -bash
oracle 24668 1 0 12:53 ? 00:00:01 ora_pmon_TESTENV01
oracle 24670 1 0 12:53 ? 00:00:01 ora_psp0_TESTENV01
oracle 24672 1 0 12:53 ? 00:00:01 ora_mman_TESTENV01
oracle 24674 1 0 12:53 ? 00:00:01 ora_dbw0_TESTENV01
oracle 24676 1 0 12:53 ? 00:00:01 ora_lgwr_TESTENV01
oracle 24678 1 0 12:53 ? 00:00:07 ora_ckpt_TESTENV01
oracle 24680 1 0 12:53 ? 00:00:01 ora_smon_TESTENV01
oracle 24682 1 0 12:53 ? 00:00:00 ora_reco_TESTENV01
oracle 24684 1 0 12:53 ? 00:00:01 ora_cjq0_TESTENV01
oracle 24690 1 0 12:53 ? 00:00:00 ora_d000_TESTENV01
oracle 24692 1 0 12:53 ? 00:00:00 ora_s000_TESTENV01
oracle 24696 1 0 12:53 ? 00:00:03 ora_mmon_TESTENV01
oracle 24698 1 0 12:53 ? 00:00:01 ora_mmnl_TESTENV01
oracle 24700 1 0 12:54 ? 00:00:00 ora_arc0_TESTENV01
oracle 24702 1 0 12:54 ? 00:00:00 ora_arc1_TESTENV01
root 24822 24765 0 15:11 pts/2 00:00:00 su - oracle
oracle 24823 24822 0 15:11 pts/2 00:00:00 -bash
oracle 24850 24823 0 15:11 pts/2 00:00:00 sqlplus
oracle 24853 24850 0 15:11 ? 00:00:00 oracleTESTENV01 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root 24888 24856 0 15:13 pts/3 00:00:00 su - oracle
oracle 24889 24888 0 15:13 pts/3 00:00:00 -bash
oracle 24916 24889 1 15:13 pts/3 00:00:00 sqlplus
oracle 24917 24916 2 15:13 ? 00:00:00 oracleTESTENV01 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 24918 6319 0 15:13 pts/1 00:00:00 ps -ef
oracle 24919 6319 0 15:13 pts/1 00:00:00 -bash
[oracle@oraclelinux ~]$
新加了兩個程式為相應會話進行服務
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15720542/viewspace-729923/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle專有(dedicated)連線和共享(shared)連線Oracle
- 測試連線
- Dedicated and Shared Server ProcessesServer
- Oracle dedicated server process and shared server processOracleServer
- 測試rss與navicat連線
- python連線redis測試PythonRedis
- 【JDBC】java連線池模擬測試 連線oracleJDBCJavaOracle
- java Jdbc連線oracle資料庫連線測試JavaJDBCOracle資料庫
- SQL Server連線SQL Server、SQL Server連線ORACLE 連結伺服器SQLServerOracle伺服器
- 測試 mysql 的最大連線數MySql
- php連線mssql測試檔案PHPSQL
- 自然連線的一個測試
- 測試SQL Server業務規則連結方法SQLServer
- SQL SERVER 自連線、外連線SQLServer
- 連線SQL ServerSQLServer
- Dedicated Server Configuration (133)Server
- 使用UDL測試SQLServer連線問題SQLServer
- python連線資料庫測試Python資料庫
- sqlplus連線數的測試SQL
- 簡單的hector連線casssandra測試
- 試用Redis安裝、php環境連線、測試RedisPHP
- .NET連線SQL ServerSQLServer
- php7連線mysql測試程式碼PHPMySql
- hive表連線和oracle測試對比HiveOracle
- LoadRunner長連線效能測試指令碼指令碼
- 測試FORMS SERVERORMServer
- SQL Server linked server 連線OracleSQLServerOracle
- socket測試遠端地址能否連線併為連線設定超時
- myeclipse 中java連線mysql、查詢測試EclipseJavaMySql
- Oracle 連線條件中帶有OR的測試Oracle
- C#測試資料庫連線是否成功C#資料庫
- telnet連線socket serverServer
- SQL Deverlop連線SQL ServerSQLdevServer
- Perl 連線 SQL Server (轉)SQLServer
- 遠端連線SQL ServerSQLServer
- python 怎麼連線 sql server,不是連線 mysqlPythonServerMySql
- 【JDBC】java連線池模擬測試連線Oracle資料庫指令碼參考JDBCJavaOracle資料庫指令碼
- RabbitMQ開啟SSL與SpringBoot連線測試MQSpring Boot