Solve the problem of system slowdown after oracle is installed
Oracle Database is a resource-consuming software. The memory occupied by a single instance service must be at least MB Based on the memory allocated during installation. In addition, other ancillary services must be added, the optical memory occupies about MB of physical memory, and the virtual memory also consumes an equivalent or higher value. Therefore, we want to enable the relevant services when we need to use Oracle, and stop the service at ordinary times.
Tool/raw material oracle11g method/step 1
Click Start to run services. msc to open the Service Management window.
2
Find the fiddler service. These services can be restarted before they are started. Therefore, you can set them to manual
OracleDBConsoleorcl: console service. You only need to use the oracle Enterprise Manager in a browser to start this service. Generally, You can manually disable it.
OracleJobSchedulerORCL: timer service, which generally does not need to be started.
OracleOraDb10g_home1iSQL * Plus: iSQL * Plus service, which must be started only When iSQL * Plus is used on the web page.
OracleOraDb10g_home1TNSListener: Listener service. If a client needs to connect to the database, this service must be enabled, so this service must be started.
OracleServiceORCL: the primary service of the database. This service must be started before oracle can be used. Therefore, this service must be started.
3
Double-click OracleDBConsoleorcl console service
4
Select "Manual" as the "Startup type" and click "OK" to start OracleDBConsoleorcl manually. In the same settings, set other services to manual.
5
To effectively control resources, only OracleOraDb10g_home1TNSListener and OracleServiceORCL services can be started when oracle database is used.
6
Right-click the service to be started and click "start". You can also double-click the service to start the service process.
7
After it is started, you can see that the system has started two essential oracle services. In this case, you can run an application or use a connection tool to connect to oracle for operations.
Use batch processing to manage oracle services
1
For those who often operate on oracle, batch processing is undoubtedly the most convenient and quick method. In this way, you do not need to enter the service desk or start or close a service one by one. First, create two text files.
2
Enter the batch processing commands for starting and stopping the oracle service in the text.
3
Then save it as a bat-type batch file.
4
This directly runs the corresponding batch file for starting or stopping the service. You can start and close the oracle service. Of course, if you need more services, you can also manually add them.