Rookie, a company of IC card system, background database is oracle, the server is server2012, usually also even to brush the entrance guard system and the dining room for intermediate consumption machine, system will not come up suddenly this morning, found CPU100 % into the server, use oracle instance, database has not been in, even can only restart the instance service, have a great god know why?

CodePudding user response:

Don't know if your system have installed similar zabbix monitoring, the ash report higher CPU time, or in combination with dba_hist_active_session to see what was in the SQL execution or produced what wait, general CPU suddenly soared should be some batch script in execution, just those SQL and write more bad, the CPU is eat full,

CodePudding user response:

At ordinary times the number of connections as 30 a few

CodePudding user response:

Who runs AWR question take time