Everybody is good, consult an oracle database is shut, restart,

A set of procedures, the original operation is very stable, the web server is Tomcat, but do not know why, recently application of sudden slowing,

Often, later found as long as the oracle database shutdown immediate; In the open, the system and run very fast, but later memory footprint to about 10 g is slow again, server memory is 128 g, CPU usage is about 15 to 25, the server running memory 38 g,

Similar this kind of situation, how to deal with, the sudden slowing,

Note: 1. Has modified the oracle connection number, 2. Tomcat have done some optimization according to the Internet, 3. Oracle memory reallocation, 3. Tomcat also cleared the cache,

CodePudding user response:

Who runs AWR report

CodePudding user response:

Certain things or all of the slow slow

CodePudding user response:

refer to the second floor to learning turn response:

specific things slow slow or all

All Windows are slow, good strange, and no deadlocks,

CodePudding user response:

reference GDZCXXZX reply: 3/f

Quote: refer to the second floor to learning turn response:

specific things slow slow or all

All Windows are slow, good strange, and no deadlocks,

Send a who runs awr report and see what's the problem

CodePudding user response:

Have a who runs awr, have a look at the slow SQL, this kind of problem is usually caused by slow SQL