It should be possible to rule out the cause of the virus, continue to check the system core memory, and find the system core The number of unpaged memory reached 120M at the time of failure, and it was only about 30M at startup. Processing step 2: The task manager cannot be opened may be caused by a virus, but the database server never installs and runs new software, and Rising anti-virus software is also installed.

As a result, users cannot create new connectionsįault description 2: When tracking the details of the case, the customer reported that sometimes the task manager cannot be opened when the fault occurs

It can be preliminarily ruled out that it is not due to the SGA allocation. Check the operating system's /3GB parameter, Oracle 's SGA parameter and the number of client connections. Processing step 1: Firstly, determine whether the user cannot create a new connection due to Oracle 's SGA allocation is too large. The following content is reproduced from: įault description 1: The client reports that the client cannot connect to the database server every few days, indicating that the listener cannot resolve the proprietary server process. After restarting successfully, you can execute poolmon in the command line You can type cmd in 'Start -> Run', click OK to open the command line window, (note: all command line programs in this article can first use cmd to open a window similar to dos mode), and then type commands and parameters in the window, Execute the command line program: gflags -r +ptg The meaning of the parameter will be explained when the GUI version of gflags is introduced.ģ. Before using Poolmon.exe, you must run gflags. In the following, combined with the use of Poolmon.exe, the command line version will be introduced for both.ġ. This kind of intersecting usage dazzles people who are not familiar with their interrelationship. What's more troublesome is that the program gflags, like some programs introduced earlier, has a version that adapts to both environments. In addition, this tool also needs a program called gflags to cooperate. Unlike other command line programs, this program needs to be loaded and run before you can get the 'online' prompt help information. Reducing holes can improve the efficiency of memory usage and prevent memory waste. The so-called 'hole' in the memory refers to the area that is originally available for use but not actually used. This tool can monitor the total number of pages used in the memory and the non-page 'memory pool' to detect whether there are 'holes' in the memory.

Cannot find poolmon.exe