Some of the basics of Oracle have been learned some time ago, and for ease of practice and operation, an Oracle 10g was installed. After the installation, the book was directly discarded. Card to the death, card to directly can only be used as the Internet. At that time because of busy also do not do other things, so has not been in charge of it. Make up for the last Internet café. The two days are free. So I tried to solve the problem. I think most developers of this problem should know why. Right. Is that some Oracle background services start up automatically. A large amount of memory was consumed after startup. So the solution to this problem is to turn off some of Oracle's boot services. When you use Oracle, you can manually open it. Let's take a look at how to shut down and open the Oracle service program.
One: Right click on My Computer-"service, find the following service programs
Shut down a few of the above service programs. Then set the startup mode to start manually. If you want to use Oracle, you can start these services.
Two: Close and open the service in the form of a script
Set up "Turn on or turn off Oracle services. TXT" To add the following code:
@echo off title Oracle Service Management CLS Color 2f goto Menu:menu CLS Echo.
=-=-=-=-=oracle Service Management =-=-=-=-= Echo. Echo.
1 Open service echo. Echo.
2 off the service echo. Echo.
3 Exit Echo. Echo. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Echo. Please enter the serial number of the selected item: set/p id= if "%id%" = "1" goto cmd1 If "%id%" = "2" goto CMD2 if "%id%" = "3" Exit echo Please enter the correct serial number.
&ping-n 2 127.1>nul&goto menu:cmd1 echo. Echo Opens Oracle Services ... net start|findstr/i/C: "ORACLEDBCONSOLEORCL" >nul&&set k=1| | Set k=0 if%k%==0 (net start "ORACLEDBCONSOLEORCL") Net start|findstr/i/C: "Oracleoradb10g_home1isql*plus" >nul&& Amp;set k=1| | Set k=0 if%k%==0 (net start "Oracleoradb10g_home1isql*plus") Net start|findstr/i/C: "Oracleoradb10g_home1tnslistener" & Gt;nul&&set k=1| | Set k=0 if%k%==0 (net start "Oracleoradb10g_home1tnslistener") Net start|findstr/i/C: "ORACLESERVICEORCL" >nul&& Amp;set k=1| |
Set k=0 if%k%==0 (net start "ORACLESERVICEORCL") echo.
Echo Oracle Service has successfully opened ... echo.
Pause Exit:cmd2 Echo. Echo Closes the Oracle service ... net STArt|findstr/i/C: "ORACLEDBCONSOLEORCL" >nul&&set k=1| | Set k=0 if%k%==1 (net stop "ORACLEDBCONSOLEORCL") Net start|findstr/i/C: "Oracleoradb10g_home1isql*plus" >nul&& Amp;set k=1| | Set k=0 if%k%==1 (net stop "Oracleoradb10g_home1isql*plus") Net start|findstr/i/C: "Oracleoradb10g_home1tnslistener" & Gt;nul&&set k=1| | Set k=0 if%k%==1 (net stop "Oracleoradb10g_home1tnslistener") Net start|findstr/i/C: "ORACLESERVICEORCL" >nul&& Amp;set k=1| |
Set k=0 if%k%==1 (net stop "ORACLESERVICEORCL") echo.
Echo Oracle Service has successfully shut down ... echo. Pause exit
Then change the file's suffix name to a bat file and run the file, and you can see the following interface:
Depending on your choice, you can turn on or off Oracle's related services.