FilesExpand file tree

 master

/

dumpsql.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

64 lines (53 loc) · 1.02 KB

 master

/

dumpsql.sql

Top

File metadata and controls

• Code
• Blame

64 lines (53 loc) · 1.02 KB

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

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

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

set serveroutput on size 1000000

spool &ns.dumpsql.log

-- 0xdhgfzfz5hnf

-- 1cas85dwbyckb

-- 2vcz2a68pkm26

-- 37kc1a98qcmt2

-- 3pnxxdpbbf38t

-- 5vhy4xm9vcsv1

-- 6svwbs20bj36k

-- 84amr0m8m7d55

-- 8cm6cx5qpdk8m

-- aahxfqwkbrta4

-- dqjugc3x5d472

-- gvu38800qggb9

-- edit the where clause of the TEXT_CURSOR so you search the SQL_TEXT clob for text that

-- is in the SQL you want to find in the AWR

set define off

select

SQL_ID,

SQL_TEXT

FROM DBA_HIST_SQLTEXT

where

sql_id in

('0xdhgfzfz5hnf',

'1cas85dwbyckb',

'2vcz2a68pkm26',

'37kc1a98qcmt2',

'3pnxxdpbbf38t',

'5vhy4xm9vcsv1',

'6svwbs20bj36k',

'84amr0m8m7d55',

'8cm6cx5qpdk8m',

'aahxfqwkbrta4',

'dqjugc3x5d472',

'gvu38800qggb9')

order by sql_id;

spool off