ExaGridDba

Incorrect v$parameter isdefault = true

Apr 19th, 2016
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. SQL> set linesize 300
  2. SQL> column ksppstvl format a30
  3. SQL> select indx from x$ksppi where ksppinm ='optimizer_features_enable' and con_id = 1;
  4.  
  5. INDX
  6. ----------
  7. 2740
  8.  
  9. SQL> select ksppstdf, ksppstvl from x$ksppcv where indx = 2740;
  10.  
  11. KSPPSTDF KSPPSTVL
  12. --------- ------------------------------
  13. TRUE 12.1.0.2
  14.  
  15. SQL> alter session set optimizer_features_enable = '12.1.0.1';
  16.  
  17. Session altered.
  18.  
  19. SQL> select ksppstdf, ksppstvl from x$ksppcv where indx = 2740;
  20.  
  21. KSPPSTDF KSPPSTVL
  22. --------- ------------------------------
  23. TRUE 12.1.0.1
  24.  
  25. SQL> column value format a30
  26. SQL> select isdefault, value from v$parameter where name ='optimizer_features_enable' and con_id = 1;
  27.  
  28. ISDEFAULT VALUE
  29. --------- ------------------------------
  30. TRUE 12.1.0.1
Advertisement
Add Comment
Please, Sign In to add comment