FilesExpand file tree

 master

/

plan.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

36 lines (25 loc) · 645 Bytes

 master

/

plan.sql

Top

File metadata and controls

• Code
• Blame

36 lines (25 loc) · 645 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

set linesize 1000

set pagesize 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.plan.log

set define off

-- this version only works on 9.2 or higher - gets full plan table details from display()

truncate table plan_table;

explain plan into plan_table for

select * from dual

/

set markup html preformat on

select * from table(dbms_xplan.display('PLAN_TABLE',NULL,'ADVANCED'));

select object_name from plan_table;

spool off