提问帖

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

-----------------------------------------------------------------------------------------------------------------   

allow resetlogs even if it will cause corruption      1                _allow_resetlogs_corruption