oracle在命令行中显示很乱的解决办法

发布时间 2023-04-07 15:35:46作者: igoodful

############

 

SQL> set linesize 800
SQL> set pagesize 900
SQL> col plan_table_output for a200
SQL> select * from v$standby_log;

    GROUP# DBID                                        THREAD#  SEQUENCE#      BYTES  BLOCKSIZE       USED ARC STATUS     FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME LAST_CHANGE# LAST_TIME
---------- ---------------------------------------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- --------- ------------ --------- ------------ ---------
         4 3592152041                                        1         16  536870912        512    2452992 YES ACTIVE             28941 07-APR-23        33723 07-APR-23        33723 07-APR-23
         5 UNASSIGNED                                        0          0  536870912        512        512 YES UNASSIGNED             0                      0                      0
         6 UNASSIGNED                                        0          0  536870912        512        512 YES UNASSIGNED             0                      0                      0
         7 UNASSIGNED                                        0          0  536870912        512        512 YES UNASSIGNED             0                      0                      0

SQL>

 

 

 

 

 

 

 

 

 

######################