underscore parameters

Requete  poure avoir  les  underscore  parameters :


SELECT
   a.ksppinm  "Parameter",
   decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl) "Session",
   c.ksppstvl "Instance",
   decode(p.isses_modifiable,'FALSE','F','TRUE','T') "S",
   decode(p.issys_modifiable,'FALSE','F','TRUE','T','IMMEDIATE','I','DEFERRED','D') "I",
   decode(p.isdefault,'FALSE','F','TRUE','T') "D",
   a.ksppdesc "Description"
 FROM x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter p
 WHERE a.indx = b.indx AND a.indx = c.indx
   AND p.name(+) = a.ksppinm
   AND UPPER(a.ksppinm) LIKE UPPER('_optimizer_join_factorization')
 ORDER BY a.ksppinm;


To view existing hidden parameters execute the following command
while connected AS SYSDBA:
col  NAME  for a35
col DESCRIPTION  for a100

    SELECT name,description from SYS.V$PARAMETER WHERE name
        LIKE '\_%' ESCAPE '\';

To view existing non-default events execute the following commands
while connected AS SYSDBA':
  Events:
    SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
      WHERE  UPPER(name) ='EVENT' AND  isdefault='FALSE'

  Trace Events:
    SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
      WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'





 ======================================
 parametre  deprecies:
 ======================================
 SELECT name from v$parameter WHERE isdeprecated = 'TRUE' ORDER BY name;