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

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

 

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>

 

 

 

 

 

 

 

 

 

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

 
posted @ 2023-04-07 15:26  igoodful  阅读(234)  评论(0编辑  收藏  举报