1. 如何查看当前用户
SQL> show user
USER is "SYS"
SQL>
2. 这2个表是做什么用的 x$ksppi , x$ksppcv
x$ksppi , x$ksppcv 可以查oracle隐含参数。
Select x.ksppinm name,y.ksppstvl value,y.ksppstdf isdefault,
Decode(bitand(y.ksppstvf,7),1,'MODIFY',4,'SYSTEM_MOD','FALSE') ismod,
Decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE') isadj
From
X$ksppi x,
X$ksppcv y
Where x.inst_id=userenv('Instance') and
y.inst_id=userenv('Instance') and
x.indx=y.indx and
x.ksppinm like '%_&par%'
order by translate(x.ksppinm,' _',' ');
SQL> select KSPPDESC, KSPPITY, ksppinm from x$ksppi where ksppinm like '_allow_
resetlogs_corruption%';
KSPPDESC KSPPITY KSPPINM
-----------------------------------------------------------------------------------------------------------------