Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Mar 13th, 2018 61 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  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