Oracle Database Discussions

I want to paste the explain plan of my query taken from the Enterprise Manager(EM) to know, how i can tune it, but when i paste it in the editor the format changes, how can i keep the format of my explain plan intact.

Just for refrence i also pasting my expain plan below:

Object Object Type Order Rows Size (KB) Cost Time (sec) CPU Cost I/O Cost
69 47261
68 1 0.591 47261 568 27468311742 44055

67 1 0.591 47261 568 27468311742 44055
66 1 0.272 47261 568 27468311742 44055
65
22 1604 437.027 8187 99 1944488666 7960
20
19 1604 404.133 8148 98 1932799665 7922
ASSET_CATEGORIES
TABLE 1 5069 158.406 17 1 2989432 17
18 1604 354.008 8130 98 1924605611 7905
SITES
TABLE 2 2769 70.307 209 3 15185494 207
17 1604 313.281 7920 96 1904560497 7698
14
13 1604 292.918 7919 96 1904460160 7697
11 1604 230.262 7901 95 1896439356 7680
9 1287 162.132 7813 94 1867125690 7595
7 1287 118.143 7560 91 1829528122 7346
5 1229 37.206 5 1 348503 5
CL_PK
INDEX (UNIQUE) 3 1 0.006 0 1050 0
WORK_CENTERS
TABLE 4 1229 30.005 5 1 347453 5
ASSETS
TABLE 6 1287 79.181 7554 91 1824582698 7341
ASSET_TYPES
TABLE 8 80882 2,764.521 252 4 25032447 249
ATC_PK
INDEX (UNIQUE) 10 100626 1,768.816 87 2 14774146 85
ASSET_CATEGORIES
TABLE 12 5069 198.008 17 1 2989432 17
OPERATIONAL_STATUS
TABLE 16 1 0.013 1 1 8361 1
OPS_PK
INDEX (UNIQUE) 15 1 0 1050 0
MANUFACTURERS
TABLE 21 19275 395.288 39 1 5237030 38
64 3 0.125 49 1 8606189 3
63
26 1 0.043 3 1 38447 3
ASSETS
TABLE 24 1 0.023 3 1 36547 3
AS_PK
INDEX (UNIQUE) 23 1 2 1 28686 2
PP_UK
INDEX (UNIQUE) 25 1 0.020 0 1900 0
41 1 0.041 4 1 44919 4
ASSETS
TABLE 28 1 0.023 3 1 36547 3
AS_PK
INDEX (UNIQUE) 27 1 Operation 1 28686 2
ATC_PK
INDEX (UNIQUE) 40 1 0.018 SELECT STATEMENT 1 8371 1
39 WINDOW SORT
38 VIEW

ASSET_CATEGORIES
TABLE 32 HASH UNIQUE
NESTED LOOPS 31 1 0.034 FILTER
1 78220467 6
INDEX FAST FULL SCAN ACA_PK
INDEX (UNIQUE) 29 5069 44.552 HASH JOIN 1 700859 5
INDEX RANGE SCAN SAC_UK
INDEX (UNIQUE) 30 1 0.025 FILTER
1 15293 1
HASH JOIN 35 HASH JOIN RIGHT OUTER
CONNECT BY PUMP 33 TABLE ACCESS FULL
TABLE ACCESS FULL ASSET_CATEGORIES
TABLE 34 5069 84.153 HASH JOIN 1 2989432 17
TABLE ACCESS FULL ASSET_CATEGORIES
TABLE 36 5069 84.153 TABLE ACCESS FULL 1 2989432 17
INDEX UNIQUE SCAN SAC_UK
INDEX (UNIQUE) 37 1 0.025 NESTED LOOPS OUTER 1 28686 2
NESTED LOOPS 62 1 0.041 FILTER
1 44919 4
TABLE ACCESS BY INDEX ROWID ASSETS
TABLE 43 1 0.023 HASH JOIN OUTER 1 36547 3
INDEX UNIQUE SCAN AS_PK
INDEX (UNIQUE) 42 1 HASH JOIN OUTER 1 28686 2
INDEX RANGE SCAN ATC_PK
INDEX (UNIQUE) 61 1 0.018 HASH JOIN 1 8371 1
FILTER
60 HASH JOIN
CONNECT BY WITH FILTERING 59 NESTED LOOPS
TABLE ACCESS BY INDEX ROWID ASSET_CATEGORIES
TABLE 50 INDEX UNIQUE SCAN
NESTED LOOPS 49 1 0.043 TABLE ACCESS FULL 1 32846 4
NESTED LOOPS 47 1 0.034 TABLE ACCESS FULL 1 30946 4
INDEX RANGE SCAN PPT_PK
INDEX (UNIQUE) 44 1 0.021 TABLE ACCESS FULL 1 21614 3
TABLE ACCESS BY INDEX ROWID PROBLEM_TYPES
TABLE 46 1 0.014 INDEX FAST FULL SCAN 1 9331 1
INDEX UNIQUE SCAN PT_PK
INDEX (UNIQUE) 45 1 TABLE ACCESS FULL 1900 0
INDEX UNIQUE SCAN ACA_PK
INDEX (UNIQUE) 48 1 0.009 TABLE ACCESS BY INDEX ROWID 1900 0
HASH JOIN 53 INDEX UNIQUE SCAN
CONNECT BY PUMP 51 TABLE ACCESS FULL
TABLE ACCESS FULL ASSET_CATEGORIES
TABLE 52 5069 84.153 SORT UNIQUE 1 2989432 17
TABLE ACCESS FULL ASSET_CATEGORIES
TABLE 54 5069 84.153 UNION-ALL 1 2989432 17
NESTED LOOPS 58 1 0.034 NESTED LOOPS 1 30996 4
INDEX RANGE SCAN PPT_PK
INDEX (UNIQUE) 55 1 0.021 TABLE ACCESS BY INDEX ROWID 1 21614 3
TABLE ACCESS BY INDEX ROWID PROBLEM_TYPES
TABLE 57 1 0.014 INDEX UNIQUE SCAN 1 9381 1
INDEX UNIQUE SCAN PT_PK
INDEX (UNIQUE) 56 1 INDEX UNIQUE SCAN 1900 0
NESTED LOOPS
TABLE ACCESS BY INDEX ROWID
INDEX UNIQUE SCAN
INDEX RANGE SCAN
FILTER

CONNECT BY WITH FILTERING
TABLE ACCESS BY INDEX ROWID