数据库控制台宽度和分页长度设置

通常情况下，我们的控制台的显示，如果不加以设定，不好阅读，因为控制台显示一行的长度不够！

我们可以进入sql控制后，执行set line 2000 pagesize 200

SQL> set line 2000 pagesize 200
SQL> select * from dba_users;

51 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 96174755

------------------------------------------------------------------------------------------------------
| Id  | Operation          | Name            | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT       |                 |    19 |  4294 |    28  (11)| 00:00:01 |
|*  1 |  HASH JOIN         |                 |    19 |  4294 |    28  (11)| 00:00:01 |
|*  2 |   HASH JOIN        |                 |    19 |  4028 |    22  (14)| 00:00:01 |
|*  3 |    HASH JOIN           |                 |    19 |  3762 |    15  (14)| 00:00:01 |
|*  4 |     HASH JOIN OUTER    |                 |    19 |  3401 |    13  (16)| 00:00:01 |
|*  5 |      HASH JOIN         |                 |    19 |  2679 |    10  (10)| 00:00:01 |
|*  6 |       HASH JOIN        |                 |    19 |  2489 |     8  (13)| 00:00:01 |
|   7 |        MERGE JOIN CARTESIAN|                 |     1 |    26 |     4   (0)| 00:00:01 |
|*  8 |     TABLE ACCESS FULL  | PROFILE$           |     1 |    13 |     2   (0)| 00:00:01 |
|   9 |     BUFFER SORT    |                 |     1 |    13 |     2   (0)| 00:00:01 |
|* 10 |      TABLE ACCESS FULL | PROFILE$           |     1 |    13 |     2   (0)| 00:00:01 |
|* 11 |        TABLE ACCESS FULL   | USER$          |    27 |  2835 |     3   (0)| 00:00:01 |
|  12 |       TABLE ACCESS FULL    | PROFNAME$          |     1 |    10 |     2   (0)| 00:00:01 |
|* 13 |      TABLE ACCESS FULL     | RESOURCE_GROUP_MAPPING$ |    1 |    38 |     2   (0)| 00:00:01 |
|  14 |     TABLE ACCESS FULL      | USER_ASTATUS_MAP        |     9 |   171 |     2   (0)| 00:00:01 |
|  15 |    TABLE ACCESS FULL       | TS$            |    15 |   210 |     6   (0)| 00:00:01 |
|  16 |   TABLE ACCESS FULL    | TS$            |    15 |   210 |     6   (0)| 00:00:01 |
------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - access("U"."TEMPTS#"="TTS"."TS#")
   2 - access("U"."DATATS#"="DTS"."TS#")
   3 - access("U"."ASTATUS"="M"."STATUS#")
   4 - access("CGM"."VALUE"(+)="U"."NAME")
   5 - access("U"."RESOURCE$"="P"."PROFILE#")
   6 - access("U"."RESOURCE$"="PR"."PROFILE#")
   8 - filter("DP"."RESOURCE#"=1 AND "DP"."TYPE#"=1 AND "DP"."PROFILE#"=0)
  10 - filter("PR"."RESOURCE#"=1 AND "PR"."TYPE#"=1)
  11 - filter("U"."TYPE#"=1)
  13 - filter("CGM"."ATTRIBUTE"(+)='ORACLE_USER' AND "CGM"."STATUS"(+)='ACTIVE')


Statistics
----------------------------------------------------------
      8  recursive calls
      0  db block gets
    166  consistent gets
      0  physical reads
      0  redo size
       4583  bytes sent via SQL*Net to client
    557  bytes received via SQL*Net from client
      5  SQL*Net roundtrips to/from client
      1  sorts (memory)
      0  sorts (disk)
     51  rows processed

SQL> 

最终显示比较整齐

专业墙纸贴纸厨房用具装饰出售，本人网店经营

博客对你有用记得访问下哦，增加下访问量，如有需要可以下单购买哦^_^。https://item.taobao.com/item.htm?id=569617707364