Here is a script I got from the "honorable" Mark Leith. Run this as SYS.
set echo on spool parm1 select a.ksppinm "Parameter", a.ksppdesc "Description", b.ksppstvl "Session Value", c.ksppstvl "Instance Value" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '/_%' escape '/' / spool off Dave -----Original Message----- Sent: Thursday, May 30, 2002 7:28 AM To: Multiple recipients of list ORACLE-L >Someone posted a bit of SQL to list out the >undocumented parameters and >guess what ... I deleted it. Could someone repost >please ?? > >TIA > >Lee > You know this Chinese proverb, about giving a man a fish and feeding him once vs teaching him how to fish, and feeding him for all his life? The place where you should angle is V$FIXED_VIEW_DEFINITION, it will tell you how GV$PARAMETERS is built, which is the X$ table it accesses - and how it filters undocumented parameters out. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
