p136.sql

来自「oracal的入门知识」· SQL 代码 · 共 7 行

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 '%pool_size%'
/