SQL> set linesize 120 SQL> col name for a20 SQL> col value for a20 SQL> col describ for a30 SQL> select x.ksppinm name,y.ksppstvl value,x.ksppdesc describ 2 from sys.x$ksppi x,sys.x$ksppcv y 3 where x.inst_id=userenv('Instance') 4 and y.inst_id=userenv('Instance') 5 and x.indx=y.indx 6 and x.ksppinm like'%&par%' 7 / Enter value for par: _ksmg_granule_size old 6: and x.ksppinm like'%&par%' new 6: and x.ksppinm like'%_ksmg_granule_size%' NAME VALUE DESCRIB -------------------- -------------------- ------------------------------ _ksmg_granule_size 4194304 granule size in bytes SQL> //脚本如下: set linesize 120 col name for a20 col value for a20 col describ for a30 select x.ksppinm name,y.ksppstvl value,x.ksppdesc describ from sys.x$ksppi x,sys.x$ksppcv y where x.inst_id=userenv('Instance') and y.inst_id=userenv('Instance') and x.indx=y.indx and x.ksppinm like'%&par%' /