Shulou(Shulou.com)06/01 Report--

-Enter name of the parameter when prompted

SET linesize 235col Parameter FOR a50col SESSION FOR a28col Instance FOR a55col S FOR a1col I FOR a1col D FOR a1col Description FOR a90SELECT a.ksppinm "Parameter", decode (P.issespace modifiers FOR a1col D FOR a1col Description FOR a90SELECT a.ksppinm "Parameter") "Session", c.ksppstvl "Instance", decode (p.isseshell modifiers) "S", decode (p.isseshell modifiers) 'DEFERRED','D') "I", decode (p.isdefaultGrammer) c.indx AND p.name LIKE UPPER ('% & 1%') ORDER BY a.ksppinm) "D", a.ksppdesc "Description" FROM x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter pWHERE a.indx = b.indx AND a.indx = c.indx AND p.name (+) = a.ksppinm AND UPPER (a.ksppinm) LIKE UPPER ('% & 1%') Enter value for 1:Here is the list of all undocumented parameters in Oracle 11g:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.