檢視oracle的最大并發數限制,可是檢視v$license視圖
v$license視圖:
裡面記錄了Oracle最大的并發數以及目前使用者的連接配接數,
官方文檔有如下描述:
This view contains information about license
limits.
Column Datatype Description
SESSIONS_MAX
NUMBER
Maximum number of concurrent user sessions
allowed for the instance
SESSIONS_WARNING
NUMBER
Warning limit
for concurrent user sessions for the
instance
SESSIONS_CURRENT
NUMBER
Current number of concurrent
user sessions
SESSIONS_HIGHWATER
NUMBER
Highest number of
concurrent user sessions since the instance
started
USERS_MAX
NUMBER
Maximum number of named users allowed
for the database
其實,該試圖中的SESSIONS_CURRENT就等于select count(*) from
v$session where TYPE= 'USER'
show parameter license_max_sessions
//檢視最大并發數,如果是0,則預設是無限制,但如果在初始化檔案裡說明了,就以初始化檔案為主