查看oracle隐藏参数
来源:互联网 发布:淘宝卖家被冻结怎么办 编辑:程序博客网 时间:2024/04/29 03:30
select name,
value,
decode(isdefault, 'TRUE', 'Y', 'N') as "Default",
decode(ISEM, 'TRUE', 'Y', 'N') as SesMod,
decode(ISYM, 'IMMEDIATE', 'I', 'DEFERRED', 'D', 'FALSE', 'N') as SysMod,
decode(IMOD, 'MODIFIED', 'U', 'SYS_MODIFIED', 'S', 'N') as Modified,
decode(IADJ, 'TRUE', 'Y', 'N') as Adjusted,
description
from ( --GV$SYSTEM_PARAMETER
select x.inst_id as instance,
x.indx + 1,
ksppinm as name,
ksppity,
ksppstvl as value,
ksppstdf as isdefault,
decode(bitand(ksppiflg / 256, 1), 1, 'TRUE', 'FALSE') as ISEM,
decode(bitand(ksppiflg / 65536, 3),
1,
'IMMEDIATE',
2,
'DEFERRED',
'FALSE') as ISYM,
decode(bitand(ksppstvf, 7), 1, 'MODIFIED', 'FALSE') as IMOD,
decode(bitand(ksppstvf, 2), 2, 'TRUE', 'FALSE') as IADJ,
ksppdesc as description
from x$ksppi x, x$ksppsv y
where x.indx = y.indx
and substr(ksppinm, 1, 1) = '_'
and x.inst_id = USERENV('Instance'))
order by name;
value,
decode(isdefault, 'TRUE', 'Y', 'N') as "Default",
decode(ISEM, 'TRUE', 'Y', 'N') as SesMod,
decode(ISYM, 'IMMEDIATE', 'I', 'DEFERRED', 'D', 'FALSE', 'N') as SysMod,
decode(IMOD, 'MODIFIED', 'U', 'SYS_MODIFIED', 'S', 'N') as Modified,
decode(IADJ, 'TRUE', 'Y', 'N') as Adjusted,
description
from ( --GV$SYSTEM_PARAMETER
select x.inst_id as instance,
x.indx + 1,
ksppinm as name,
ksppity,
ksppstvl as value,
ksppstdf as isdefault,
decode(bitand(ksppiflg / 256, 1), 1, 'TRUE', 'FALSE') as ISEM,
decode(bitand(ksppiflg / 65536, 3),
1,
'IMMEDIATE',
2,
'DEFERRED',
'FALSE') as ISYM,
decode(bitand(ksppstvf, 7), 1, 'MODIFIED', 'FALSE') as IMOD,
decode(bitand(ksppstvf, 2), 2, 'TRUE', 'FALSE') as IADJ,
ksppdesc as description
from x$ksppi x, x$ksppsv y
where x.indx = y.indx
and substr(ksppinm, 1, 1) = '_'
and x.inst_id = USERENV('Instance'))
order by name;
- 查看oracle隐藏参数
- 查看oracle 隐藏参数
- oracle查看隐藏参数
- oracle 查看隐藏参数
- Oracle 查看隐藏参数
- oracle查看隐藏参数
- oracle 查看隐藏参数
- oracle 查看隐藏参数
- oracle如何查看隐藏参数
- 在ORACLE中如何查看隐藏参数
- oracle查看隐藏参数的方法
- 查看隐藏参数
- oracle隐藏参数查询
- 获取Oracle隐藏参数
- oracle parameter-隐藏参数
- 查看oracle隐含参数
- oracle 查看隐含参数
- 查看oracle隐含参数
- select 选中 取值 删除 显示与隐藏
- 要转正了
- 插值和拟合的区别
- 业界今年换工作的特别多
- ASP网站静态化解决方案研究
- 查看oracle隐藏参数
- Linux下C的exec系统调用
- CSDN博客文章的备份及导出电子书CHM(使用blog_backup)
- 刚刚看过《我们无处安放的青春》写点观感
- linux下的查找命令
- IIS和Serv-U端口冲突问题
- 关于mvnForum论坛的二次开发环境搭建
- 假设你的生命突然没有了,你还能做什么?
- 笔记本电脑和台式电脑在家里没有装网也可以上网(真后悔现在才看到...,因为我安了网线)