FilesExpand file tree

 main

/

STA_SQLID_Cursor.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

27 lines (22 loc) · 709 Bytes

 main

/

STA_SQLID_Cursor.sql

Copy path

Top

File metadata and controls

• Code
• Blame

27 lines (22 loc) · 709 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

Create tuning task

set long 1000000000

DECLARE

l_sql_tune_task_id VARCHAR2(100);

BEGIN

l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task (

sql_id => 'apwfwjhgc9sk8',

scope => DBMS_SQLTUNE.scope_comprehensive,

time_limit => 500,

task_name => 'apwfwjhgc9sk8_tuning_task_1',

description => 'Tuning task for statement apwfwjhgc9sk8');

DBMS_OUTPUT.put_line('l_sql_tune_task_id: ' || l_sql_tune_task_id);

END;

/

Execute tuning task

EXEC DBMS_SQLTUNE.execute_tuning_task(task_name => 'apwfwjhgc9sk8_tuning_task_1');

Generate report

SET LONG 10000000;

SET PAGESIZE 100000000

SET LINESIZE 200

SELECT DBMS_SQLTUNE.report_tuning_task('apwfwjhgc9sk8_tuning_task_1') AS recommendations FROM dual;

SET PAGESIZE 24