ExaGridDba

alter session set container delays serveroutput

Sep 2nd, 2013
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. alter session set container = cdb$root;
  2. set serveroutput on
  3.  
  4. exec dbms_output.put_line( 'dbms output is on in cdb$root ' || sys_context ('userenv', 'con_name'))
  5.  
  6. alter session set container = kona;
  7. exec dbms_output.put_line( 'dbms output is OFF in pdb kona ' || sys_context ('userenv', 'con_name'))
  8.  
  9. set serveroutput on
  10. exec dbms_output.put_line( 'dbms output is on in pdb kona ' || sys_context ('userenv', 'con_name'))
  11.  
  12. alter session set container = cdb$root;
  13. exec dbms_output.put_line( 'dbms output remains on in cdb$root ' || sys_context ('userenv', 'con_name'))
  14.  
  15. alter session set container = kona;
  16. set serveroutput off
  17. exec dbms_output.put_line( 'kona. output discarded ' || sys_context ('userenv', 'con_name'))
  18. alter session set container = cdb$root;
  19. exec dbms_output.put_line( 'cdb$root. display delayed ' || sys_context ('userenv', 'con_name'))
  20.  
  21. set serveroutput on
  22. prompt serveroutput is on but you don't see the output yet
  23. prompt The delayed output will appear before the "Session altered." feedback
  24. alter session set container = cdb$root;
  25.  
  26. quit
  27.  
  28. output is:
  29.  
  30.  
  31. Session altered.
  32.  
  33. dbms output is on in cdb$root CDB$ROOT
  34.  
  35. PL/SQL procedure successfully completed.
  36.  
  37.  
  38. Session altered.
  39.  
  40.  
  41. PL/SQL procedure successfully completed.
  42.  
  43. dbms output is on in pdb kona KONA
  44.  
  45. PL/SQL procedure successfully completed.
  46.  
  47.  
  48. Session altered.
  49.  
  50. dbms output remains on in cdb$root CDB$ROOT
  51.  
  52. PL/SQL procedure successfully completed.
  53.  
  54.  
  55. Session altered.
  56.  
  57.  
  58. PL/SQL procedure successfully completed.
  59.  
  60.  
  61. Session altered.
  62.  
  63.  
  64. PL/SQL procedure successfully completed.
  65.  
  66. serveroutput is on but you don't see the output yet
  67. The delayed output will appear before the "Session altered." feedback
  68. cdb$root. display delayed CDB$ROOT
  69.  
  70. Session altered.
Advertisement
Add Comment
Please, Sign In to add comment