I'm trying to set linesize for my explain plan, but unable to do it. Can someone please point me what I might be missing here?
SQL> set linesize 300
SQL> explain plan for select /*+ GATHER_PLAN_STATISTICS */ count(*), shipto from libr_tbl group by shipto;
Explained.
SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY(FORMAT=>'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------
Plan hash value: 1488474053
------------------------------------------------
| Id | Operation | Name | E-Rows |
------------------------------------------------
| 0 | SELECT STATEMENT | | 3000 |
| 1 | HASH GROUP BY | | 3000 |
| 2 | TABLE ACCESS FULL| LIBR_TBL | 3000 |
------------------------------------------------
Note
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------
-----
- dynamic sampling used for this statement (level=2)
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
16 rows selected.
SQL>