Today all of a sudden connection process, prompt connection timeout, in Plsql login also want to log in a few minutes to be able to login successfully, add and delete normal speed, to query the number of connections to more than 300, 3200, set up the biggest
On the database server directly up sqlplus/as sysdba, login soon,
After shutdown immediate startup back to normal after the remote login speed also normal,
But after a few hours, also not line,
Excuse me why? You have met?
CodePudding user response:
1. Check the number of connections, a few, are normal,2. Check the hard disk space, and have abundant,
3. Check the table space, found that the system and sysaux utilization rate has reached ninety-nine percent, and then, decisive adjustments, but still not solve the problem, (below) for the use of adjusted
4. Listen again to view the log, log files are cleaned up, the original is 300 M, and clean up after a few M now, is the problem