SQL> set lines 500;
SQL> set pagesize 9999;
SQL> set long 9999;
SQL> select * from table(dbms_xplan.display_cursor('41348610',null,'advanced'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HASH_VALUE  41348610, child number 0
------------------------------------
 SELECT D.TABLESPACE_NAME,         SPACE "Total(M)",         SPACE -
NVL(FREE_SPACE, 0) "USED(M)",         ROUND((1 - NVL(FREE_SPACE, 0) /
SPACE) * 100, 2) "USED(%)",         FREE_SPACE "FREE(M)"    FROM
(SELECT TABLESPACE_NAME,                 ROUND(SUM(BYTES) / (1024 *
1024), 2) SPACE,                 SUM(BLOCKS) BLOCKS            FROM
DBA_DATA_FILES           GROUP BY TABLESPACE_NAME) D,         (SELECT
TABLESPACE_NAME,                 ROUND(SUM(BYTES) / (1024 * 1024), 2)
FREE_SPACE            FROM DBA_FREE_SPACE           GROUP BY
TABLESPACE_NAME) F   WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
UNION ALL --if have tempfile  SELECT D.TABLESPACE_NAME,         SPACE
"Total(M)",         USED_SPACE "USED(M)",         ROUND(NVL(USED_SPACE,
0) / SPACE * 100, 2) "USED(%)",         NVL(FREE_SPACE, 0) "FREE(M)"
FROM (SELECT TABLESPACE_NAME,                 ROUND(SUM(BYTES) / (1024
* 1024), 2) SPACE,                 SUM(BLOCKS) BLOCKS            FROM
DBA_TEMP_FILES           GROUP BY T

Plan hash value: 3967328987

----------------------------------------------------------------------------------------------------------
| Id  | Operation                             | Name             | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                      |                  |       |       |    20 (100)|          |
|   1 |  SORT ORDER BY                        |                  |     3 |   178 |    19  (22)| 00:00:01 |
|   2 |   UNION-ALL                           |                  |       |       |            |          |
|*  3 |    HASH JOIN OUTER                    |                  |     2 |   120 |    16  (19)| 00:00:01 |
|   4 |     VIEW                              |                  |     2 |    60 |     5  (20)| 00:00:01 |
|   5 |      HASH GROUP BY                    |                  |     2 |    68 |     5  (20)| 00:00:01 |
|   6 |       VIEW                            | DBA_DATA_FILES   |     2 |    68 |     4   (0)| 00:00:01 |
|   7 |        UNION-ALL                      |                  |       |       |            |          |
|   8 |         NESTED LOOPS                  |                  |     1 |   356 |     2   (0)| 00:00:01 |
|   9 |          NESTED LOOPS                 |                  |     1 |   341 |     1   (0)| 00:00:01 |
|  10 |           NESTED LOOPS                |                  |     1 |   328 |     1   (0)| 00:00:01 |
|* 11 |            FIXED TABLE FULL           | X$KCCFN          |     1 |   310 |     0   (0)|          |
|* 12 |            TABLE ACCESS BY INDEX ROWID| FILE$            |     1 |    18 |     1   (0)| 00:00:01 |
|* 13 |             INDEX UNIQUE SCAN         | I_FILE1          |     1 |       |     0   (0)|          |
|* 14 |           FIXED TABLE FIXED INDEX     | X$KCCFE (ind:1)  |    20 |   260 |     0   (0)|          |
|  15 |          TABLE ACCESS CLUSTER         | TS$              |     1 |    15 |     1   (0)| 00:00:01 |
|* 16 |           INDEX UNIQUE SCAN           | I_TS#            |     1 |       |     0   (0)|          |
|  17 |         NESTED LOOPS                  |                  |     1 |   399 |     2   (0)| 00:00:01 |
|  18 |          NESTED LOOPS                 |                  |     1 |   386 |     2   (0)| 00:00:01 |
|  19 |           NESTED LOOPS                |                  |     1 |   377 |     1   (0)| 00:00:01 |
|  20 |            NESTED LOOPS               |                  |     1 |   362 |     0   (0)|          |
|* 21 |             FIXED TABLE FULL          | X$KCCFN          |     1 |   310 |     0   (0)|          |
|* 22 |             FIXED TABLE FIXED INDEX   | X$KTFBHC (ind:1) |     1 |    52 |     0   (0)|          |
|  23 |            TABLE ACCESS CLUSTER       | TS$              |     1 |    15 |     1   (0)| 00:00:01 |
|* 24 |             INDEX UNIQUE SCAN         | I_TS#            |     1 |       |     0   (0)|          |
|* 25 |           TABLE ACCESS BY INDEX ROWID | FILE$            |     1 |     9 |     1   (0)| 00:00:01 |
|* 26 |            INDEX UNIQUE SCAN          | I_FILE1          |     1 |       |     0   (0)|          |
|* 27 |          FIXED TABLE FIXED INDEX      | X$KCCFE (ind:1)  |    20 |   260 |     0   (0)|          |
|  28 |     VIEW                              |                  |     5 |   150 |    11  (19)| 00:00:01 |
|  29 |      HASH GROUP BY                    |                  |     5 |   105 |    11  (19)| 00:00:01 |
|  30 |       VIEW                            | DBA_FREE_SPACE   |    79 |  1659 |    10  (10)| 00:00:01 |
|  31 |        UNION-ALL                      |                  |       |       |            |          |
|  32 |         NESTED LOOPS                  |                  |     1 |    64 |     1   (0)| 00:00:01 |
|  33 |          NESTED LOOPS                 |                  |     1 |    45 |     1   (0)| 00:00:01 |
|  34 |           INDEX FULL SCAN             | I_FILE2          |     5 |    30 |     1   (0)| 00:00:01 |
|* 35 |           TABLE ACCESS CLUSTER        | FET$             |     1 |    39 |     0