Brain Log

Install Oracle Instant Client and SDK Step 1 Download the latest Oracle Instant Client and SDK from the Oracle website (Yeah, fuck you Oracle, you need to create an account to download the files). http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html Look for instantclient-basic-linux.x64-12.2.0.1.0.zip and instantclient-sdk-linux.x64-12.2.0.1.0.zip. Step 2 Create a new folder to store the Oracle Instant Client files on your machine. mkdir /opt/oracle And move your files to /opt/oracle. Step 3 Extract the files cd /opt/oracle unzip instantclient-basic-linux.x64-12.2.0.1.0.zip unzip instantclient-sdk-linux.x64-12.2.0.1.0.zip Step 4 Next, we need to symlink the .so files. ln -s /opt/oracle/instantclient_12_2/libclntsh.so.12.2 /opt/oracle/instantclient_12_2/libclntsh.so ln -s /opt/oracle/instantclient_12_2/libocci.so.12.2 /opt/oracle/instantclient_12_2/libocci.so Step 5 Now lets add the folder to the ldconfig's config folder. echo /opt/oracl

The  sessions  parameter is derived from the  processes  parameter and changes accordingly when you change the number of max processes. See the  Oracle docs  for further info. To get only the info about the sessions: select current_utilization , limit_value from v $ resource_limit where resource_name = 'sessions' ; CURRENT_UTILIZATION LIMIT_VALUE ------------------- ----------- 110 792 Try this to show info about both: select resource_name , current_utilization , max_utilization , limit_value from v $ resource_limit where resource_name in ( 'sessions' , 'processes' ); RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE ------------- ------------------- --------------- ----------- processes 96 309 500 sessions 104 323 792