1. Current number of database connectionsSelect Count(*) fromV$processwhereProgram='ORACLE. EXE (SHAD)'; 2. Maximum number of connections allowed for the databaseSelectValue fromV$parameterwhereName='Processes'3. To modify the maximum number of connections, you need to restart the database to take effect:AlterSystemSetProcesses= -Scope=SPFile;4. Restart the databaseshutdownImmediate;startup;5. See which users are currently using the data
SELECTOsuser, A.username,cpu_time/Executions/1000000||'s', B.sql_text,machine fromv$session A, V$sqlarea bwhereA.sql_address=B.addressOrder byCpu_time/Executionsdesc;6the current session connection numberSelect Count(*) fromv$session7. Number of concurrent connectionsSelect Count(*) fromV$sessionwhereStatus='ACTIVE' 8. Maximum connection show parameter processes
Oracle Query database maximum connections, etc.