TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- SET TERMOUT OFF
- SET ECHO OFF
- SET FEEDBACK ON
- SET HEADING ON
- SET LINESIZE 180
- SET PAGESIZE 2000
- SET TIMING OFF
- SET TRIMSPOOL ON
- SET VERIFY OFF
- CLEAR COLUMNS BREAKS COMPUTES
- COLUMN max_sess_allowed FORMAT 9,999,999 HEADING 'Max sessions allowed'
- COLUMN num_sessions FORMAT 9,999,999,999 HEADING 'Number of sessions'
- COLUMN pct_utl FORMAT a19 HEADING 'Percent Utilization'
- COLUMN username FORMAT a15 HEADING 'Oracle User'
- COLUMN num_user_sess FORMAT 9,999,999 HEADING 'Number of Logins'
- COLUMN count_a FORMAT 9,999,999 HEADING 'Active Logins'
- COLUMN count_i FORMAT 9,999,999 HEADING 'Inactive Logins'
-
- SELECT
- TO_NUMBER(a.value) max_sess_allowed
- , TO_NUMBER(count(*)) num_sessions
- , LPAD(ROUND((count(*)/a.value)*100,0) || '%', 19) pct_utl
- FROM
- v$session b
- , v$parameter a
- WHERE
- a.name = 'sessions'
- GROUP BY
- a.value;
复制代码
|
|