FilesExpand file tree

 master

/

ashprofile.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

39 lines (31 loc) · 692 Bytes

 master

/

ashprofile.sql

Top

File metadata and controls

• Code
• Blame

39 lines (31 loc) · 692 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

set linesize 1000

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.ashprofile.log

-- shows a profile of a sql statement's

-- ASH time including CPU and waits.

select

case SESSION_STATE

when 'WAITING' then event

else SESSION_STATE

end TIME_CATEGORY,

(count(*)*10) seconds

from DBA_HIST_ACTIVE_SESS_HISTORY

where

sql_id = 'cq433j04qgb18'

group by SESSION_STATE,EVENT

order by seconds desc;

spool off