FilesExpand file tree

 master

/

sqlstat2.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

44 lines (37 loc) · 847 Bytes

 master

/

sqlstat2.sql

Top

File metadata and controls

• Code
• Blame

44 lines (37 loc) · 847 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.sqlstat2.log

column END_INTERVAL_TIME format a25

select ss.sql_id,

ss.plan_hash_value,

sn.END_INTERVAL_TIME,

ss.executions_delta,

ELAPSED_TIME_DELTA,

CPU_TIME_DELTA,

IOWAIT_DELTA,

CLWAIT_DELTA,

APWAIT_DELTA,

CCWAIT_DELTA,

BUFFER_GETS_DELTA,

DISK_READS_DELTA,

ROWS_PROCESSED_DELTA

from DBA_HIST_SQLSTAT ss,DBA_HIST_SNAPSHOT sn

where ss.sql_id in ('fnsrpftx0wx0r','5g9z6j8tbac19','7qr2b85d6v9qu')

and ss.snap_id=sn.snap_id

and ss.INSTANCE_NUMBER=sn.INSTANCE_NUMBER

order by ss.sql_id,ss.snap_id;

spool off