A number of services are started by Oracle9i when it's installed on Windows OS. These services consume a lot of resources and should be shut down when they are not needed. The following is information on various services started by Oracle on Windows.
- OracleServiceXXX (XXX is SID): It's the only service that needs to be running to be able to work with a database locally. The default startup type will be Automatic for this service, so if you are working with a remote database change the startup type to Manual.
- OracleOraHome92TNSListener: This service is only needed if the database will be accessed remotely. The default startup type will be Automatic for this service, so if you are working with a local database change the startup type to Manual.
- OracleOraHome92HTTPServer: It's for the Apache server that you automatically install when you install Oracle. You generally only need it to access Web pages in the Oracle Apache directories, such as JSP pages.
- OracleOraHome92ClientCache: This service caches Oracle Names data for connecting to remote databases. It is normally configured for Manual startup type. However, it isn't necessary to run this service unless you have an Oracle Names server running somewhere.
- OracleOraHome92Agent: This one monitors the database and Enterprise Manager requests. It's an Automatic startup type of service.
- OracleOraHome92PagingServer: Manual
- startup type service which sends alerts out through an alphanumeric pager via a modem or e-mail.
- OracleOraHome92SNMPPeerEncapsulato & OracleOraHome92SNMPPeerMasterAgent: These two services are typically used to handle the OracleOraHome92PagingServer service.
- OracleMTSRecoveryService: This one is an optional service which allows your database to be used as a resource manager for the Microsoft Transaction Server, COM/COM+ objects and transactions in a distributed environment.
In case you do not use your database extensively, it's a better idea to create a simple batch file to start up and shut down these services easily. This way you can save your system's valuable resources.
German M. writes:
Yes, certainly, it has been identified that the Windows OS process is the main cause why PCs run slowly. In order to troubleshoot this issue, I would appreciate if you could explain how we can change and save this parameter in a PC. Thanks in advance.
As far as controlling parameters is concerned, you can follow these steps to do it:
- Click on the Start button (on screen) or press the Windows button (on keyboard) and select the "Run" option.
- Type services.msc in the Run dialog and hit the Enter button.
- The services window will open, which shows all the services that Windows OS hosts.
- Now select the service which you want to control.
- For example, let's say we don't want the service named "OracleOraHome92TNSListener" to be running.
- Go to that service and double-click it.
- A dialog box will open which will give you all the options to control that service.
- You may start, stop or control the startup type of that service from here.
This was first published in June 2006