Advertisement
Guest User

Untitled

a guest
Dec 11th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. SQL> conn / as sysdba
  2. Connected.
  3. SQL> show user
  4. USER is "SYS"
  5. SQL> select instance_name from v$instance
  6. 2 ;
  7.  
  8. INSTANCE_NAME
  9. ----------------
  10. orcl
  11.  
  12. SQL> select instance_name
  13. 2 from v$instance;
  14.  
  15. INSTANCE_NAME
  16. ----------------
  17. orcl
  18.  
  19. SQL> select name
  20. 2 from v$database;
  21.  
  22. NAME
  23. ---------
  24. ORCL
  25.  
  26. SQL> show parameter shared_pool_size;
  27.  
  28. NAME TYPE VALUE
  29. ------------------------------------ ----------- ------------------------------
  30. shared_pool_size big integer 0
  31. SQL> show parameter sga_target;
  32.  
  33. NAME TYPE VALUE
  34. ------------------------------------ ----------- ------------------------------
  35. sga_target big integer 0
  36. SQL> show parameter memory_target;
  37.  
  38. NAME TYPE VALUE
  39. ------------------------------------ ----------- ------------------------------
  40. memory_target big integer 808M
  41. SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement