Sunday, October 21, 2012

4 Oracle Parameters

Below query can show the oracle hidden parameters , I got the query from the book here

This query also show the hidden parameter start with _, don’t change it unless it is direct by the oracle support or you know what you are doing…

select x.ksppinm name, y.ksppstvl value, y.ksppstdf isdefault, decode( bitand(y.ksppstvf,7),1, 'MODIFED',4, 'SYSTEM_MOD','FALSE') ismod, 
decode( bitand(y.ksppstvf,2),2, 'TRUE','FALSE') isadj
from sys.x$ksppi x, sys.x$ksppcv y
where x.inst_id= userenv('Instance')
and y.inst_id=  userenv('Instance')
and x.indx= y.indx
order by translate(x.ksppinm,'_',' ');

image

4 comments:

  1. Rolex propose une replique rolex montres large gamme de modèles, des montres professionnelles fausses rolex cosmograph daytona montres aux montres classiques, qui s'adaptent à tous les poignets. Choisissez votre modèle préféré, la matière, la lunette, le cadran et le bracelet pour explorer la collection Rolex et trouver la montre qui vous convient.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. cheap balenciaga trainers is a Spanish luxury fashion house founded in 1917 by the cheap balenciaga allover logo triple s sneaker Basque designer Val Balenciaga. Balenciaga has a reputation as a strict standard for fashion designers, and is known as the "Master of All America" Dior. His bubble skirt and peculiar, feminine but "modern" silhouette became the trademark of the house.

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates