Coding TricksOracle all_parameters view
you see a all_parameters table in the blog of dbsnake, which allows you to see the implied parameters. but it was later confirmed that there was no such table. so this should be a view that dbsnake built himself.
Oracle parameter classification and how parameters are viewed
http://www.cndba.cn/Dave/article/1173
In the blog above, there is an SQL script that queries for implied parameters, according to which a view called all_parameters is created. The function is implemented. It's a lot easier to use this view to see the implied 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, '_', '');
-------------------------------------------------------------------------------------------------------
QQ:492913789
Email:[email protected]
Blog: http://www.cndba.cn/dave
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook: http://www.facebook.com/tianlesoftware
Linkedin: http://cn.linkedin.com/in/tianlesoftware
DBA1 GROUP: 62697716 (FULL); DBA2 GROUP: 62697977 (FULL) DBA3 GROUP: 62697850 (FULL)
DBA SUPERGROUP: 63306533 (FULL); DBA4 GROUP: 83829929 DBA5 GROUP: 142216823
DBA6 GROUP: 158654907 CHAT GROUP: 40132017 CHAT GROUP 2: 69087192
--Adding groups is required to explain the relationship between Oracle table space and data files in the notes, otherwise the request will be rejected