Advertisement
ExaGridDba

alter system pdb scope and persistent

Apr 12th, 2015
283
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. [oracle@stormking cdb12102 pdbcreate]$ sqlplus /nolog
  2.  
  3. SQL*Plus: Release 12.1.0.2.0 Production on Sun Apr 12 15:48:12 2015
  4.  
  5. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  6.  
  7. SQL> conn bf/bf@//stormking:1521/pdbg as sysdba
  8. Connected.
  9. SQL> show parameter optimizer_capture_sql_plan_baselines
  10.  
  11. NAME TYPE VALUE
  12. ------------------------------------ ----------- ------------------------------
  13. optimizer_capture_sql_plan_baselines boolean FALSE
  14. SQL> alter system set optimizer_capture_sql_plan_baselines = true;
  15.  
  16. System altered.
  17.  
  18. SQL> shutdown immediate
  19. Pluggable Database closed.
  20. SQL> startup
  21. Pluggable Database opened.
  22.  
  23. The change is persistent across pdb close/open:
  24.  
  25. SQL> show parameter optimizer_capture_sql_plan_baselines
  26.  
  27. NAME TYPE VALUE
  28. ------------------------------------ ----------- ------------------------------
  29. optimizer_capture_sql_plan_baselines boolean TRUE
  30.  
  31. The change is limited to pdb scope:
  32. SQL> conn / as sysdba
  33. Connected.
  34. SQL> show parameter optimizer_capture_sql_plan_baselines
  35.  
  36. NAME TYPE VALUE
  37. ------------------------------------ ----------- ------------------------------
  38. optimizer_capture_sql_plan_baselines boolean FALSE
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement