JavaScript implementation: how to write beautiful conditional expression>>>
sometimes you can connect to the database, Sometimes it can’t be connected.
it may be that the current number of connections on the database has exceeded the maximum it can handle.
selectcount (*) fromv $process — the current number of connections
selectvaluefromv $parameterwherename =’processes’ — the maximum number of connections allowed by the database
modify the maximum number of connections:
altersystemsetprocesses = 300scope = SPFILE<
restart the database:
shutdown immediate
startup;
— check which users are using the data
selectosuser, a.username, CPU_ time/executions/1000000||’s’,sql_ fulltext,machine
fromv$sessiona,v$sqlareab
wherea.sql_ address=b.addressorderbycpu_ time/executionsdesc;
Similar Posts:
- [Solved] MYSQL Error 1040 (HY000): too many connections
- ORA-12519: TNS:no appropriate service handler found
- Nginx Error: too many open files [How to Solve]
- Sometimes ora-04062 error occurs when database is running stored procedure
- ORA-12518 TNSlistener could not hand off client connection [Solved]
- Some solutions to the error of [the underlying provider failed on open]
- PHP FPM: a project website frequently appears 503 problem solving (warning: [pool www] server reached pm.max)_ children setting (50), consi…
- PING[ARC2]: Heartbeat failed to connect to standby ‘gqtzdb_dg’. Error is 16047
- su: cannot set user id: Resource temporarily unavailable
- ValueError: too many file descriptors in select() [How to Solve]