daily pastebin goal
23%
SHARE
TWEET

Untitled

a guest Mar 13th, 2018 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select current_utilization, limit_value
  2. from v$resource_limit
  3. where resource_name='sessions';
  4.    
  5. current_utilization, limit_value
  6. 177, 987
  7.    
  8. select max(a.value) as highest_open_cur, p.value as max_open_cur
  9.   from v$sesstat a, v$statname b, v$parameter p
  10.   where a.statistic# = b.statistic#
  11.   and b.name = 'opened cursors current'
  12.   and p.name= 'open_cursors'
  13.   group by p.value;
  14.    
  15. highest_open_cur, max_open_cur
  16.   241, 4000
  17.    
  18. Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production
  19. TNS for 64-bit Windows: Version 12.2.0.1.0 - Production
  20.    
  21. Inter® Xeon® Gold 6126 CPU @2.6 Ghz
  22. 4 Sockets, 4 Virtual Processors
  23. Java HotSpot(TM) 64-Bit Server VM (build 25.162-b12, mixed mode)
  24. HEAP=-Xms20G -Xmx20G -XX:MaxMetaspaceSize=128m
  25. Windows Server 2016 Standard
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top