FilesExpand file tree

main

/

dba_hist_sqlbind.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

26 lines (26 loc) · 590 Bytes

main

/

dba_hist_sqlbind.sql

Copy path

Top

File metadata and controls

• Code
• Blame

26 lines (26 loc) · 590 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

undef sql_id

undef bsnap

undef esnap

-- run latest_awr_snaps.sql to obtain snap_id's

@plusenv

col sql_id format a13

col name format a12 trunc

col pos format 999

col dtyp format 99999

col dtyps format a15

col lcap format a17

col value_string format a40

col snapid format 999999

select sql_id

,snap_id snapid

,to_char(last_captured,'YYMMDD HH24:MI:SS') lcap

,name

,position pos

,datatype dtyp

,datatype_string dtyps

,value_string

from DBA_HIST_SQLBIND

where SQL_ID ='&&sql_id'

and SNAP_ID between &&bsnap and &&esnap

order by snap_id, last_captured, position

;