FilesExpand file tree

 master

/

tables.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

29 lines (24 loc) · 730 Bytes

 master

/

tables.sql

Top

File metadata and controls

• Code
• Blame

29 lines (24 loc) · 730 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

drop table select_statements;

create table select_statements

(sqlnumber number,

sql_text clob);

create unique index select_statements_i1 on select_statements(sqlnumber);

drop table test_results;

create table test_results

(test_name varchar2(2000),

sqlnumber number,

sql_id VARCHAR2(13),

explain_plan_hash number,

execute_plan_hash number,

rows_fetched number,

elapsed_in_seconds number,

CPU_used_by_this_session number,

consistent_gets number,

db_block_gets number,

parse_time_elapsed number,

physical_reads number,

user_commits number,

db_block_changes number,

error_message varchar2(64));

create unique index test_results_i1 on test_results(test_name,sqlnumber);

create index test_results_i2 on test_results(sqlnumber);