oracle调整显示长宽,Oracle sqlplus 调整show parameter 显示结果宽度

Oracle SQLplus 中可以通过show parameter命令查看参数值，改命令返回有三列，如下：https://www.cndba.cn/dave/article/4083

SQL> set lines 180

SQL> show parameter db_recovery_file_dest

NAME TYPE VALUE

------------------------------------ --------------------------------- ------------------------------

db_recovery_file_dest string /u01/app/oracle/fast_recovery_

area

db_recovery_file_dest_size big integer 12732M

SQL> col type for a30

SQL> show parameter db_recovery_file_dest

NAME TYPE VALUE

------------------------------------ ------------------------------ ------------------------------

db_recovery_file_dest string /u01/app/oracle/fast_recovery_

area

db_recovery_file_dest_size big integer 12732M

通过上面的结果查询，可以发现，通过set lines 和 col 直接调整value的长度没有生效，并且value 列大部分情况都是不够的。 https://www.cndba.cn/dave/article/4083

https://www.cndba.cn/dave/article/4083https://www.cndba.cn/dave/article/4083

如果要调整，可以按如下命令设置：https://www.cndba.cn/dave/article/4083

https://www.cndba.cn/dave/article/4083

SQL> set linesize 140

SQL> col value_col_plus_show_param format a70 --调整value列宽度为70个字符

SQL>show parameter db_recovery_file_dest

NAME TYPE VALUE

------------------------------------ ------------------------------ ----------------------------------------------------------------------

db_recovery_file_dest string /u01/app/oracle/fast_recovery_area

db_recovery_file_dest_size big integer 12732M

SQL>

[oracle@www.cndba.cn_2 admin]$ cat glogin.sql

--

-- Copyright (c) 1988, 2005, Oracle. All Rights Reserved.

--

-- NAME

-- glogin.sql

--

-- DESCRIPTION

-- SQL*Plus global login "site profile" file

--

-- Add any SQL*Plus commands here that are to be executed when a

-- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.

--

-- USAGE

-- This script is automatically run

--

define _editor=vim

set serveroutput on size 1000000

set trimspool on

set long 5000

set linesize 1024

set pagesize 9999

column plan_plus_exp format a80

column value_col_plus_show_param format a70

column type_col_plus_show_param format a20

alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

set sqlprompt '&_user.@&_connect_identifier.>'

[oracle@www.cndba.cn_2 admin]$

之后直接生效：https://www.cndba.cn/dave/article/4083

[oracle@www.cndba.cn_2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Mar 14 21:43:10 2020

Version 19.6.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.6.0.0.0

Session altered.

SYS@cndba>show parameter db_recovery

NAME TYPE VALUE

------------------------------------ --------------------------------- ----------------------------------------------------------------------

db_recovery_file_dest string /u01/app/oracle/fast_recovery_area

db_recovery_file_dest_size big integer 12732M

SYS@cndba>

版权声明：本文为博主原创文章，未经博主允许不得转载。