select * from v$license;

V$LICENSE

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
`CPU_COUNT_CURRENT`	`NUMBER`	Current number of logical CPUs or processors on the system
`CPU_CORE_COUNT_CURRENT`	`NUMBER`	Current number of CPU cores on the system (includes subcores of multicore CPUs, as well as single-core CPUs)
`CPU_SOCKET_COUNT_CURRENT`	`NUMBER`	Current number of CPU sockets on the system (represents an absolute count of CPU chips on the system, regardless of multithreading or multicore architectures)
`CPU_COUNT_HIGHWATER`	`NUMBER`	Highest number of logical CPUs or processors on the system since the instance started
`CPU_CORE_COUNT_HIGHWATER`	`NUMBER`	Highest number of CPU cores on the system since the instance started (includes subcores of multicore CPUs, as well as single-core CPUs)
`CPU_SOCKET_COUNT_HIGHWATER`	`NUMBER`	Highest number of CPU sockets on the system since the instance started (represents an absolute count of CPU chips on the system, regardless of multithreading or multicore architectures)

[@more@]SESSIONS_HIGHWATER v$license

查詢oracle歷史最大連線[會話]數