FilesExpand file tree

 master

/

sessioncount.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

44 lines (34 loc) · 830 Bytes

 master

/

sessioncount.sql

Top

File metadata and controls

• Code
• Blame

44 lines (34 loc) · 830 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

set linesize 32000

set pagesize 1000

set long 2000000000

set longchunksize 1000

set head off;

set verify off;

set termout off;

column u new_value us noprint;

column n new_value ns noprint;

select name n from v$database;

select user u from dual;

set sqlprompt &ns:&us>

set head on

set echo on

set termout on

set trimspool on

spool &ns.sessioncount.log

-- get the hourly session count

-- from the AWR views

set define off

select

to_char(snap.END_INTERVAL_TIME,'YYYY-MM-DD HH24:MI:SS') SNAP_TIME,

stat.value session_count

from

DBA_HIST_SYSSTAT stat,

DBA_HIST_SNAPSHOT snap

where

stat.SNAP_ID = snap.SNAP_ID and

stat.DBID = snap.DBID and

stat.INSTANCE_NUMBER = snap.INSTANCE_NUMBER and

stat.STAT_NAME = 'logons current'

order by

to_char(snap.END_INTERVAL_TIME,'YYYY-MM-DD HH24:MI:SS');

spool off