Oracle all_parameters View

You can view an all_parameters table in dbsnake's blog. You can use this table to view hidden parameters. But I confirmed later that this table is not available. Therefore, this is a view created by dbsnake.

 

How to view Oracle parameter categories and Parameters

Http://blog.csdn.net/tianlesoftware/article/details/5583655

 

In the above blog, there is an SQL script for querying implicit parameters. Based on this script, a view named all_parameters is created. The function is implemented. It is much easier to use this view to view implicit parameters.

 

/* Formatted on2011/7/28 15:01:16 (qp5 v5.163.1008.3004 )*/

Create view all_parameters

As

Select I. ksppinm name,

I. ksppdesc description,

Cv. ksppstvl value,

Cv. ksppstdf isdefault,

Decode (bitand (cv. ksppstvf, 7 ),

1, 'modified ',

4, 'System _ mod ',

'False ')

Ismodified,

Decode (bitand (cv. ksppstvf, 2), 2, 'true', 'false') isadjusted

From SYS. x $ ksppi I, SYS. x $ ksppcv CV

Where I. inst_id = userenv ('instance ')

And cv. inst_id = userenv ('instance ')

And I. indx = cv. indx

And I. ksppinm like '/_ %' escape '/'

Order by Replace (I. ksppinm ,'_','');

 

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 chat group: 40132017 chat group 2: 69087192

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.